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

Announcements
Only at Qlik Connect! Guest keynote Jesse Cole shares his secrets for daring to be different. Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
Wimmer-Logistik
Contributor III
Contributor III

Sum Expression how to insert a month(today()) function

Hi,

i have this simple expression in a sum formula which works fine:

{$<vYear={"2020"},vMonth={"<=7"}>}

How can i replace the 7 with the current Month?'
I tried:

{$<vYear={"2020"},vMonth={"<=(=Month(Today())"}>}

The editor says OK, but the result is zero in other words, not the same as above.
What am i missing here?

Labels (1)
2 Replies
rubenmarin

Hi, try with: {$<vYear={"2020"},vMonth={"<=$(=Num(Month(Today())))"}>}

Wimmer-Logistik
Contributor III
Contributor III
Author

Hello, 

works FINE!! Thanks !!

bye!