Discussion Board for collaboration related to Creating Analytics for QlikView.
Category and Item is dimension.
How can i do Rating_quantity and Rating_price? (Rating in category)
Pivot or Strong table - unimportant.
Go to Solution.
=Rank(sum(Qty),4,1) its work! mode 4 and format 1.
Jason Michaelides, tnx for help!
Rank(Sum(TOTAL <Category> Quantity))
Rank(Sum(TOTAL <Category> Price))
Hope this helps,
the result is min-max: