Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
IMPORTANT security patches for GeoAnalytics Server available to download: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Drill Down level expression value into next level

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

1 Solution

Accepted Solutions
Not applicable
Author

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

View solution in original post

5 Replies
Gysbert_Wassenaar

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


talk is cheap, supply exceeds demand
Not applicable
Author

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

Not applicable
Author

HirisH_V7
Master
Master

Hi,

Can you give your perfect data,

Level1 ,Level 2, Sales Data.

?

-Hirish

HirisH
“Aspire to Inspire before we Expire!”
Not applicable
Author

Thanks for the help.. I will check this link