topic Re: Configure a drill-down dimension by typing its name in the dimension expression in App Development

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

kdandekar — Fri, 27 Dec 2019 10:45:02 GMT

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,

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

lorenzoconforti — Fri, 27 Dec 2019 19:09:59 GMT

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

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

kdandekar — Mon, 30 Dec 2019 09:50:26 GMT

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,

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

lorenzoconforti — Mon, 30 Dec 2019 10:11:50 GMT

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

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

kdandekar — Mon, 30 Dec 2019 14:05:21 GMT

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,

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

lorenzoconforti — Mon, 30 Dec 2019 14:11:15 GMT

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

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

kdandekar — Tue, 31 Dec 2019 13:08:20 GMT

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

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

lorenzoconforti — Tue, 31 Dec 2019 14:06:36 GMT

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

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

kdandekar — Tue, 31 Dec 2019 14:29:18 GMT

👍Thanks for the work around !!