topic Re: Rolling 52 Table in QlikView

Rolling 52 Table

pandrews87 — Sat, 16 Nov 2024 20:01:04 GMT

I have a strange issue with Qlikview with a rolling 52 Week report that show sales units for items which works back from the current week (39) to week 40 of previous year. What is happening is that if an item has 0 sales for the week it populates the current week data with data with sales from a previous week. Example:

Week 39 (Current Week) had 0 sales of an item.

On my Qlikview table it kept the week 39 label but populated the sales data from the previous week (38) as there was sales. I have checked all of the table properties and unchecked suppress zero values, show all values etc.

How do i stop the table from hiding 0 values if there is no sales for the current week?

Thanks

Re: Rolling 52 Table

martinpohl — Wed, 25 Sep 2019 10:36:54 GMT

Hi,

if there are no datas in one week, there is no week available to show in the chart.

So you have to create datas for example each week with 0 as Sales and all dimensions (customer, article, salesmen eg) you want to select.

Regards

Re: Rolling 52 Table

Brett_Bleess — Thu, 03 Oct 2019 21:09:12 GMT

Hoping the following Design Blog posts may help:

https://community.qlik.com/t5/Qlik-Design-Blog/Canonical-Date/ba-p/1463578

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

https://community.qlik.com/t5/Qlik-Design-Blog/Slowly-Changing-Dimensions/ba-p/1464187

Not sure if I have the right ones or not, feel free to search yourself using the following link:

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

Regards,
Brett