Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

priyalvp24
Contributor

How to do conditional drill down in qlik?

Hi All,

I have Following table.

HeadingAmount
Gross Sale 100
Discount10
Net Sale90
Cogs30
Gorss Profit60

I want to create a drill down dimension.

Level 1 As Heading

Level 2 as

If (Heading='Gross sale',Dimension A,

If (Heading='Discount',Dimension B))

But Its Not WORKING ....

PLEASE HELP.

Regards....

2 Replies
rajeshthakur292
Contributor II

Re: How to do conditional drill down in qlik?

Hi Priyal,

I am not sure why it is not working. Is it because -

Level 1 As Heading

Level 2 as

If (Heading='Gross Sale',Dimension A,

If (Heading='Discount',Dimension B)) !

It should be Gross Sale not Gross sale.

PFA the app where it works perfectly fine.

Thanks,

RT

priyalvp24
Contributor

Re: How to do conditional drill down in qlik?

@Thanks Rajesh...

Its working Man...

Community Browser