topic Re: Multibox: Filters should appear based on conditions in QlikView

Multibox: Filters should appear based on conditions

Wed, 26 Feb 2014 10:32:37 GMT

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

alexandros17 — Wed, 26 Feb 2014 10:39:47 GMT

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 — Wed, 26 Feb 2014 10:55:47 GMT

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

Thanks

Wed, 26 Feb 2014 11:00:35 GMT

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

Wed, 26 Feb 2014 11:11:30 GMT

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