Discussion Board for collaboration related to QlikView App Development.
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:
The filtering is applied on a hierarchy as below
...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,
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.
Then with a selection the ranks are the same;
Thanks Chris. I will try that.
I did however ended up trying the below
and it appears to work for now.