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

Announcements
Posting on Qlik Community is temporarily paused for some users. Thank you for patience and we'll update you soon!
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

Labels (1)
1 Reply
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

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


talk is cheap, supply exceeds demand