Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Attend QlikWorld 2020 and hear keynote speaker, Malcolm Gladwell. Register by February 29th to save $200. Learn More
Not applicable

Toggling multiple charts with variables and conditional show


Hi everyone

I'm trying to set up a system similar to a container to toggle between multiple charts. I'm not using a container because i wish to display a table alongside each chart. I'm using text objectes with an action to" set  variable".

The problem is, i dont know how to disable all other charts when i enable one of the charts. This problem will be best demonstrated by sending you a screen shot.

Picture1.png

You can see that each time i click on the text object it brings a chart up on top of another chart.

Thanks in advance for your help!

Danny

1 Solution

Accepted Solutions
Highlighted

Re: Toggling multiple charts with variables and conditional show

Update: Attaching a sample file for your review.

You can use a nested if statement as a action for a variable. Something like this (for example if you have 5 charts)

If(vVar = 0, 1, If(vVar = 1, 2, If(vVar = 2, 3, If(vVar = 3, 4, 0))))

and then use different conditional show on the layout tab for each of the object

Chart 1 will use the conditional show vVar = 0

Chart 2 will use the conditional show vVar = 1

Chart 3 will use the conditional show vVar = 2

Chart 4 will use the conditional show vVar = 3

Chart 5 will use the conditional show vVar = 4


This will help you hide all charts and show just one chart at a time.


HTH


Best,

S

View solution in original post

2 Replies
Highlighted

Re: Toggling multiple charts with variables and conditional show

Update: Attaching a sample file for your review.

You can use a nested if statement as a action for a variable. Something like this (for example if you have 5 charts)

If(vVar = 0, 1, If(vVar = 1, 2, If(vVar = 2, 3, If(vVar = 3, 4, 0))))

and then use different conditional show on the layout tab for each of the object

Chart 1 will use the conditional show vVar = 0

Chart 2 will use the conditional show vVar = 1

Chart 3 will use the conditional show vVar = 2

Chart 4 will use the conditional show vVar = 3

Chart 5 will use the conditional show vVar = 4


This will help you hide all charts and show just one chart at a time.


HTH


Best,

S

View solution in original post

Highlighted
Partner
Partner

Re: Toggling multiple charts with variables and conditional show

Example :1. Create a variable : v and assign a value 1.

2. Create a txt box actions->add->external->set variable as v =1

3. In chart , layout -> conditional as v=1.

Similarly do it for other charts. Set v=2