Qlik Community

Qlik Sense Advanced Authoring

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

Highlighted
saifuddin
New Contributor II

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 . sample code.PNGsource code 

source data.PNGsource dataDesire.PNGdesire

Will appreciate your advice.  

Thanks 

Saif 

 

Labels (2)
1 Reply
colinodonnel
Contributor

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.