topic Re: Show/hide condition based on filter selection in QlikView

Show/hide condition based on filter selection

Thu, 07 May 2015 15:24:34 GMT

I have filter whose values are Yes /No

So based on the below conditions i want to show/hide an object

if filter is no or no values is selected or both the values are selected then apply to expression 1
if filter is yes or no values is selected or both the values are selected then apply to expression 2

I having issues implementing all the three conditions at once. I hoping someone can help me to figure this thing out?

Thanks in advance.

Re: Show/hide condition based on filter selection

Thu, 07 May 2015 15:38:51 GMT

Can you post an example qvw?

thanks

Re: Show/hide condition based on filter selection

Thu, 07 May 2015 15:40:27 GMT

Maybe something like...

=if(
(GetFieldSelections ([YourFlag])='no'
or GetSelectedCount([YourFlag])=0
or GetSelectedCount([YourFlag])=2
)
,Expression1
,Expression2
)

Looking at your original post I'm not sure your conditions are quite right?.. where no value is selected or both values are selected both expression 1 and and expression 2 would apply. Is that what you mean?

Re: Show/hide condition based on filter selection

Gysbert_Wassenaar — Thu, 07 May 2015 15:42:56 GMT

if filter is no or no values is selected or both the values are selected then apply to expression 1

for expression1: =max(match(YesNoField,'No'))

if filter is yes or no values is selected or both the values are selected then apply to expression 2

for expression2: =max(match(YesNoField,'Yes'))

Re: Show/hide condition based on filter selection

Gabriel — Thu, 07 May 2015 15:47:07 GMT

Hi,

What I will look to do is have a variable in Variable Overview window or move it into the script (entirely up to you) but it content will be

vTest = IF(IsNull(Data) OR GetCurrentSelections(Data) ='No' ,0, 1)

Please note

Data here is the field you want to monitor so replace it with the field of interest to you.

Then in the object you want to show or hide. Go to the properties - Layout - Show Conditions and enter vTest = 0.

When you make selection in the field you want to monitor the object will disappear.

Try this

Re: Show/hide condition based on filter selection

Thu, 07 May 2015 15:54:40 GMT

You can solve that issue setting up an "array variable"

Check the attached example

Re: Show/hide condition based on filter selection

Wed, 23 Dec 2015 19:14:39 GMT

I have a similar, likely easier scenario. Can you assist?

I have field (Project) that contains 'n' number of project values.

I want to create a Text Object that will only show the Project value when a user selects 1 value from the 'Project' List Box selection; Else the Text Object should not show. I don't want to use a Button to drive this, simply the user selects a project value and then this Text Object displays that Project value, else the Text Box object doesn't show. Thanks!!