Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a variable_a which contains a complicated expression. The result of this expression is a single value.
I'd like to create a second variable which evaluates variable_a on certain set expression.
Is possible in QlikView?
The point is that I don't want to clone complicated expressions.I'd like to set an expression as a variable and then evaluate this variable on different set expressions.
Thank you in advance,
Larisa
I'm pretty sure what you want can be done. I don't quite understand what you want to do though. Here's an example with three variables. vSum takes a field name as parameter.
vMaxDate: =max(MyDate)
vSetModifier: {$<MyDate={">=$(vMaxDate)"}>}
vSum: sum($(vSetModifier) $1)
expression: $(vSum(SalesAmount))
i agree with Gysbert. Post your sample data or file and what exactly you are looking for then we can be able to direct you correctly