topic Re: Show condition with 2 variables in QlikView

Show condition with 2 variables

Thu, 16 Jul 2015 16:13:04 GMT

Hi everyone,

is it possible to set up the show conditional of a list box on 2 variables?

I want to set 2 variables with 2 different buttons and if there is the right combination the list box should appeare.

With just 1 variable it works easy, but how can I handle 2?

Thanks for helping

Re: Show condition with 2 variables

qlikmsg4u — Thu, 16 Jul 2015 16:14:37 GMT

try show condition with if statement.

Something like =If($(vVar1)=1 and $(vVar2)=2,1,0)

Re: Show condition with 2 variables

maxgro — Thu, 16 Jul 2015 16:19:10 GMT

just a small example, listbox visible when condition on variables v1, v2 is

v1 and v2

Re: Show condition with 2 variables

Fri, 17 Jul 2015 07:07:23 GMT

I've tested it and the more I think about it, the less sense makes it for me to use an if statement.

The normal usage of 'Show' 'Conditional' is something like: put vVar1=1 in the field. In this case the Box is shown if the variable vVar1=1 it is not necessary to create an own if statement. But the Problem is, a connection with 'and' is also not working.

Do u have any other ideas?

Re: Show condition with 2 variables

Anonymous — Fri, 17 Jul 2015 07:13:45 GMT

it should work with 2 conditions which are connected with "and"

but other possibility would be to use a new variable which handles the state of your 2 bttuons

and the state you Need.

then us this new variable in your condition (newvar=1)

Re: Show condition with 2 variables

Fri, 17 Jul 2015 07:15:55 GMT

Unfortunately, the example that you show does not work, because you've only used the variables, but it does not depend of the value of the variable. Just the existance of the variable is not sufficient. In addition, the connection with and, unfortunately, does not work.

Any other ideas?

Re: Show condition with 2 variables

Fri, 17 Jul 2015 07:20:28 GMT

it do not work with 2 conditions which are connected with 'and'

can u give me more details or a explicit example how u would handle 1 variable with 2 buttons?

Re: Show condition with 2 variables

Kushal_Chawda — Fri, 17 Jul 2015 07:27:19 GMT

Try,

vShow1 or vShow2

vShow1 and vShow2

Re: Show condition with 2 variables

Fri, 17 Jul 2015 07:29:35 GMT

Not sure what you mean by 'Just the existance of the variable is not sufficient'. And as you mentioned, If condition is not required. If both the variables' values are numeric and something other than zero (0), then the condition becomes TRUE and the object will be visible.

Can you give more details like, what you are doing when the buttons are clicked etc. Upload a sample QVW for quick resolution.

Regards,

KKR

Re: Show condition with 2 variables

Fri, 17 Jul 2015 07:34:07 GMT

The first button set vVariable1=0 the second button set vVariable2=1.

The Listbox should be shown if there is the combination of vVariable1=0 and vVariable2=1

Re: Show condition with 2 variables

Anonymous — Fri, 17 Jul 2015 07:35:16 GMT

like the attached example?

Re: Show condition with 2 variables

Fri, 17 Jul 2015 07:37:50 GMT

I know my example here is using fields and not variables but there is no reason why it shouldn't work with multiples.

=sum( {<_Metric#={2}>} _Metric#) and sum({<_MetricPeriod#={101}>}_MetricPeriod#)

I am using the above in a conditional show and it works like a charm

Oli

Re: Show condition with 2 variables

Fri, 17 Jul 2015 07:43:30 GMT

In this case, you have to use IF condition like If(vVariable1=0 and vVariable2=1,1,0). If you don't want to use IF condition, then set the variable vVariable1 to some other number other than 0 (zero) when the button is clicked. Then you can simply use vVariable1 and vVariable2

Regards,

KKR

Re: Show condition with 2 variables

Fri, 17 Jul 2015 07:46:20 GMT

Hi thx for that example, the idea is quiet good.... but... now the two buttons are no longer independent... and where have u done the combination of the Var1 and Var2 to create VNew?!

Re: Show condition with 2 variables

Fri, 17 Jul 2015 07:49:17 GMT

the problem is, I have to use vVariable1=0 ...if I change it, I have to change the whole structure of the document 😞

Re: Show condition with 2 variables

Anonymous — Fri, 17 Jul 2015 07:51:39 GMT

under tab Settings/variable overview you can define variables

in the example you will find the 3 variables V1, V2 and VNew

can you post your requirments for the 2 Buttons and variable? when the listbox should exactly Show and

when not

be Aware that these defining a variable here will not preserve the value if you

reduce your app with and save it

better: place the variable Definition in script

Re: Show condition with 2 variables

Fri, 17 Jul 2015 07:54:30 GMT

Then use If(vVariable1=0 and vVariable2=1,1,0)

Regards,

KKR

Re: Show condition with 2 variables

Fri, 17 Jul 2015 07:56:39 GMT

2 independent buttons. Button1 set vVar1=0. Button2 set vVar2=1. List Box should appeare if there is the combination of vVar1=0 and vVar2=1 else nothing to see.

Re: Show condition with 2 variables

Anonymous — Fri, 17 Jul 2015 08:10:37 GMT

like the attached app?

Re: Show condition with 2 variables

Fri, 17 Jul 2015 08:16:15 GMT

Perfect, thank you so much