Excellent video, question the column "order total", for the same customer Name, the 1st line have the information, and no information on the row below for the same customer. How can i put this sum , not on the 1st row, but the last row (for the same customer) ? thk yu To be clear: for Company AA, "order total" = 1705, is on the row of the min order date (15/1/2006), how to show this 1705, in the row of the max, ie in the line 22/4/2006 ??
Hi! I'm trying to use your Agg formula in Qlik Sense and there's an error message that says Agg takes at least two parameters. Could you share an alternative formula that would resolve this error message? Thanks!
+Albert That will not give the desired outcome as needed in this scenario. I suggest you do a quick experiment based on this data and scenario and without firstsortedvalue and see what it gives and why.
hi there, i have been watching your videos and found them helpful however i would like to have a question for you privately with regards to cross tables. please if i may have your email address
Thanks for that great explanation for the AGGR()!
Thanks for another good explanation. Keep up the good work!
Thank you for what you have done. Very useful. It's helps a lot.
Thanks for another good explanation.,,
Thanks for this video.
Excellent video, question the column "order total", for the same customer Name, the 1st line have the information, and no information on the row below for the same customer. How can i put this sum , not on the 1st row, but the last row (for the same customer) ? thk yu
To be clear:
for Company AA, "order total" = 1705, is on the row of the min order date (15/1/2006),
how to show this 1705, in the row of the max, ie in the line 22/4/2006 ??
How do we get your dataset to follow along?
Hi! I'm trying to use your Agg formula in Qlik Sense and there's an error message that says Agg takes at least two parameters. Could you share an alternative formula that would resolve this error message? Thanks!
This will be more useful when we have chart and table box ... Where chart shows count or sum of records of table ... As table gives unique records.
can you please tell me in ordertotal ,the value 13810 is same or it is 1381.0 because if 13810 is correct then this value would be greater
Very good scenario.
Couldn't you have just put in Customer Name as the expression instead of doing the first sorted value? What would it have shown?
+Albert That will not give the desired outcome as needed in this scenario. I suggest you do a quick experiment based on this data and scenario and without firstsortedvalue and see what it gives and why.
hi there, i have been watching your videos and found them helpful however i would like to have a question for you privately with regards to cross tables. please if i may have your email address