How to move expression with modifiers to variable

Thu, 31 Oct 2013 15:21:24 GMT

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

Re: How to move expression with modifiers to variable

Gysbert_Wassenaar — Thu, 31 Oct 2013 15:49:15 GMT

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

topic Re: How to move expression with modifiers to variable in QlikView

How to move expression with modifiers to variable

Re: How to move expression with modifiers to variable