topic Ignore a particular dimension from Multibox based on filter selection in QlikView

Ignore a particular dimension from Multibox based on filter selection

neha_sharma1275 — Sat, 16 Nov 2024 01:47:27 GMT

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

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

ajayrai — Wed, 04 Dec 2019 07:48:44 GMT

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

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

neha_sharma1275 — Wed, 04 Dec 2019 08:27:45 GMT

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 !