Month sale wise rank

[Anonymous]

Hi all,

Please look below thread

Statistics report for Month on Month

In that I have rank sale wise but I need month wise rank function means which company have more sale within this month .

PFA for expected output.

[lakshmikandh]

Hi

Please check this links

https://help.qlik.com/en-US/sense/3.0/Subsystems/Hub/Content/ChartFunctions/RankingFunctions/rank-fu...

Top 5 analysis using Rank fuction

Thanks,

Lakshmikandh

[sunny_talwar]

Vijay that is what you had to begin with, no? Just use

Rank(Column(1), 1, 1)

Rank(Column(1), 2, 1)

Rank(Column(1), 3, 1)

Rank(Column(1), 4, 1)

[sunny_talwar · Accepted solution]

Actually, I think you might be looking for his:

Rank(TOTAL Column(1), 1, 1)

Rank(TOTAL Column(1), 2, 1)

Rank(TOTAL Column(1), 3, 1)

Rank(TOTAL Column(1), 4, 1)

[Anonymous]

Hi Sunny ,

Help is very appreciate.

How I can I sort rank wise I mean first rank always come with first row for all months.

Thanks

[sunny_talwar]

How would you do that?

For instance, lets look at this example

Dim, Sept-15, Oct-15

A, 1, 2

B, 2, 1

How can I put Rank 1 for each Dim on the first row?

[Anonymous]

Yes you right but there is no any option ....

[sunny_talwar]

I don't think so