topic how to show conditional expression in chart in QlikView

how to show conditional expression in chart

raghvendrasingh — Fri, 06 Jun 2014 07:12:34 GMT

Hi All,

Here I'm unable to set the conditional expression in bar chart. The situation is like this , if I click first button then should be shown the first expression value, and if I click second button then should be shown second expression value and if there is no selection then it should be shown all the values. How to show this in bar chart.

Please anyone give me some idea because I'm new in qlikview.

Thanks in advance.

Re: how to show conditional expression in chart

alexandros17 — Fri, 06 Jun 2014 07:15:50 GMT

set two variables in the script:

Let vExpr1=0;

Let vExpr2=0;

in each expressin write in the conditional textbox:

vExpr1=1 (in the first expr.)

vExpr2=1 (in the second expr.)

Now in the buttons (I describe only the first) add a trigger -> external -> set variables and write

in the upper box: vExpr (without equal or other signs)

in the lower write:

=if(vExpr=0,1,0)

The same in the second button

Let me know

Re: how to show conditional expression in chart

amit_saini — Fri, 06 Jun 2014 07:18:18 GMT

Hi Raghvendra,

You can give condition here in layout table under Conditional.

Thanks,

Re: how to show conditional expression in chart

senpradip007 — Fri, 06 Jun 2014 07:19:19 GMT

PFA and go to Sheet1. Hope it helps.

Re: how to show conditional expression in chart

raghvendrasingh — Fri, 06 Jun 2014 07:32:36 GMT

Hi Alessandro,

Thanks for your reply its working when i click first button then it shows the first expression value but when I select second button then its showing first & second both expression values together.

Re: how to show conditional expression in chart

alexandros17 — Fri, 06 Jun 2014 07:36:34 GMT

there are two solution:

1) click the button one time show the expression, click the button again hide the expression (as it works now)

2) add another trigger to each button and set the other variable to 0

trigger 1: =vExpr1=1

trigger 2: =vExpr2=0

in the second butto is the opposite

Let me know ...