If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.
Is it possible to reuse LET/SET variables on the backend to (re)calculate and use the results again as new LET/SET variables?
LET vVariable1 = 1+1 ;LET vVariable2 = 3+3;
LET vTotal = $(vVariable1) + $(vVariable2)
LET vTotal = vVariable1 + vVariable2
LET vTotal = $(vVariable1 + vVariable2)
I have tried the 3 options and have expected to get 8, however I'm getting an error on the frontend.
Could someone please help? Thanks in advance!
What is the error?
These statements are all legal, except the last. Did you include semi-colons at the end of
LET vTotal = $(vVariable1) + $(vVariable2);LET vTotal = vVariable1 + vVariable2;
I prefer the latter myself as the expansion is not necessary here.
Working for me: