topic Re: Setting expression as variables in QlikView

Setting expression as variables

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

I would like to set all my common expressions as a reusable variable.

I use variables for other purposes, but when I tried to set a variable "=sum(Revenue)", it didn't work as expected.

For some reason the calculation doesn't work with all dimension. It only shows the total revenue of the whole database, and enters the same value for all dimensions. The total value can be billions or trillions, depending on the number of dimensions I have in the Pivot table. Any simple solution for this?

Thanks

Re: Setting expression as variables

MEJ — Mon, 03 Jun 2019 14:16:08 GMT

No one knows?

I've seen posts about this, but I haven't been able to replicate it, or at least it wasn't working for me.

Re: Setting expression as variables

Vegar — Mon, 03 Jun 2019 14:36:52 GMT

It can be a bit tricky with expressions and dollar expansions. Dollar expansions are often calculated "outside" the object and will give you the grand total of your selection even inside a multidimensional object.

I don't have the solution for this in the top of my head, but try to adjust the use of equal signs, apostrophes in expansion and in the variable expression.

Re: Setting expression as variables

Brett_Bleess — Thu, 27 Jun 2019 17:07:51 GMT

Have a look at the following Design Blog post, I think it might help you out here in addition to what the other poster already gave you!

https://community.qlik.com/t5/Qlik-Design-Blog/The-Magic-of-Variables/ba-p/1465499

Regards,
Brett

Re: Setting expression as variables

rubenmarin — Thu, 27 Jun 2019 18:44:32 GMT

Hi, you need to remove the starting equal sign.

Starting with an equal the variable is evaluated globally and the result value is used, that's why every row is the same.