Creating New Calculative Fields in Load Script

[saifuddin]

Hi All, 

Part of a bigger project I am working on, I have to figure out numbers of week between  Start and End date. From below screenshot, for each Start_date to End_date I want to figure out weeks in 7 days block. I tried using nested If statement as per below. But, it does not satisfy my need.  In a nutshell I want to create two new fields as per the Desire screenshot below -- Weeks and Dates . source code 

source datadesire

Will appreciate your advice.  

Thanks 

Saif 

[colinodonnel]

I think the Interval Match function could help you out.

https://community.qlik.com/t5/QlikView-App-Development/help-using-a-BETWEEN-join-on-tables-from-diff...

There are some good youtube tutorials on this.