Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Rank in Straight table by specific dimension

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

1 Reply
Vegar
Not applicable

Re: Rank in Straight table by specific dimension

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

Vegar Lie Arntsen

QlikView consultant at egbs consulting ab

Blog (in Swedish): bi-effekten.se

Please ekskuse my Norglish and Swenglish typos.