topic Re: Drill Down level expression value into next level in QlikView

Drill Down level expression value into next level

Wed, 30 Dec 2015 09:02:45 GMT

I have Drill Down Group with level 1 and level 2 fields.I'm showing sum(sales) against this drill down.

level 1

level 2

.....

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 — Wed, 30 Dec 2015 18:45:23 GMT

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

Thu, 31 Dec 2015 09:08:16 GMT

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

Thu, 31 Dec 2015 09:37:35 GMT

HirisH_V7 — Thu, 31 Dec 2015 09:59:22 GMT

Hi,

Can you give your perfect data,

Level1 ,Level 2, Sales Data.

-Hirish

Thu, 31 Dec 2015 11:16:26 GMT

Thanks for the help.. I will check this link