Skip to main content
Announcements
Global Transformation Awards! Applications are now open. Submit Entry
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