Month Label Name with Working days

[qlikviewaf]

Hi guys,

I build this table where i have the Month dimension (Jan Feb Mar..)

i would like to have instead of Jan Feb Mar,    the month with the number of working days next to each month.

E.g. Instead of Jan, i would like to see "Jan (22)" where 22 is the number of working days. And of course the same for the other month.

How this can be done?  I have a field "WorkingDay" which is 1 if the day on the calendar is Working. 

Thank you!    

[Saravanan_Desingh]

Since 22 is across the months, the simple solution is, in the Dim:

Month&'(22)'

[tresesco]

Try like:

=Month & ' ( ' & Count(Distinct {<WorkingDay={1}>} DateField)  & ' )'

[qlikviewaf]

goes in error.. 😞