topic Re: Hide excluded disabled(Multibox) in QlikView

Hide excluded disabled(Multibox)

Wed, 11 Dec 2013 11:22:52 GMT

Hi I have an expression added to multibox ...Under presentation im unable to locate expression to enable hide excluded option .

Please suggest.

Re: Hide excluded disabled(Multibox)

manideep78 — Wed, 11 Dec 2013 11:32:08 GMT

Hi, In presentation tab select the field which you required and then check Hide exclude option

Re: Hide excluded disabled(Multibox)

Wed, 11 Dec 2013 11:37:49 GMT

It is not direct field...I have added an expression which is not visible under presentation tab.

Re: Hide excluded disabled(Multibox)

manideep78 — Wed, 11 Dec 2013 11:45:52 GMT

Yes, for the Expressions in the multibox you cant give an option Hide Excluded. please tell me your requirement in detail so that I can give an alternate way which might be helpful for you

Re: Hide excluded disabled(Multibox)

Fri, 20 Dec 2013 10:18:04 GMT

What I'm trying to do is create a dynamic filter Type ={A,B,C} as values using inline table...

Suppose if I select Type as A.....Only {A,B,C} possible values should be available in next filter

Ex1: Filter1 ....A

Filter2 ....{A,B,C}

Ex2: Filter1 ....B

Filter2 ....{1,2,3}

Please suggest...Currently I'm using following expression for filter 2 which is displaying all possible values which is not our requirement

Filter2 =if(Type ='A',[Column A],if(Type= 'B',,[Column B],[Column C]))

Data is shown below

Column A	Column B	Column C
A	1	Y
A	2	Y
A	3	Y
A	4	Y
A	5	N
A	6	N
B	1	Y
B	2	Y
B	3	Y
B	4	Y
B	5	N
B	6	N
C	1	Y
C	2	Y
C	3	Y
C	4	Y
C	5	N
C	6	N