Discussion board where members can learn more about Qlik Sense App Development and Usage.
I would like the following in my data load statement...dates to add up to a total number of days ...the in the "total number of days" new column
sum(if(DateOrderCompleted) - (DateOrderReceived) as [TotalNumberOfDays],
I cant seem to crack it.
Go to Solution.
sum(DateOrderCompleted - DateOrderReceived) as [TotalNumberOfDays],
Interval(DateOrderCompleted - DateOrderReceived,'DD') as TotalNumberOfDays
Why not simply:
Date((DateOrderCompleted)) - Date((DateOrderReceived)) as TotalNumberOfDays
awesome ta xxx
worked a treat