topic Re: How to Filter Group Dimension Values in QlikView

How to Filter Group Dimension Values

HRITHIKROSHAN888 — Wed, 03 Jun 2020 13:48:16 GMT

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.

Re: How to Filter Group Dimension Values

AbhijitBansode — Wed, 03 Jun 2020 14:09:00 GMT

Hi,

PFA sample app.

Use calculated dim for Div and spress NULL

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

Re: How to Filter Group Dimension Values

whiteymcaces — Wed, 03 Jun 2020 14:10:39 GMT

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.

Re: How to Filter Group Dimension Values

Brett_Bleess — Thu, 25 Jun 2020 20:49:44 GMT

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