Discussion Board for collaboration related to Creating Analytics for QlikView.
I need some help with Aggr on Expression.
I'm trying to get counts from multiple columns and group them by the max of the count.
Here is what I'm trying to do
Then the count of each order will look like this
Now.. I want to make it like
So I used in Straight Table:
AGGR(MAX(COUNT(DISTINCT Item1) + COUNT(DISTINCT Item2) + COUNT(DISTINCT Item3) + COUNT(DISTINCT Item4)), Order_ID
1) Am I using right function and right syntax (i know at least 2nd part is not right)
2) Can you help me to correct this?
hi check the attch file
what you where missing is a line id beacuse each order had more then one line
Thank you for your help.
I have one more question though.
Your aggregation makes perfect sense, but is there a way to display the aggregated # and the items of the max of the aggregation.
From the example top, can I do this? (From your attachment)
So basically, while getting the count also get the items of the rows with largest count value.
Do I need different function for this?
hi check attached