topic Displaying Null Values in QlikView

Displaying Null Values

Wed, 22 Sep 2010 12:24:51 GMT

Hello,

I have a calendar that has all YearPeriods for 2010 but when I create a Pivot table it only displays those YearPeriods that have a Sales value (Year 2010 has been selected).

	YEARPERIOD
CONTRACT	2010 02	2010 05	2010 06
1	£100
2			£400
3		£200

Is there something I can do so the Pivot table is displayed like below?

	YEARPERIOD
CONTRACT	2010 01	2010 02	2010 03	2010 04	2010 05	2010 06	2010 07	2010 08	2010 09	2010 10	2010 11	2010 12
1		£100
2						£400
3					£200

I have tried checking the 'Show All Values' box for the YearPeriod dimension but this does not work.

Any help would be appreciated.

Regards

Chris

Displaying Null Values

Wed, 22 Sep 2010 13:39:42 GMT

Did you uncheck in Dimension tab a Suppress When Value is Null

and

in Presentation tab uncheck Suppress Zero-Values and Suppress Missing?????

Displaying Null Values

Wed, 22 Sep 2010 15:56:24 GMT

Thanks Erico.

I had unchecked them both individually but not at the same time.

Cheers