Count weekeday issues

[MikeJones]

Hi I am trying to count the number of Jobids that occur on Monday using

=count(<{weekday([PlannedDate.autoCalendar.Date])={'Mon'}>},[JobID-Jobid])

Qlik tells me that ')' expected, however, I have tried numerous additions and I can't get it to work.

[QFabian · Accepted solution]

Hi @MikeJones , please consider 2 things, 

1,. create a new field DateWeekDay, for not to use function for the field in the expression.

2.- check the sintax, '<{'  to '>}'  and the cooma is not necesary before the counted field '[JobID-Jobid]'

count(
{<
[PlannedDate.autoCalendar.DateWeekDayNEWFIELD] = {'Mon'}
>}
[JobID-Jobid])

[MarcoWedel]

you can check your set expression syntax using this description:

https://help.qlik.com/en-US/sense/November2022/Subsystems/Hub/Content/Sense_Hub/ChartFunctions/SetAn...