Discussion Board for collaboration on QlikView Scripting.
Can this be converted to Set Analysis?
if(SUM(EXTENDED_RETAIL) >=500, sum(EXTENDED_RETAIL)*.05, sum(EXTENDED_RETAIL)*.02 )
Go to Solution.
no set expression, but maybe helpful:
No, but you could use the statement in your script and create an extra field for the outcome so you no longer have to do the calculation in your front-end.
The " + " in the set equation represent the "OR" condition?
In your case your comparing the results after the Aggr so you need calculate the sun() in the script then you could use the same in set analysis