topic Re: Reuse Values in Expression with Show/Hide Expression in QlikView

Reuse Values in Expression with Show/Hide Expression

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

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!

Re: Reuse Values in Expression with Show/Hide Expression

sudeepkm — Wed, 11 Jan 2017 18:08:26 GMT

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.

Re: Reuse Values in Expression with Show/Hide Expression

cristian_av — Wed, 11 Jan 2017 18:20:20 GMT

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

Re: Reuse Values in Expression with Show/Hide Expression

vinieme12 — Wed, 11 Jan 2017 18:58:54 GMT

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