Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a straight table that has multiple dimensions, but I want to rank on a specific dimension, how can I do this. Here is my current definition
=
RANk((sum(Quantity)* AVG(NumberOfItemInSet))/IntroDateDif)
That works but I need it to rank on just the one dimension field names "Item".
Thanks in Advance
Hi ljames77
I think you can use the TOTAL aggregation, but ignore your desired fieldname. rank([ total ] expression [ , mode [, format ] ])
RANk(TOTAL <Item> (sum(Quantity)* AVG(NumberOfItemInSet))/IntroDateDif)
Best regards
QlikView consultant at egbs consulting ab
Blog (in Swedish): bi-effekten.se