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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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