topic Show all weeks in a pivot in QlikView

Show all weeks in a pivot

Riccardo — Sat, 16 Nov 2024 21:29:05 GMT

Hi,

I have to show all the weeks, also with no value expressions. Please see the screenshot. The red numbers are the missing weeks.

My master calendar is full and starts from 2014-01 and ends to 2019-12. I have selected "Item" and 2018 year.

My goal is show all the weeks with no data between the weeks with data.

Thanks

Riccardo

Re: Show all weeks in a pivot

Marcos_rv — Fri, 01 Feb 2019 21:20:08 GMT

Hola, como estas?

Para solucionar tu problema, primero tenes que tener un calendario completo, en donde esten todas las semanas, para esto deberias tener una fecha minima y maxima.

Vamos la pestaña( o solapa) Presentation, y destildamos el check de Suppress Zero-Value.

Ahora vamos a ver al grafico con un scroll para poder navegar las semanas incluso que no tienen valores asociados.

Espero que haya sido util mi respuesta.

Saludos!!!!!

Re: Show all weeks in a pivot

CarlosAMonroy — Fri, 01 Feb 2019 22:07:32 GMT

Hi Riccardo,

You have to uncheck box "Supress Zero Values" option that is under Presentation tab.
If you still not able to see the values. Add to your expression a condition like this, let's say expression is just sum of sales. Would be

if(Sum(Sales) = 0 or len(Sum(Sales))=0,0,Sum(Sales))

Hope that helps,
Carlos M