Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

How to do this in the script

I have a basic row count function in a pivot table. when I use rank function it creates a tie for equals. is it possible to give position as show in the image below and can it be done at script level?

so when there is a tie I want the position not skip 4. so there  will be 2 4's. in other words disregard the usual interpretation of "Rank"

also pls see qvw attached

pivot_table.PNG

11 Replies
sunny_talwar

Not sure what you are still looking for John, did you get a chance to play around with Massimo's or Stefan's expression? That is not meeting your  requirement on the front end?

Anonymous
Not applicable
Author

Hi Sunny, I am closing this thread and have moved my new discussion which is built on the same problem w slight variation to !https://community.qlik.com/message/1108750#1108750

Thank you so much.