Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Hi,
PFA sample app.
Use calculated dim for Div and spress NULL
=if(Div<>'Div22',Div)
Hi,
PFA sample app.
Use calculated dim for Div and spress NULL
=if(Div<>'Div22',Div)
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.
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