Set Analysis in include.qvs file

[Rafakla]

Hi all,

How can I use the expression bellow in  include.qvs file?

SET vLast12Months = Sum ({<[Ano Mes Retorno] = {">=$(=date(Max(addmonths(today(),-12)),'YYYYMM'))"}>}[Valor Realizado Cob - Coop]);

When executed, the variable vLast12Months appears like this in the .qvw file:

"Sum ({<[Ano Mes Retorno] = {">="}>}[Valor Realizado Cob - Coop])"

Thanks

Rafael

[andrzejdobiegal]

To avoid expanding the $(..) use a different character first '#' and replace it later '$', see below:

[andrzejdobiegal]

you can also put the expressions into a  table and create the corresponding variables from the table fields, see below: