How to handle - Working Days SUM

qlikviewaf — Wed, 02 Aug 2017 12:19:26 GMT

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.

Re: How to handle - Working Days SUM

Gysbert_Wassenaar — Wed, 02 Aug 2017 12:30:04 GMT

You can try:

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

topic Re: How to handle - Working Days SUM in QlikView

How to handle - Working Days SUM

Re: How to handle - Working Days SUM