Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
ivanyang25
New Contributor III

How to create a drill down column which doesn’t exist in original data

Dear Qlik Sense Expert

I am new to QS and I have a question for drill down

Now I have a table as below and I need to create 2 drill down indicators in Qlik Sense which are ‘A’ & ‘B’

‘A’ & ‘B’ don’t exist in any column of original data


1.PNG

The visualization I need is as below.

- When I click ‘A’, which is the indicator we create in the previous step, the pie will drill down to ‘A1’ ’A2’ ’A3’ ’A4’.

- When I click ‘B’, which is the indicator we create in the previous step, the pie will drill down to ‘B1’ ’B2’.

- ‘C’ is the indicator which exists in the original data


2.PNG


May I know if its workable in Qlik Sense? If so, how to accomplish it?

Thank you for your advise in advance

Ivan



3 Replies
MVP
MVP

Re: How to create a drill down column which doesn’t exist in original data

ivanyang25
New Contributor III

Re: How to create a drill down column which doesn’t exist in original data

Kachhia

Thank you for your prompt reply

As I am a front end user thus I don't quite understand the materials you share to me. I can't find connection on them with my case either. Can we do it without writing scripts from back end side?

May I know if its possible for you to do a demo base on my case?

Thanks for your support in advance

Ivan

xufei123
Valued Contributor

Re: How to create a drill down column which doesn’t exist in original data

See the app attached.

Fei