topic Re: To hide a chart when we select on a particular value in list box in QlikView

To hide a chart when we select on a particular value in list box

polisetti — Sun, 20 Apr 2014 11:15:01 GMT

Hi ,

I need to hide a chart ,When i select on a 'Domestic' value in list box and i need to show the chart when i select on 'International ' value in the list box.

Can you please tell me how to write the expression in layout of the chart.

Thanks

Re: To hide a chart when we select on a particular value in list box

Sun, 20 Apr 2014 11:30:43 GMT

Hi,

You could use a conditional show on the Layout tab:

=if(GetSelectedCount(region)=1,if(region='International',1,0),1)

See attached qvw. for the example.

Cheers,

Paul

Re: To hide a chart when we select on a particular value in list box

Colin-Albert — Sun, 20 Apr 2014 11:50:41 GMT

Use this expression for the conditional show to hide the chart when Domestic is selected and show the chart for other selections.

If(only(region)='Domestic', 0, 1)

Re: To hide a chart when we select on a particular value in list box

its_anandrjs — Sun, 20 Apr 2014 12:45:26 GMT

Please clear requirement in details with a example and if understand clearly when if you select Domestic want to hide International and if select International hide Domestic if so then use below script.

For Domestic chart type this code in the Properties >> Layout >> Show conditional.

=if(GetSelectedCount(region)=0,1,GetFieldSelections(region)='Domestic')

For International chart type this code in the Properties >> Layout >> Show conditional.

=if(GetSelectedCount(region)=0,1,GetFieldSelections(region)='International')

Regards

Re: To hide a chart when we select on a particular value in list box

Joseph_Musekura — Sun, 20 Apr 2014 13:36:51 GMT

Hi,

You could use two layers with below conditions (see
attached *.qvw).

* if (getSelectedCount(region)=1, if (region='Domestic',
1,0), 1) in show conditional of chart 1

* if (getSelectedCount(region)=1, if (region='International',
1,0), 1) in chart 2

Thanks

Re: To hide a chart when we select on a particular value in list box

maxgro — Sun, 20 Apr 2014 19:56:37 GMT

In Chart Properties --> Tab Layout --> Show --> Conditional

expression region='International'