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

set analysis - count when value is a given month

Rkota — Tue, 21 Nov 2017 17:19:03 GMT

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

its_anandrjs — Tue, 21 Nov 2017 17:26:16 GMT

Do you have pure month data let me know this.

Rkota — Tue, 21 Nov 2017 17:30:56 GMT

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 — Tue, 21 Nov 2017 17:31:23 GMT

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

antoniotiman — Tue, 21 Nov 2017 17:35:05 GMT

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

its_anandrjs — Tue, 21 Nov 2017 17:35:08 GMT

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 — Tue, 21 Nov 2017 17:35:15 GMT

Hi,

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

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

Rkota — Tue, 21 Nov 2017 17:39:36 GMT

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

Rkota — Tue, 21 Nov 2017 17:40:26 GMT

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

Rkota — Tue, 21 Nov 2017 17:41:25 GMT

Thanks Anand. Worked. Appreciate the help.

its_anandrjs — Tue, 21 Nov 2017 17:43:14 GMT

You can close another response as well as Correct or helpful.