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

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to move expression with modifiers to variable

Hi all,

I am desesperately trying to move an expression with modifiers to a variable which I will load in my script with a let statement. For example:

I am aware that the expression: sum(Sales), can be moved to: let vSales = sum(Sales), so later on you can use it in the chart expression with the dollar expansion: $(vSales).

sum(Sales) --> vSales (with let statement) --> $(vSales)

However, how can I do the same with the folliwing expression with a modifier: sum({<[Region]='UK'>} Sales)?

Any comment is appreciated.


Thanks in advance.

JM Balaguer

1 Reply
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

SET vSalesUK = sum({<[Region]={'UK'}>} Sales);


talk is cheap, supply exceeds demand