Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

andrespa
Valued Contributor

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
Valued Contributor

Re: Issue with Rank() function

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.

6 Replies

Re: Issue with Rank() function

HI,

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

Regards,

Kaushik Solanki

MVP
MVP

Re: Issue with Rank() function

Try


Rank(SUM([Actual Revenue]))

khan_fayez
New Contributor III

Re: Issue with Rank() function

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
Contributor II

Re: Issue with Rank() function

Can you share sample app ?

andrespa
Valued Contributor

Re: Issue with Rank() function

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
Valued Contributor

Re: Issue with Rank() function

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.

Community Browser