Skip to main content

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $400 before Dec 31st: REGISTER NOW!
cancel
Showing results for 
Search instead for 
Did you mean: 
priyalvp24
Creator
Creator

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
Neymar_Jr
Creator II
Creator II

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
Creator
Creator
Author

@Thanks Rajesh...

Its working Man...