topic Re: Toggling multiple charts with variables and conditional show in QlikView

Toggling multiple charts with variables and conditional show

Sat, 07 Mar 2015 11:45:14 GMT

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.

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

Re: Toggling multiple charts with variables and conditional show

sunny_talwar — Sat, 07 Mar 2015 12:20:54 GMT

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,

Re: Toggling multiple charts with variables and conditional show

simsondevadoss — Sat, 07 Mar 2015 12:32:51 GMT

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