Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
andrespa
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
andrespa
Specialist
Specialist
Author

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
kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

HI,

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

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
MK_QSL
MVP
MVP

Try


Rank(SUM([Actual Revenue]))

Anonymous
Not applicable

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.

viveksingh
Creator III
Creator III

Can you share sample app ?

andrespa
Specialist
Specialist
Author

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.

andrespa
Specialist
Specialist
Author

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.