topic Store formulas/expressions in variables in QlikView

Store formulas/expressions in variables

curiousfellow — Thu, 14 Jul 2022 08:09:14 GMT

To make expressions not to complicated, I stored some expressions in variables. The stored expressions contain variables too.

Should it be possible to use variables like this. For every dimension I get the same result now.

For example : stored in var1 = sum({<year={"=$(var_chosen_year)"}>}sales)

var2 = sum({<year={"=$(var_compare_year)"}>}sales)

In my chart :

dimension : department

expression: $(var1)-$var(2)

curiousfellow — Thu, 14 Jul 2022 08:57:55 GMT

SOLVED : I created the content of the variable starting with the "=" sign". Without that character it works

MayilVahanan — Thu, 14 Jul 2022 08:59:04 GMT

For Dynamic, remove the "=" equal sign from the formula and try like $(var1)

var1:

sum({<year={"=$(var_chosen_year)"}>}sales)