Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have Drill Down Group with level 1 and level 2 fields.I'm showing sum(sales) against this drill down.
level 1
a
b
c
d
level 2
aa
ab
ba
bb
bc
.....
report is like
Level 1 Rank(sum(sales))
total 1
a 2
b 3
c 4
when i drill down into a i get
Level 2 Sum(sales)
total Blank
aa 2
ab 3
In column of total of level 2 i need rank of level 1 ie a's rank value (1).
How to achieve this.
plz help me in thew same.
Thanks in advance
if( Dimensionality()>0, rank(sum(sales),4), Max(Aggr(Rank(Sum({<Level1= >}(sales)),4),Level1)) ) |
Ignoring in Set analysis will give you previous level ranking in drilled down level irrespective of sleection in level1
Can you post a small example qlikview document that explains what you're trying to do?
if( Dimensionality()>0, rank(sum(sales),4), Max(Aggr(Rank(Sum({<Level1= >}(sales)),4),Level1)) ) |
Ignoring in Set analysis will give you previous level ranking in drilled down level irrespective of sleection in level1
Hi,
Can you give your perfect data,
Level1 ,Level 2, Sales Data.
?
-Hirish
Thanks for the help.. I will check this link