using variables instead expression

Anonymous — Wed, 07 Dec 2016 16:49:05 GMT

Dear experts, good day!

Maybe someone have task to calculate some expressions, which are described in document variables?

For example, in my real model i have more than 100 expression with same calculation logic and formula, when i need to set some changes, i must rewrite each of them.

Is in QV possibility to calculate expression by variables? -> In one variable i write my expression, and any changes in it must change each report where this variable is implemented.

In attachment test model and source file, but such variant doesn't work (result isn't aggregated by my dimensions)

Any ideas how to solve this?

Thanks.

Re: using variables instead expression

sunny_talwar — Wed, 07 Dec 2016 16:54:20 GMT

Check the attached now

Update: Remove the '=' sign before your variable definition

Use $(vTest) as expression

Re: using variables instead expression

Anonymous — Wed, 07 Dec 2016 16:59:56 GMT

Thanks!!!!!

topic Re: using variables instead expression in QlikView

using variables instead expression

Re: using variables instead expression

Re: using variables instead expression