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

set analysis - count when value is a given month

HI there - would greatly appreciate any help with the error in the following expression

=Count({<MoveMonth ={">=$(=Date((AddMonths(Today(),-3)),'MMMMM')"}>} unittranid)

essentially, I'm trying to count by month I.E count(unittranid) when MoveMonth=August - as it is today

"Error in set modifier ad hoc element list; ',' or ')' expected.

Thanks

1 Solution

Accepted Solutions
antoniotiman
Master III
Master III

=Count({<MoveMonth ={">=$(=Date(AddMonths(Today(),-3),'MMMMM'))"}>} unittranid)

View solution in original post

10 Replies
its_anandrjs

Do you have pure month data let me know this.

Rkota
Contributor III
Contributor III
Author

thanks for the note -

not sure I understand the question - if you are saying Do I actually have data for the month of august in a "detail table" - then yes.

I think its a syntax issue where i'm missing a , or a ) or something to that effect

its_anandrjs

How you compare String field on MoveMonth on SET expression do you have any numeric fields. Let me know about this.

antoniotiman
Master III
Master III

=Count({<MoveMonth ={">=$(=Date(AddMonths(Today(),-3),'MMMMM'))"}>} unittranid)

its_anandrjs

The syntax is missing with on closing bracket and rest is Ok just try only single month in SET expression and let me know.

Ex:-

=Count({<MoveMonth ={"$(=Date((AddMonths(Today(),-3)),'MMMMM'))"} >} unittranid)

YoussefBelloum
Champion
Champion

Hi,

Date((AddMonths(Today(),-3)),'MMMMM' give you: AUGUST


what do you have on the MoveMonth if you put it on a listbox ?

Rkota
Contributor III
Contributor III
Author

thanks Antonio.  The right parenthesis was missing.  Appreciate the help.

Rkota
Contributor III
Contributor III
Author

thanks for the note Youssef.   I was able to fix it from another reply.

Rkota
Contributor III
Contributor III
Author

Thanks Anand.  Worked.  Appreciate the help.