topic Difference between 3 expressions - Set Analisys in QlikView

Difference between 3 expressions - Set Analisys

eberhardteduard — Fri, 19 Feb 2016 14:23:34 GMT

Hi, which is the difference for the 3 expressions bellow?

date={'>=$(=addmonths(today(),-6))'}

date={'>=$(addmonths(today(),-6))'}

date={'>=addmonths(today(),-6)'}

Thanks in advance, Eduardo.

sunny_talwar — Fri, 19 Feb 2016 16:52:33 GMT

I think the biggest difference I see is that the first one has the correct syntax and the other two are incorrect and most likely won't work

eberhardteduard — Fri, 19 Feb 2016 16:56:26 GMT

Thanks Sunny, but actually they do!
The second one gives me an incorrect value, but still brings me a value and the third one returns me all 0s.

sunny_talwar — Fri, 19 Feb 2016 17:05:01 GMT

I would have not expected the second one to give you a value as well. Not sure what value it is giving. Do you have a sample you can share?

Anonymous — Fri, 26 Feb 2016 07:58:47 GMT

this is what I think

date={'>=$(=addmonths(today(),-6))'} gives you the date that is calculated using addmonths(today(),-6))

date={'>=$(addmonths(today(),-6))'} gives you the value of variable addmonths(today(),-6))