Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Highlighted
Not applicable

Rank function

Hello All,

I am running into an issue when using the Rank function.

Requirement:  To design a chart that will show  ITEMS where Rank Sales and Rank Volume <=5.

Below image is the chart return from

DIMENTION: ITEM

TWO EXPRESSION :

          RANK (SUM (SALES))

          RANK(SUM(VOLUME))

Question : How do i eliminate , ITEM G highlighted in yellow from appearing on the chart.

Any suggestions will be appreciated.

Thank you.

Pranita

RANK ISSUE.png

Tags (1)
1 Solution

Accepted Solutions
Not applicable

Re: Rank function

Hello Shrestha,

Replace the item dimension with the following conditional dimension.

=if(aggr(RANK(SUM(VOLUME)),ITEM)<=5 or aggr(RANK(SUM(SALES)),ITEM)<=5,ITEM)

Then check supress if null for the conditional dimension.

Regards,

Kiran.

2 Replies
Not applicable

Re: Rank function

Hello Shrestha,

Replace the item dimension with the following conditional dimension.

=if(aggr(RANK(SUM(VOLUME)),ITEM)<=5 or aggr(RANK(SUM(SALES)),ITEM)<=5,ITEM)

Then check supress if null for the conditional dimension.

Regards,

Kiran.

Not applicable

Rank function

Just the solution I was looking for.

Thank you Kiran !!

Regards,

Pranita