topic Re: syntax problem less than or equal to addyears with variable in App Development

syntax problem less than or equal to addyears with variable

Wed, 04 Oct 2017 09:17:08 GMT

hi Guys!

hope you could help me out.

I would like to calculate a sum till a certain time point in previous year, depending on what do I choose in a variable, below is what I came up with, nevertheless it doesn't work, although similar builds in the project do.

Sum({$<

[Date]= {"$(<=addyears(date('$(vRollingForecastBeginning)'), -1))"}

ActualsValue)

The expression alone:

addyears(date('$(vRollingForecastBeginning)'), -1)

returns '07/01/2016' and reacts to variable changing correctly, [Date] is formatted as Date in script so the formats should be aligned.

do you have any ideas?

thanks in advance,

Bart

Re: syntax problem <= addyears with variable

marcus_sommer — Wed, 04 Oct 2017 15:49:10 GMT

Your expression should be rather look like:

Sum({$<

[Date]= {"<=$(=addyears(date('$(vRollingForecastBeginning)'), -1))"}

ActualsValue)

- Marcus

Re: syntax problem less than or equal to addyears with variable

Anonymous — Wed, 04 Oct 2017 17:19:22 GMT

Hi Bartosz,

I've edited the title of this thread to replace "<=" with "less than or equal to", as the symbols were cause a page display issue.

Best regards,

Qlik Community Team

Re: syntax problem less than or equal to addyears with variable

Thu, 05 Oct 2017 08:33:41 GMT

hi Marcus,

works like a charm, thank you!

I wonder why in some case you need the additional "=" and in some you don't...

best

Bart

Re: syntax problem less than or equal to addyears with variable

Thu, 05 Oct 2017 08:33:58 GMT

hi Jeremy,

thanks!

regards,

Bart

Re: syntax problem less than or equal to addyears with variable

marcus_sommer — Fri, 06 Oct 2017 06:36:13 GMT

Here it's very well explained why and where the "=" made a difference:

The Little Equals Sign

The Magic of Dollar Expansions

- Marcus