Skip to main content
Announcements
Introducing a new Enhanced File Management feature in Qlik Cloud! GET THE DETAILS!
cancel
Showing results for 
Search instead for 
Did you mean: 
Riccardo
Partner - Creator III
Partner - Creator III

Show all weeks in a pivot

Hi,

 

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

Cattura.PNG

 

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

Riccardo Schillaci
BI Analyst
Datawarehouse & Business Intelligence
Labels (5)
2 Replies
Marcos_rv
Creator II
Creator II

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.

sin zero-value.PNG

 

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

 

ejemplo zero values.PNG

 

 

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

scroll.PNG

Espero que haya sido util mi respuesta.

Saludos!!!!!

CarlosAMonroy
Creator III
Creator III

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