topic Rank Function need desired output in QlikView

Rank Function need desired output

Thu, 09 Jul 2015 12:56:23 GMT

Help me out in getting desired output. I am trying to get ranking to aggregated data. One expression is giving wrong output please find the yellow marked column in output and expected output.

Aggr(Sum([Value]), Agent,Comtype,POS,OD)

Aggr(FirstSortedValue(Name, -aggr(max(Value),Agent,Comtype,POS,OD,Name)), Agent,Comtype,POS,OD)

aggr(max(Value),Agent,Comtype,POS,OD)

Aggr(FirstSortedValue(Name, -aggr(max(Value,2),Agent,Comtype,POS,OD)), Agent,Comtype,POS,OD) (this is the expression

giving wrong output.

aggr(max(Value,2),Agent,Comtype,POS,OD)

Aggr(FirstSortedValue(Name, -aggr(max(Value,3),Agent,Comtype,POS,OD)), Agent,Comtype,POS,OD)

aggr(max(Value,3),Agent,Comtype,POS,OD)

Re: Rank Function need desired output

MK_QSL — Thu, 09 Jul 2015 13:07:33 GMT

Your firstsortedvalue is looking wrong... use as below

FirstSortedValue(Name, -aggr(max(Value),Agent,Comtype,POS,OD,Name),2)

Re: Rank Function need desired output

swuehl — Thu, 09 Jul 2015 13:08:34 GMT

If you want to stick with FirstSortedValue(), maybe like this:

=FirstSortedValue( Name, -aggr(sum(Value),Agent,Comtype,POS,OD,Name),2)

Re: Rank Function need desired output

sunny_talwar — Thu, 09 Jul 2015 13:15:34 GMT

Hey Manish, I tried doing this, but it doesn't give correct output for two rows:

Is there a way to handle this with FirstSortedValue() still?

swuehl‌

Best,

Sunny

Re: Rank Function need desired output

Thu, 09 Jul 2015 13:16:41 GMT

Thank You all ............Still getting error not getting desired output.

Re: Rank Function need desired output

swuehl — Thu, 09 Jul 2015 13:27:23 GMT

Maybe

FirstSortedValue( Name, -aggr(Value, Agent,Comtype,POS,OD,Value,Name),2)

Re: Rank Function need desired output

sunny_talwar — Thu, 09 Jul 2015 13:29:27 GMT

Awesome

Re: Rank Function need desired output

Thu, 09 Jul 2015 13:33:47 GMT

Excellent Bro ..........Thank You.

Re: Rank Function need desired output

veidlburkhard — Thu, 09 Jul 2015 14:43:50 GMT

Hi shyamkb18,

sorry to say that, but for me it looks like your data is kind of contradictory:

e.g. for Agent B Business Class BLR with DEL-JP the name F1 has value 50 and 200 in week 1!?!

If you do the changes like this:

Your original expression is working fine.

Regards

Burkhard