Drill Down level expression value into next level

[#1]

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

[Gysbert_Wassenaar]

Can you post a small example qlikview document that explains what you're trying to do?

[#3 · Accepted solution]

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

[#4]

QlikCommunity Tip: How to get answers to your post?

[HirisH_V7]

Hi,

Can you give your perfect data,

Level1 ,Level 2, Sales Data.

?

-Hirish

[#6]

Thanks for the help.. I will check this link