Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Pivot Table - force all options to display

Hi,

My data contains a list of resources and the time that these resources have recorded each month for up to 12 months.

I am displaying this information in a Pivot Table which works fine when looking at all of the resources as all months are visible. The issue that I am having is when an individual resource is selected and they have not recorded time, the blank month does not display at all.

I would like all months to display with zero or null displayed under the 'empty' month. Is this possible?

Thanks,

Alan

Tags (2)
1 Reply
Highlighted
jpapador
Valued Contributor

Re: Pivot Table - force all options to display

When you load in the time field in the script you could replace the null values with 0's.  Then when you create the chart turn off suppress zero values.

Something in the script like If(Len(Time) = 0, 0, Time) as RecordedTime

Community Browser