Qlik Community

Qlik Sense Advanced Authoring

Discussion board where members can learn more about Qlik Sense Advanced Authoring.

Showing results for 
Search instead for 
Did you mean: 
Contributor III
Contributor III

Creating New Calculative Fields in Load Script

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 codesource code 

source datasource datadesiredesire

Will appreciate your advice.  




Labels (2)
1 Reply

Re: Creating New Calculative Fields in Load Script

I think the Interval Match function could help you out.



There are some good youtube tutorials on this.