Statistics report for Month on Month

[Anonymous]

Dear All,

I need to create report as attached format.

Please advise.

[sunny_talwar]

So what is the issue? What exactly are you not able to do?

[Anonymous]

Am not understand how to do this...

Please help.

[Anil_Babu_Samineni]

You need to do transpose and Rank expression

Like This

Expression : Sum(Values)/100000

Number format should fixed to Zero

[sunny_talwar]

Is the rank not working? Or what is the issue, try HRank(Column(1)) for rank, if that that is your issue

[Anonymous]

You really genius Sunny...

Thanks

But in the rank I am getting like 1-25, 1-5 .

Please explain HRank function...

[sunny_talwar · Accepted solution]

You can try all of these:

Hrank( Column(1), 1, 1)

Hrank( Column(1), 2, 1)

Hrank( Column(1), 3, 1)

Hrank( Column(1), 4, 1)

[sunny_talwar]

HRank is same function as rank but can be used in a pivot table for the pivoted dimension. Read here:

https://help.qlik.com/en-US/qlikview/12.0/Subsystems/Client/Content/ChartFunctions/RankingFunctions/...

[Anonymous]

If i want to add another expression Like YTD sale then how can achieve this

[Anonymous]

Hi @sunny,

I want month wise ranking over the company.

Please find the attachment