Create weeks from month table

ecabanas — Fri, 15 May 2020 10:42:47 GMT

I have this table, with from_Date and to_Date to control the rates, but I want to control the rates per week, so I want to create and ID for each week and then can control the revenues making the same ID (Year(date)&'-'&Week(date))

ItemId Proveedor_Tarifa Row From_D To_D rate
21129481 PROV00026 1 18/03/2020 23/03/2020 0,82
21129481 PROV00026 2 24/03/2020 26/04/2020 0 ,71
21129481 PROV00026 3 27/04/2020 31/12/2020 0,72

any Idea how to do that, Imagine the table show has many items not only one 😉

Thank's for your help

Re: Create weeks from month table

Brett_Bleess — Wed, 10 Jun 2020 20:35:08 GMT

Best I have is the following Design Blog post:

https://community.qlik.com/t5/Qlik-Design-Blog/The-As-Of-Table/ba-p/1466130

There are some other ones regarding calendars etc., not exactly sure what you need here, so if the above is not it, use the following link to search for other posts in that area:

https://community.qlik.com/t5/Qlik-Design-Blog/bg-p/qlik-design-blog

Regards,
Brett

topic Create weeks from month table in QlikView

Create weeks from month table

Re: Create weeks from month table