Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Difference Between Dates in Weeks from Different Tables

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).

1 Solution

Accepted Solutions
Not applicable
Author

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

AJ

View solution in original post

1 Reply
Not applicable
Author

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

AJ