topic Re: Pivot Table - force all options to display in QlikView https://community.qlik.com/t5/QlikView/Pivot-Table-force-all-options-to-display/m-p/485485#M555364 <HTML><HEAD></HEAD><BODY><P>When you load in the time field in the script you could replace the null values with 0's.&nbsp; Then when you create the chart turn off suppress zero values.</P><P></P><P>Something in the script like If(Len(Time) = 0, 0, Time) as RecordedTime</P></BODY></HTML> Mon, 12 Aug 2013 16:30:01 GMT jpapador 2013-08-12T16:30:01Z Pivot Table - force all options to display https://community.qlik.com/t5/QlikView/Pivot-Table-force-all-options-to-display/m-p/485484#M555363 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>My data contains a list of resources and the time that these resources have recorded each month for up to 12 months. </P><P></P><P>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. </P><P></P><P>I would like all months to display with zero or null displayed under the 'empty' month. Is this possible?</P><P></P><P>Thanks,</P><P>Alan</P></BODY></HTML> Mon, 12 Aug 2013 15:36:30 GMT https://community.qlik.com/t5/QlikView/Pivot-Table-force-all-options-to-display/m-p/485484#M555363 2013-08-12T15:36:30Z Re: Pivot Table - force all options to display https://community.qlik.com/t5/QlikView/Pivot-Table-force-all-options-to-display/m-p/485485#M555364 <HTML><HEAD></HEAD><BODY><P>When you load in the time field in the script you could replace the null values with 0's.&nbsp; Then when you create the chart turn off suppress zero values.</P><P></P><P>Something in the script like If(Len(Time) = 0, 0, Time) as RecordedTime</P></BODY></HTML> Mon, 12 Aug 2013 16:30:01 GMT https://community.qlik.com/t5/QlikView/Pivot-Table-force-all-options-to-display/m-p/485485#M555364 jpapador 2013-08-12T16:30:01Z