Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
eberhardteduard
Partner - Contributor II
Partner - Contributor II

Difference between 3 expressions - Set Analisys

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.

4 Replies
sunny_talwar

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
Partner - Contributor II
Partner - Contributor II
Author

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

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
Not applicable

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))