Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On May 18th at 10AM EDT we will answer your QlikView questions live. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
ruzvmun
Contributor II
Contributor II

Filtering with Static Ranking using Set Analysis

Hello all,

Really short on time, apologies if solution to this already exists and I hope I explain this well.

I am trying to create a ranking that is static even after selections/filters.

The expression I currently have is:

 Aggr(ceil(rank(sum(ORG_SALES)/sum(GLOBAL_SALES))),SalesMan)

The filtering is applied on a hierarchy as below

1.Team

2.District

...with SalesMan in the expression coming under District in the hierarchy.

By default, the ranking should show for all Teams or entire company.

Selecting Team -> District should limit the number of records but the ranking should stay the same

Can someone assist me, I apologize I dont have sample data, trying to get this out ASAP

Thank you in advance,

 

 

2 Replies
chrismarlow
Specialist
Specialist

Hi,

You can try cancelling the selections on the rank through set analysis & then multiplying by Avg(1) (to which selections apply), so something like below from a toy set of data.

No selections;

20201204_1.png

Then with a selection the ranks are the same;

20201204_2.png

Cheers,

Chris.

ruzvmun
Contributor II
Contributor II
Author

Thanks Chris. I will try that.

I did however ended up trying the below

Aggr(ceil(rank(sum({1<Team=>}Sales)/sum({1<Team=>}Global_Sales))),SalesMan)

and it appears to work for now.