topic Re: Month Label Name with Working days in QlikView

Month Label Name with Working days

qlikviewaf — Sat, 16 Nov 2024 18:43:26 GMT

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 — Tue, 28 Apr 2020 13:27:30 GMT

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

Month&'(22)'

tresB — Tue, 28 Apr 2020 13:47:01 GMT

Try like:

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

qlikviewaf — Wed, 29 Apr 2020 12:59:16 GMT

goes in error.. 😞