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

Announcements
Join us in Bucharest on Sept 18th 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.