Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

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

Activate and deactivate expressions in line chart

Hi everyone,

I have created a line chart with several different expressions. For data analysis purposes I would like to provide an option on the worksheet to enable and disable specific expressions so that the viewer can see what they need to see without clutter. Is there a way to do this in QlikView?

Thank you for the help.

1 Solution

Accepted Solutions
alexandros17
Not applicable

Re: Activate and deactivate expressions in line chart

1) Define a variable (in the script) -> LET myVar = 1;

2) add a button, in triggers add a new trigger -> external -> set variable

3) write your variable (without =) and in the bottom textbox write: if(myVar=1,2,1)

4) in your expression there is a check boc "Conditional", check and write : myVar=1

Hope it helps

4 Replies
alexandros17
Not applicable

Re: Activate and deactivate expressions in line chart

1) Define a variable (in the script) -> LET myVar = 1;

2) add a button, in triggers add a new trigger -> external -> set variable

3) write your variable (without =) and in the bottom textbox write: if(myVar=1,2,1)

4) in your expression there is a check boc "Conditional", check and write : myVar=1

Hope it helps

Not applicable

Re: Activate and deactivate expressions in line chart

Exactly what I wanted. Thank you.

colin_albert
Not applicable

Re: Activate and deactivate expressions in line chart

You can drag one expression over another to create a cyclic expression group.

Then the users can click in the circular arrow to switch from one expression to another

Not applicable

Re: Activate and deactivate expressions in line chart

Actually this only seems to work the first time around and then I can't get the expression to re-appear in the chart. Any idea why this is happening?