topic Re: Bar chart drill down issue in Qliksense in App Development

Bar chart drill down issue in Qliksense

abhijith28 — Wed, 01 Dec 2021 14:01:18 GMT

Hi,

I have a issue with drill down feature in Qliksense Bar chart.

Sample data:

Table1:

Load * inline
[
Group,Name,NickName,Age
Group1,A,A1,20
Group1,A,A2,40
Group1,B,B1,22
Group2,B,B2,12
Group3,B,B3,42
Group3,C,C1,12

];

There's a drill down dimension of Name and NickName

If the user selects Group1 then the dimension shows A and B in Bar chart which is perfect.

But when we select Group2, then the dimension of Bar chart displays B2 instead of NewB. How to display NewB when we select Group2?

Kindly assist me on this scenario.

I have attached the sample app.

Thanks & Regards,

Abhijith

Re: Bar chart drill down issue in Qliksense

stevejoyce — Wed, 01 Dec 2021 14:27:47 GMT

This is working as expected for Drill Down dimensions. If there is only 1 possible value of a field (based on selections /available data), it goes down to the next level.

Since you only have 1 Name for Group2 it will go to next level.

I believe your only workaround is to created a calculated dimension with your own logic using getselectedcount and cannot use the native drill down dimension.

something like...

=If(Getselectedcount([Name]>0, [NickName], If(getselectedcount([Group]>0, [Name], [Group]))

Re: Bar chart drill down issue in Qliksense

abhijith28 — Wed, 01 Dec 2021 14:43:28 GMT

Thanks @stevejoyce

Can't we try using Hierarchy function?

I need a drill down feature. If I use calculated dimension then it can't be drilled down to next level.

Is it something Qlik limitations?

Re: Bar chart drill down issue in Qliksense

stevejoyce — Wed, 01 Dec 2021 21:02:23 GMT

I'm not following your last post. Hierarchy function is to manipulate the data (restructure or create fields) for hierarchy purposes. But you already have your hierarchy. Having as a calculated dimension can act as a drill down. Yes there's no way i've ever seen that prevents native drill downs from behaving like this, this is the functionality of drill downs.