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: 
Rkota
Contributor III
Contributor III

rookie question - dynamically determine variable value in doing a sum

this may be a rookie question, so your patience is greatly appreciated- I'm trying to dynamicaly determine the current month (November) and then do a total only for that month..here's the expression i'm using ...=Sum({$<Month={'date(Today(),"MMMM")'}>} [Total WO]) ..obviously doing something wrong...

thx

1 Solution

Accepted Solutions
Rkota
Contributor III
Contributor III
Author

Worked!!!...Thanks a ton...Tamil Nagaraj..and big hearty Vanakkam to you.  Much appreciated.

View solution in original post

3 Replies
tamilarasu
Champion
Champion

Hi Raj,

=Sum({$<Month={"$(=date(Today(),'MMMM'))"}>} [Total WO])

Scrrenshot from Help file:

Capture.PNG

Rkota
Contributor III
Contributor III
Author

Worked!!!...Thanks a ton...Tamil Nagaraj..and big hearty Vanakkam to you.  Much appreciated.

tamilarasu
Champion
Champion

Ha ha ha. No problem bro Please close the thread by marking correct answer.