Qlik Community

Qlik Sense Advanced Authoring

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

cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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.  

Thanks 

Saif 

 

Labels (2)
1 Reply
Highlighted
Creator
Creator

Re: Creating New Calculative Fields in Load Script

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.