Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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)
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
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
In Chart Properties --> Tab Layout --> Show --> Conditional
expression region='International'