topic Re: Conditional show on Tables or Charts in QlikView

Conditional show on Tables or Charts

tinkerz1 — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

Is there an expression that will work on showing Tables & Charts rather then conditional show on dimensions and expressions?

I have limited space and would like to show a series of tables and relevent charts.

If I have pairs like:

Table01 - Chart01

Table02 - Chart02

Table03 - Chart03

Table04 - Chart04

Then I want over lay when a list box is selected a pair of table and chart, how can I do that? I dont want to set up conditional show on each chart or table and expression as they are different charts that share no common dimensions.

Thanks.

Re: Conditional show on Tables or Charts

migueldelval — Wed, 22 Jun 2016 09:09:26 GMT

Hi Neil,

Maybe you can use variables to show graphs and charts. And use a button to show.

If you attach a file, I could help you.

Regards

Miguel del Valle

Re: Conditional show on Tables or Charts

amit_saini — Wed, 22 Jun 2016 09:14:30 GMT

Neil,

This might help u!

Thanks,

Re: Conditional show on Tables or Charts

beck_bakytbek — Wed, 22 Jun 2016 09:16:14 GMT

Hi Neil,

you can create a variable: vShow =1,

and then : use this variable in the button: Actions: Set Variable: Variable: vShow , Value: if(vShow=0,1,0)

and within your objects/sheet: layout>Show Conditional: if(vShow=1,1,0)

i hope that helps to solve your issue

beck

Re: Conditional show on Tables or Charts

migueldelval — Wed, 22 Jun 2016 09:16:49 GMT

Hi Neil,

You can test this example.

Regards

Miguel del Valle

Re: Conditional show on Tables or Charts

Anonymous — Wed, 22 Jun 2016 09:17:03 GMT

Hi,

Have you tried with the "Show Conditional" option in the layout tab ?

Re: Conditional show on Tables or Charts

awhitfield — Wed, 22 Jun 2016 09:26:56 GMT

Hi Neil,

could you mock up a screen shot of what you expect to see?

Andy

Re: Conditional show on Tables or Charts

sampada0810 — Wed, 22 Jun 2016 10:27:32 GMT

Create a variable vShow and set it 1 and handle the flag accordingly whenever to show and hide the object