topic Re: Qlikview Rank Function Discussion. Need Help in QlikView

Qlikview Rank Function Discussion. Need Help

Fri, 21 Nov 2014 06:56:34 GMT

Hi Guys

I am trying to ranking the number cross different hierarchies.

I build a test application

here is my script.

(lvl1-->lvl2-->lvl3-->ALL).

AA:

LOAD * INLINE [

lvl1, lvl2, lvl3, number

s1, r1, d1, 100

s2, r1, d1, 101

s3, r1, d1, 102

s4, r2, d1, 103

s5, r2, d1, 104

s6, r3, d1, 105

s7, r3, d1, 106

s8, r4, d2, 107

s9, r4, d2, 108

s10, r4, d2, 109

s11, r5, d2, 110

s12, r5, d2, 111

s13, r5, d2, 112

];

Then I will rank the number cross the 3 levels.

Ranking in lvl2

=Aggr(Rank(Sum({<lvl2=,lvl1=>} number)),lvl2,lvl1)

Ranking in lvl3

=Aggr(Rank(Sum({<lvl2=,lvl1=>} number)),lvl3,lvl1)

Ranking in ALL

=Aggr(Rank(Sum({<lvl2=,lvl1=>} number)),lvl1)

I use set analysis in the expression to allow user select any level fields and wont impact the result.

Please see the attached qvw file.

Everything above are working perfectly. My problem is: when I use the same method in the real application.

Sometimes it give me unexpected answer? Is there anyone can explain it?

In the 'real' application. Here is the screen shot:

as you can see it total random not ranking properly.

Re: Qlikview Rank Function Discussion. Need Help

MK_QSL — Fri, 21 Nov 2014 07:10:45 GMT

Can you upload documents where you are getting problems.?

Re: Qlikview Rank Function Discussion. Need Help

Fri, 21 Nov 2014 07:32:35 GMT

Sorry my friend, the documents is 10GB and it has the real company data.

I just have another test which create a empty new qvw file then do an binary load from the original QVW file

Then I copy the rank object over and it works very well in the new qvw file.

I think there is northing wrong with "Rank" function.

People who see this thread can use this rank example safely.

I will do few more test and update the results.

Thanks

Re: Qlikview Rank Function Discussion. Need Help

Anonymous — Fri, 21 Nov 2014 08:12:40 GMT

Hi,

Use all the 3 levels in Set analysis will do.

=Aggr(Rank(Sum({<lvl2=,lvl1=,Lvl3=>} number)),lvl2,lvl1)

BR,

Chinna

Re: Qlikview Rank Function Discussion. Need Help

Mon, 24 Nov 2014 00:38:33 GMT

Thanks Chinna

I tried, but not working.

I think if we not select the Lvl3, it won't do.

Thanks anyway.

Cheers

Re: Qlikview Rank Function Discussion. Need Help

Wed, 26 Nov 2014 04:45:25 GMT

Interesting. I got this issue fixed by add a time in the set analysis. and in fact it not change the total figures but reorder the rank. I can't understand it. It is just works.

Ranking in lvl2

=Aggr(Rank(Sum({<lvl2=,lvl1=,time=>} number)),lvl2,lvl1)