Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
farheenayesha
Creator
Creator

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)
18 Replies
farheenayesha
Creator
Creator
Author

Yes i tried. But i was not so clear so didn't get the result.

farheenayesha
Creator
Creator
Author

Hi Sunny,

When i am using both National and regional ranking together,  it is giving incorrect regional ranking. Please find the snapshot below. Regional ranking should be from 1 to 7.

Untitled.png

 

Please help me to get the correct regional ranking along with national. 

sunny_talwar

Help how? Please attach a sample or provide more details 🙂

farheenayesha
Creator
Creator
Author

Hi sunny,

Please find the qvf attached. Please refer sheet 'Division'.

farheenayesha
Creator
Creator
Author

Hi Sunny,

Attached sample data and qvf. Please help.

farheenayesha
Creator
Creator
Author

Hi Sunny,

Attached sample data as well. Please help.

farheenayesha
Creator
Creator
Author

Hi Sunny,

Attached sample data as well. Please help.

sunny_talwar

May be this

Aggr(Rank(Sum(Sales)-Sum(Base)), COMM_CAT, DIV_NM) * Avg(1)
farheenayesha
Creator
Creator
Author

Perfect !! You are great. Thank you so much Sunny.