Apparently the evaluate function in QlikView only works at the script level.
In the script as an example I did:
LOAD * INLINE
set FC = "*1.3";
set FC2 = "+0.3";
Evaluate(Price $(FC)) as FCPriceCalculated,
Evaluate(Price $(FC2)) as FC2PriceCalculated
Drop table Table1;
This calculates based on your variables into the new fields.
If you try and use evaluate at the expression level or in a variable it will not work... :/
I have attached a working qvw for your reference as well.
Hope this helps!
evaluate.qvw 150.8 K
Thank you Bapperson! Looks good, but as you metnion, the variable is used in an expression and is dynamically alteredd by the user, so the scripted solution won't work. :-S
My way around the problem:
I just defined two variables: FC_factor and FC_summand, so that I defined the expression as
Although this did not solve the original question it provided a solution by circumventing the problem.