Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Multibox: Filters should appear based on conditions

Hello,

My requirement is to create a 'Multibox' and I am trying to write an expression which should show specific filter.

For example

if> my Business Group(one of the variable) is Server then the 'server'(another variable in my dataset) filter should appear,

else if> my Business group is Networking then 'Network'(another variable in my dataset) filter should appear.

else no filter should appear.

Thanks for your help in advance.

Kind Regards,

Varun

4 Replies
alexandros17
Partner - Champion III
Partner - Champion III

Use as expression of your multibox:

If(myCondition, myField1, myField2)

The only limit is that even if you use null() as myField1 or 2 the space for the filters appears

Hope it helps

sujeetsingh
Master III
Master III

Here i have created a sample as per your query have look may it will help you .

Thanks

Not applicable
Author

Hi Sujeet,

Thanks for your help. I am using a personal edition so cannot open your file. Could you please post the expression instead of sharing qvw file..

Regards,

Varun

Not applicable
Author

Thanks for your reply,

I am already using the same condition but it is not showing filters but 1 and 0. Is there are way to call a particular variable in place of