How to handle - Working Days SUM

[qlikviewaf]

Hi Guys,

i created a dashboard and now i'm working on Working Days - i added a flag on my Calendar Table , if equal to 1 is a working day if equal to 0 is non working day.

As you can see i would like to show for each region the total working day for that specific year/month; as you can see below the system is calculating the working day only if for that specific month there was a sale transaction every day. Total should be always 22 for all rows/region.

I set the expression as -> =sum({<Day=,Region=,Region_Description=,Area=,Invoice_Date=,Invoice_Date_Num=>}WorkingDay)

What can i do to fix this? Thank you. !

Find attached also my app.

[Gysbert_Wassenaar]

You can try:

=sum({<Day=,Region=,Region_Description=,Area=,Invoice_Date=,Invoice_Date_Num=>} TOTAL WorkingDay)