Reuse Values in Expression with Show/Hide Expression

[cristian_av]

Hi

I have about 6 graphs, and all of them use "almost" the same expressions. But the expression has to be show/hide depending on a user selection. This selection is actually made by selecting a list as seen on the image.

I've tryied the following ways to re-use expressions:

ie. =column(1)/column(2)        Works, but when I hide (with a condition) the column 1 or 2, the expression stops working.

Is there any other way to reuse the expressions on the same chart that could work?

Thanks!

[sudeepkm]

If I understand your requirement correctly then I think you want to show the expression in the chart based on user's selection. You can find something interesting here. Customizable Straight Table

Regarding reusable expressions. I think you can use variables to store your expressions and then use it wherever necessary.

[cristian_av]

Thanks, I've done the same.. But I have to do 6 Graphs all with selectable dimensions/expresions and each graph in different currency!

[vinieme12]

What you are using to hide the expression is NOT for hiding the expression. It's the evaluation condition for the expression so if the condition is false, the expression won't be evaluated which in turn will fail other expressions referring to the column

Instead of re-using expressions of the same table, Create variables for the expression and use variables for all your expressions, so even if that particular expression is not selected to be shown the variables will still be evaluated.

Hope this makes sense