topic Re: Set Analysis in include.qvs file in QlikView

Set Analysis in include.qvs file

Rafakla — Thu, 02 Jul 2026 03:38:54 GMT

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 — Thu, 02 Jul 2026 12:52:35 GMT

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

andrzejdobiegal — Thu, 02 Jul 2026 13:05:34 GMT

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