Creating New Calculative Fields in Load Script

saifuddin — Sat, 16 Nov 2024 06:05:56 GMT

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

Re: Creating New Calculative Fields in Load Script

colinodonnel — Mon, 03 Jun 2019 11:40:11 GMT

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-different-datasources/td-p/200189

There are some good youtube tutorials on this.

topic Re: Creating New Calculative Fields in Load Script in App Development

Creating New Calculative Fields in Load Script

Re: Creating New Calculative Fields in Load Script