Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
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))