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

[ivanyang25]

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

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

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

Thank you for your advise in advance

Ivan

[MK_QSL]

Cyclic Group : Read below blog post.

Create a Cycle Group in Qlik Sense (without extensions)

Drill Down group

Qlik Sense - Drill-down Group Dimension (video)

[ivanyang25]

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

[NZFei]

See the app attached.

Fei