Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor
Contributor

How to Filter Group Dimension Values

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.

1 Solution

Accepted Solutions
Highlighted
Specialist
Specialist

Hi,

 

PFA sample app.

Use calculated dim for Div and spress NULL

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

View solution in original post

3 Replies
Highlighted
Specialist
Specialist

Hi,

 

PFA sample app.

Use calculated dim for Div and spress NULL

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

View solution in original post

Highlighted
Partner
Partner

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.

Highlighted
Digital Support
Digital Support

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

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.