topic Providing more than one condition in Layout in QlikView

Providing more than one condition in Layout

Sun, 09 Oct 2011 10:13:55 GMT

Is there a way to provide two conditions in layout? I have a grid which I want to show only if two conditions are fulfilled. I provided the condition in the layout tab as "=Value=1 and vDetailId=2" but this is not working out.

Thanks in Advance

Providing more than one condition in Layout

jonathandienst — Sun, 09 Oct 2011 14:45:46 GMT

Your condition looks OK, but you could also try

=If(Value = 1 And vDetailId = 2, true(), false())

Hope this helps

Jonathan

Providing more than one condition in Layout

SunilChauhan — Sun, 09 Oct 2011 16:21:13 GMT

no need to write in double quotes (" ")

use below instead

=Value=1 and vDetailId=2

Re: Providing more than one condition in Layout

its_anandrjs — Sun, 09 Oct 2011 18:21:24 GMT

Hi,

You have to write in Chart -> Properties -> Layout -> Conditional

and paste a code there

If( Value = 1 And vDetailId = 2 , 1, 0)

And try to set different value for variables Value and vDetailId but it works only when it is 1 and 2

See the attached sample file.

Rgds

Anand

Re: Providing more than one condition in Layout

Mon, 10 Oct 2011 11:24:14 GMT

Thanks !!! This worked like magic