Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor
Contributor

Ignore a particular dimension from Multibox based on filter selection

HI There,

 

There's a requirement is my project where I have around 10 dimensions used in my multibox. One of the dimensions is 'Organization ID'. Now the requirement is I want this to be visible in multibox only when Organization ID <> CP (Organization ID isn't CP). For other values, this should appear in multibox. Is this possible? I tried writing 
IF(organizatio ID <>'CP' , Organization ID) in the expression of this dimension while creating the multiple box but this doesn't work.

Help appreciated !

 

Thanks,

Neha

2 Replies
Highlighted
Partner
Partner

Re: Ignore a particular dimension from Multibox based on filter selection

Hi Neha,

 

You can create two multiboxes with all the dimensions same except the one you want to hide. Then make the one with all the dimensions visible only when organizatio ID <>'CP' in the layout of multibox.

Hope this helps.

Cheers,

Ajay

Highlighted
Contributor
Contributor

Re: Ignore a particular dimension from Multibox based on filter selection

Hi Ajay,

 

Thanks for the suggestion. However my application is quite big and having performance issues so I can't afford copying the multibox and doing stuff. This multibox alone has some 20 dimensions. Any other workaround would be appreciated !