Configure a drill-down dimension by typing its name in the dimension expression

[kdandekar]

Hi,

Can we configure a drill-down dimension for a chart, by typing in the drill-down dimension name, instead of selecting the drill-down dimension from the list of master dimensions?

I need this, as I want to configure my chart dimensions based on an external configuration file.

Thanks,

KD

[lorenzoconforti]

I don't think you can do it using a master drill down dimension

You can define your own drill down using a variable; you would define your variable with something like:

=if(GetSelectedCount(Field1)=0 ,'Field1',

if(GetSelectedCount(Field1)>0 and GetSelectedCount(Field2)=0,'Field2',
if(GetSelectedCount(Field2)>0 and GetSelectedCount(Field3)=0,'Field3',
if(GetSelectedCount(Field3)>0,'Field4')
)
)
)

Then in your dimension field you would evaluate that variable to make the drill down work. You are then free to apply any logic you need in the dimension field

[kdandekar]

I had tried a similar work around using 'Pick-Match' in place of 'If' statements, but the problem with this work-around is Qlik Sense marks all values (i.e. even those present in sub-levels) of the drill-down dimension as selected (i.e. it selects values for all dimensions present in the 'If' Statement), this is not intuitive for end-user as to why all the sub-dimension values get selected, which is not the case with the real drill-down dimension..

Example, when I select HOME ELECTRONICS from Product Category.. I also see selections for Product Sub Category and Product Name.. (which are the drill-down dimensions)

Thanks,

KD

[lorenzoconforti]

It doesn't happen to me with the if statements; as I drill down, subsequent selections are applied in the correct order (i.e. without selecting elements from levels I haven't drilled down into yet)

See an example here of how I've implemented it; you can download the qvf file:

https://community.qlik.com/t5/Qlik-Sense-Documents-Videos/Qlik-Sense-UK-Maps/ta-p/1634345

[kdandekar]

I tried with the IF statements, but no luck, Qlik Sense is selecting the sub-level values as well. I am working with a simple bar-chart.. but I will check the Maps solution shared by you, to see if it provides any breakthrough ...

Thanks,

KD

[lorenzoconforti]

If you want to share your dashboard I can have a look

[kdandekar]

Thanks in advance for sparing time for this.. and wish you a Happy New Year!

I am attaching a sample dashboard qvf, which highlights my issue, where selecting a drill-down dimension (based on IF) selects all sub-level values.. 

Thanks,

Kedar

[lorenzoconforti · Accepted solution]

Please see attached. When I developed my dashboard, I was having exactly the same issue you are having. I've worked around it creating the two new variables you see in the dashboard.

One important thing; the dimension field needs to look exactly like in the screenshot below "  '$(dimensionUse)' ". If you go into the dimension (i.e. clicking on the fx button) and then come out, Qlik Sense will add square brackets which will stop the drill down from working; the trick is to populate the dimension field without opening the edit expression window

[kdandekar]

👍Thanks for the work around !!