topic Re: rank problem in QlikView

rank problem

vikasmahajan — Fri, 10 May 2013 07:34:00 GMT

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

Re: rank problem

kumarnatarajan — Fri, 10 May 2013 07:48:35 GMT

Hi,

Try This one:

Ex: aggr(NODISTINCT Rank(Sum(Values)),FieldName)

FieldName = Your Group Name / Month

Re: rank problem

er_mohit — Fri, 10 May 2013 07:49:14 GMT

write

num( rank( sum( Values), 4))

num(aggr( rank( sum( Values), 4),Brand,Month)

Re: rank problem

Fri, 10 May 2013 08:05:38 GMT

rank(aggr(NODISTINCT sum(Values),Brand),4)

Re: rank problem

vikasmahajan — Fri, 10 May 2013 08:06:06 GMT

Thanks for reply

Both are not working

Vikas

Re: rank problem

kumarnatarajan — Fri, 10 May 2013 08:16:40 GMT

Hi Vikas Mahajan,

Send sample file

Re: rank problem

rustyfishbones — Fri, 10 May 2013 09:01:44 GMT

Maybe this video could help you

https://www.youtube.com/watch?v=MypobUg-HkE&feature=youtube_gdata_player

Re: rank problem

er_mohit — Fri, 10 May 2013 09:18:39 GMT

i tried above code for my components and mat id to find sum of no. of quantity and it works fine for me,here look acc. to my example

Aggr(num( rank( sum( [No. Of quantity]), 4)),mat_id,components)

try acc. to your field format like this

Aggr(num( rank( sum(Value ), 4)),Brand,Month)

hope it helps

Re: rank problem

vikasmahajan — Fri, 10 May 2013 09:22:39 GMT

Please find qvw attached files

Re: rank problem

er_mohit — Fri, 10 May 2013 10:02:30 GMT

Because you drag your dimension month for that reason it gives you nul value and where it find the value show that

now you simply write this code

num( rank( sum( Value), 4))

hope it helps

Re: rank problem

vikasmahajan — Fri, 10 May 2013 10:32:32 GMT

Thanks

Re: rank problem

rustyfishbones — Fri, 10 May 2013 15:01:05 GMT

Did the video help?

Re: rank problem

rustyfishbones — Fri, 10 May 2013 15:08:21 GMT

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

Re: rank problem

vikasmahajan — Sun, 12 May 2013 11:55:28 GMT

Thanks I view Video help me lot.

Vikas