Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Announcing the newest addition to the Qlik Community, Qlik Gallery! Learn More
farheenayesha
Contributor

How to fix the rank irrespective of selection

Hi,

I want to fix the rank irrespective of selection. In the below snapshot, Division 13 has Rank as 14. However, when i select the region in the filter, its rank changes to 7. Please help me to fix the rank. Attaching the dummy data and app.

Capture.PNG

Capture1.PNG

@sunny_talwar 

Labels (2)
1 Solution

Accepted Solutions

Re: How to fix the rank irrespective of selection

Try this

Rank(Sum({<REG_NM>}Sales)-Sum({<REG_NM>}Base)) * Avg(1)
18 Replies

Re: How to fix the rank irrespective of selection

Which tab is this chart on?

farheenayesha
Contributor

Re: How to fix the rank irrespective of selection

Hi Sunny,
Its in Division tab. Please help me to fix the Rank.

Re: How to fix the rank irrespective of selection

I am seeing this from the attached app... how do I get the numbers?

image.png

farheenayesha
Contributor

Re: How to fix the rank irrespective of selection

Sorry. Attaching the correct file. 

Re: How to fix the rank irrespective of selection

Try this

Rank(Sum({<REG_NM>}Sales)-Sum({<REG_NM>}Base)) * Avg(1)
farheenayesha
Contributor

Re: How to fix the rank irrespective of selection

You are genius Sunny. As usual you solved my biggest problem. Thank you so much.
One last question, Please let me know how does Avg(1) works?

Re: How to fix the rank irrespective of selection

This is just to remove rows which are not selected.... Avg(1) = 1 for selection and Avg(1) = 0 for non selection

farheenayesha
Contributor

Re: How to fix the rank irrespective of selection

Thank you so much sunny. Would need your help in the below post as well. Please help.

https://community.qlik.com/t5/QlikView-App-Development/How-to-convert-missing-null-value-to-zero/m-p...


Re: How to fix the rank irrespective of selection

What @dilipranjith has mentioned might be the only way to do this. Have you tried that?