Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Connect 2026! Turn data into bold moves, April 13 -15: 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
Partner - Champion III
Partner - Champion III

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