Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
BI & Data Trends 2021. Discover the top 10 trends emerging in today. Join us on Dec. 8th REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Specialist
Specialist

Issue with Rank() function

Hi, I'm facing and issue that I'm not able to understand. I'm using the Rank() function in both a table and a bar chart. Same dimension and same metric but I'm getting different results. See the images below:

Table.PNGChart.PNG

Did Someone have faced something similar? Any help will be appreciate it.

Cheers,

Andrés

1 Solution

Accepted Solutions
Highlighted
Specialist
Specialist

Solved. It was an issue of the loaded data source. We detected some xls that random generated numbers, so each time the dashboard was loaded the numbers were different.

Thanks everyone for your help.

Cheers.

View solution in original post

6 Replies
Highlighted
MVP & Luminary
MVP & Luminary

HI,

Is it possible to share some sample data which can show the issue which you are facing.

Regards,

Kaushik Solanki

Regards,
Kaushik
If reply is satisfactory, please "Like" the post.
If reply is solution, please mark as "Correct".
Highlighted
MVP
MVP

Try


Rank(SUM([Actual Revenue]))

Highlighted
Creator
Creator

Hi Andres,

Try this expression in the chart:

Rank(sum([Actual revenue]),1,2)

and also sort it by

Rank(sum([Actual revenue]),1,2)

It should work.

Highlighted
Creator III
Creator III

Can you share sample app ?

Highlighted
Specialist
Specialist

It doesn't. But in fact, the issue seems to be related to the sorting because with the same sorting it shows something different in table and in chart. What I can't figure out yet is how on earth is sorting.

Highlighted
Specialist
Specialist

Solved. It was an issue of the loaded data source. We detected some xls that random generated numbers, so each time the dashboard was loaded the numbers were different.

Thanks everyone for your help.

Cheers.

View solution in original post