Hiding a chart expression

[#1]

Hello everyone,

I have a chart expressions, PoundChartExpression, DollarChartExpression, OrderChartExpression, and inside
them are calculations, i.e. sums,averages, etc...

I have an input box and in it are predefined list information. The list information are
pound, dollar, and order.

What I'm trying to accomplish is when the POUND is selected from the INPUT box, it will
disable the DollarChartExpression and the OrderChartExpression and just leave the PoundChartExpression.

How do you disable a chart expression based on what the selected/entered INPUT box data?

Thanks for your help.

Sincerely,
Reyn

[#2]

The sample app contains a listbox selection instead of the input box. In the presentation tab, I used the GetFieldSelections(ListName) expression to conditionally hide the column. This works in a Straight table and only if you select one or no value from the listbox. You may have to tweak the conditional expression to accomodate selecting more than 1 value.

[Anonymous]

There is no need to hide expressions. I'd use one expression with conditions:
if(var='POUND, <exp1>, if(var='DOLLAR, <exp2>, <exp3>))

[#4]

Hello Anthony,

Thanks for the help and information and unfortunately, it would not hide expressions for my charts.
And to make it a bit more challenging, the chart expressions are under a CYCLIC/Cycle button.
And an example,
Under the CYCLIC button the following chart expressions are in it:
DollarChartExpression
OrderChartExpression

And another chart expression, which I call PoundChartExpression, is outside of the CYCLIC button.
I'm attaching an image so everyone can see what I'm trying to accomplish.

I have an INPUT box and in it is the value POUNDS. And when I select POUNDS from the INPUT BOX
and I have a chart open,based on what the user selected from the CYLIC ICON, i.e. DOLLARS,
what it will do is append the POUNDS chart into the DOLLAR chart.
I then end up having 2 legends 1 for DOLLARS and 1 for POUNDS.

Is it possible to disable the expression from within the CYCLIC icon if selected POUNDS
from the INPUT box and use the POUNDS expression instead?

Thanks for all the help.

Sincerely,
Reyn

[#5]

If I understood your problem correctly, you would like to hide/disable the cyclic expression and display the Pound expression when you select POUNDS from the Input Box, and when the POUNDS is deselected, you would just want to re-display again the cyclic expressions in your chart. Is that correct ? If so, you can create 2 separate charts, one that has the cyclic expression and one that has the Pound Expression. Use the Conditional expression on the Layout tab to display each chart depending on the value selected from the Input Box.

I was thinking that one chart can accomplish this, however, I was unable to do so. Maybe others can help out.

[#6]

Anthony,

That's the "contingent" plan that I have but I'm waiting for other users who might have done something similar and have accomplished it with just one chart. Thanks for the sample and help for it is very helpful and informative.

Reyn