topic Re: Difference Between Dates in Weeks from Different Tables in QlikView

Difference Between Dates in Weeks from Different Tables

Anonymous — Mon, 10 Mar 2014 19:12:52 GMT

I need to determine the amount of weeks and days between two dates that come from two different tables in the load script. They have both already been loaded in different tabs from different tables, and I need to subtract one date from the other and express the difference in weeks and days (Ex: 17.3 weeks).

Re: Difference Between Dates in Weeks from Different Tables

Mon, 10 Mar 2014 19:20:26 GMT

Hey Bradley,

If you want to do this on the back-end you need to have both date fields in same table.Then

(Date1-Date2)/7 as WeekField

If you want to do it on the front end then the same formula in the expression but just make sure there is only one value for the dimensions.

Thanks