Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

set expressions

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

2 Replies
Gysbert_Wassenaar

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


talk is cheap, supply exceeds demand
Anonymous
Not applicable
Author

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