Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
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

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