Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
vijayptcs
Contributor II

Statistics report for Month on Month

Dear All,

I need to create report as attached format.

Please advise.

1 Solution

Accepted Solutions

Re: Statistics report for Month on Month

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)

View solution in original post

9 Replies

Re: Statistics report for Month on Month

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

vijayptcs
Contributor II

Re: Statistics report for Month on Month

Am not understand how to do this...

Please help.

Re: Statistics report for Month on Month

You need to do transpose and Rank expression

Like This

Expression : Sum(Values)/100000

Number format should fixed to Zero

Capture.PNG

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)

Re: Statistics report for Month on Month

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

Capture.PNG

vijayptcs
Contributor II

Re: Statistics report for Month on Month

You really genius Sunny...

Thanks

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

Please explain HRank function...

Re: Statistics report for Month on Month

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)

View solution in original post

Re: Statistics report for Month on Month

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/...

vijayptcs
Contributor II

Re: Statistics report for Month on Month

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

vijayptcs
Contributor II

Re: Statistics report for Month on Month

Hi @sunny,

I want month wise ranking over the company.

Please find the attachment