Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

rajeshkota
New 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
Honored Contributor III

Re: set analysis - count when value is a given month

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

10 Replies

Re: set analysis - count when value is a given month

Do you have pure month data let me know this.

rajeshkota
New Contributor III

Re: set analysis - count when value is a given month

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

Re: set analysis - count when value is a given month

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

antoniotiman
Honored Contributor III

Re: set analysis - count when value is a given month

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

Re: set analysis - count when value is a given month

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
Esteemed Contributor

Re: set analysis - count when value is a given month

Hi,

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


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

rajeshkota
New Contributor III

Re: set analysis - count when value is a given month

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

rajeshkota
New Contributor III

Re: set analysis - count when value is a given month

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

rajeshkota
New Contributor III

Re: set analysis - count when value is a given month

Thanks Anand.  Worked.  Appreciate the help.

Community Browser