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
That works but I need it to rank on just the one dimension field names "Item".
Thanks in Advance
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)
QlikView consultant at egbs consulting ab
Blog (in Swedish): bi-effekten.se