topic Re: set expressions in QlikView

set expressions

Anonymous — Sat, 02 May 2015 17:32:15 GMT

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

Re: set expressions

Gysbert_Wassenaar — Mon, 04 May 2015 08:18:57 GMT

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))

Re: set expressions

Anonymous — Thu, 09 Jul 2015 17:42:41 GMT

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