Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
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!