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

Announcements
Discover how organizations are unlocking new revenue streams: Watch here
cancel
Showing results for 
Search instead for 
Did you mean: 
infosense_devel
Creator II
Creator II

Rank () is not working as expected.

Hello all,

i have one pivot table chart in which i am showing data based on TOP 20 Negetive Difference.

now table now showing 2nd rank, it is showing 1,3,4,5,6,7 and so on.....

Can any one suggest?

Thanks in advance.

11 Replies
infosense_devel
Creator II
Creator II
Author

Got the reason.. customer_group is "-" for rank 2.....

as soon as i removed all dimension from table and added again it shows rank 2 with "-".

its_anandrjs
Champion III
Champion III

Check the attached qvw file for just explaining Rank functionality but it does not seems the "-" will effect your rank kindly check your expression with one by one adding the dimension and check with the expression also.

I agree with the HIC here also