Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
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.