topic Caluculating Rolling Weeks in QlikView

Caluculating Rolling Weeks

NickBentley — Fri, 15 Nov 2024 23:41:47 GMT

I am currently using the below expression to calculate YTD sales.

Sum({<FY_Year={2021},Fy_Wk={'1','2','3','4','5','6','7','8','9','10','11','12','13','14','15','16','17','18'}>}[Sales_Value])

Is there a shorthand approach to just sum Weeks 1 - 18, rather than writing each week individually such as 'Week 1', 'Week 2' etc. ?

I use this approach for not only YTD sales but a number of other expressions.

Thanks in advance!

Vegar — Mon, 02 Nov 2020 22:43:41 GMT

Try this adjustment.

Sum({<FY_Year={2021},Fy_Wk={">0 <=18"}>}[Sales_Value])

NickBentley82 — Mon, 02 Nov 2020 23:18:01 GMT

Thanks Vegar, adjustment worked perfectly!