Calculate number of days between start and end dates with a twist

[megasupermoon]

Hey,

I have Qlik sense report which shows number of treatment days between end and start dates in different departments. There can be many rows for one department. They are counted in sql query:

DATEDIFF
( DAY,
  START_DATE,
  ISNULL(END_DATE, GETDATE())
) AS NET_TREATMENT_DAYS

and then in front-end expression: Sum(NET_TREATMENT_DAYS).

But now I need gross treatment days (gross treatment days  are calculated:  END_DATE - START_DATE + 1. Therefore START_DATE and END_DATE is included.)

Any idea how to calculate this? Is it possible to calculate in front-end, or should I do that in sql query or in load script etc and how?

Thanks in advance!

[megasupermoon]

Could

Sum(NET_TREATMENT_DAYS) + Count(END_DATE)

make a trick?

[Kushal_Chawda]

@megasupermoon  you can try this in qlik load script

LOAD Coalesce(END_DATE,today())-START_DATE+1 as NET_TREATMENT_DAYS
FROM Table;

[megasupermoon · Accepted solution]

Didn't work, but I got right numbers with front-end expression 

Sum(NET_TREATMENT_DAYS + 1)