Logic within filters

[jd1]

Hi, 

we have data with a multi-level hierarchy. At the same time, the client needs to be able to select elements from within different hierarchy levels. 

E.g. hierarchy is like this

• 1
• 1.1
• 1.1.1
• 2
• 2.1

And the client needs to select 1.1.1 and 2 and the same time. 

After trying ourselves and checking in the forum here, and with qlik support. it seems like we got the answer that this is not possible with Qlik Sense. And the inbuilt tree format list does not allow this. 

Our workaround now is to basically make a single level list that looks like the example above. But the issue that remains is that now the client has to be very careful not to multi-select within the same branch. 

e.g. if the user select 1 and 1.1, then rather than just showing the data for 1, it counts the data of 1 which already includes 1.1 plus the subset data of 1.1, leading to a greater than normal amount that is essentially wrong. 

Does anyone have suggestions on how to solve this? Can there be some logic built in that avoids this double counting? Or any other work around? Widgets? 

thanks

[ajaykakkar93]

hi,

what i understand is data is like below

data:

1
1.1
1.1.1
1.1.2
1.1.3
1.2
1.2.1
1.2.2
1.2.3
1.2.4
1.2.5
2
2.1
2.1.1
2.1.2
2.2
2.2.1
2.2.2

and if user selects 1 then 1.2 & 1.2 should be selected not 1.1.2, 2.1.1 etc...

[jd1]

hi, yes. the main issue is when a user selects e.g. 1 and 1.1. then 1.1 is counted double. as 1 contains the entirety of the child categories. 

this happens by accident but this is a very common accident, so better to technically avoid it. 

is this something where we can build maybe some widget / custom html and embed it to do this?