How to do conditional drill down in qlik?

[priyalvp24]

Hi All,

I have Following table.

Heading	Amount
Gross Sale	100
Discount	10
Net Sale	90
Cogs	30
Gorss Profit	60

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....

[Neymar_Jr]

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]

@Thanks Rajesh...

Its working Man...