topic Do While to create a custom week by customer in App Development

Do While to create a custom week by customer

ladybyrd2011 — Sat, 16 Nov 2024 06:44:07 GMT

I need to script a do while loop to create a week dimension that is based off when a customer signs a contract rather than the calendar week. So, the Monday of the week they sign is week one then each week after will be week +1, +2 ... I'm not sure how to script this to create the weeks.

Let vStartDate = ClientWeekStart;

Let vEndDate -= LastInvoiceWeekStart;

I would very much appreciate any suggestions.

Re: Do While to create a custom week by customer

NhanNguyen — Tue, 29 Jan 2019 06:34:45 GMT

How do you want to store your week data? Do you need to update weekly how long since customers sign the contract or you simply need to update only 2 data points: weekstart and weekend?
Without any information, I think you can get week number by using week(). Please read more from qlik documentation: https://help.qlik.com/en-US/sense/November2018/Subsystems/Hub/Content/Sense_Hub/Scripting/DateAndTimeFunctions/week.htm