rank problem

vikasmahajan · ‎2013-05-10

Dear All

I have brand and month as dimension now I want to calculate RANK for every month following are my expression for overall

AGGR(RANK (SUM (Values), 4),BRAND)

I wan to calculate Brand wise / Month wise Rank

How Do i acheive the same.

Thanks.

Vikas

Hello

Sample file works with following expression

Aggr(num( rank( sum(Value ), 4)),BRAND,MonthName)

But same not working in LIVE report is not display.

Regards

Vikas

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.

vikasmahajan · ‎2013-05-10

Thanks

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.

rustyfishbones · ‎2013-05-10

Did the video help?

rustyfishbones · ‎2013-05-10

Try the above, I used this to get the Rank of the Sum Value by Month and it resulted in a table like this

Hope that helps

vikasmahajan · ‎2013-05-12

Thanks I view Video help me lot.

Vikas

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.

QlikView App Dev

Related Topics