How to Filter Group Dimension Values

[HRITHIKROSHAN888]

I Created a bar chart using BU_Divison group.  For each BU we have multiple divisons. like below.

lets say i have BU1 , BU2,BU3  

AND Div1,Div11,Div111, under BU1

AND Div2,Div22,Div222 under BU2

AND Div3,Div33,Div333  under BU3

when i click on BU1 then it shows relevant divisions like Div1,Div11,Div111 for the respective measure.

similarly for BU2 , BU3.

when i click on BU2 , i don't want to show Div22. i want to filter Div22 in this particular  bar chart only.

i am using BU_Divison group in various charts ,  so  Div22 should be available in other charts.

[AbhijitBansode · Accepted solution]

Hi,

PFA sample app.

Use calculated dim for Div and spress NULL

=if(Div<>'Div22',Div)

[whiteymcaces]

Create a second field in the same table as BU_Division called "BU_Division1", for example, and remove the association to Div22 for the new field. Then use BU_Division1 in your chart.

[Brett_Bleess]

If either of the above posts helped you get what you needed, we would appreciate it if you would close out the thread by using the Accept as solution button on the post(s) that helped.  If you still require further assistance, please leave an update post.  Here is one additional resource that may prove useful:

https://community.qlik.com/t5/Qlik-Design-Blog/Unbalanced-n-level-hierarchies/ba-p/1474325

Regards,
Brett