Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Providing more than one condition in Layout

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

1 Solution

Accepted Solutions
MVP
MVP

Providing more than one condition in Layout

Hi

Your condition looks OK, but you could also try

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

Hope this helps

Jonathan

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
4 Replies
MVP
MVP

Providing more than one condition in Layout

Hi

Your condition looks OK, but you could also try

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

Hope this helps

Jonathan

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
SunilChauhan
Esteemed Contributor

Providing more than one condition in Layout

no need to write in double quotes (" ")

use below instead

=Value=1 and vDetailId=2

Re: Providing more than one condition in Layout

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

Not applicable

Re: Providing more than one condition in Layout

Thanks !!!   This worked like magic