topic Re: Show chart based on value of a variable in QlikView

Show chart based on value of a variable

Thu, 09 Oct 2014 09:22:53 GMT

Hi QlikViewers,

I am having difficulties with the conditional display of charts.

What I am trying to do is:

- I have five charts that should never be shown at the same time.

- I have a variable (vShow).

- I have five buttons that assign values 0,1,2,3 or 4 to the variable.

What is not working:

- The statement that hides Chart A if the value is not equal to 0 (resp. hide Chart B if its not equal to 1, Chart C uneqal to 2 and so on...).

Any help is appreciated.

Thanks,

Lina

Re: Show chart based on value of a variable

amit_saini — Thu, 09 Oct 2014 09:28:54 GMT

Lina,

Hope this will help you.

Thanks,

Re: Show chart based on value of a variable

simenkg — Thu, 09 Oct 2014 09:32:06 GMT

The condtional show condition will simply be:

ChartA:

vShow = 0

ChartB:

vShow = 1

and so on...

Re: Show chart based on value of a variable

PrashantSangle — Thu, 09 Oct 2014 09:33:15 GMT

Hi,

What condition you are trying to implement?

Try like this,

In LAyout->show-> Conditional

Expression -> if(vShow=1,1,0) for chart1

if(vShow=2,1,0) for chart1

if(vShow=3,1,0) for chart1

In your Button

add action->Action->External->set Variable

Regards

Re: Show chart based on value of a variable

Thu, 09 Oct 2014 09:40:22 GMT

It seems to be so simple, but it´s not working for me.

I tried '=vShow = 0' in the Layout > Show > Conditional field. But all it does is disappear. Even if vShow actually is 0.

Re: Show chart based on value of a variable

amit_saini — Thu, 09 Oct 2014 09:43:33 GMT

Please share your application.

Thanks,

Re: Show chart based on value of a variable

Thu, 09 Oct 2014 09:49:18 GMT

Hey guys,

thanks for your help.

Turned out that my buttons weren´t properly assigning the values. I don´t really know why, but by deleting the action and recreating it, I could solve the problem.

Cheers,
Lina