topic Pivot Table Null Values or Data Issue in QlikView

Pivot Table Null Values or Data Issue

khigaurav999 — Wed, 25 Nov 2020 16:16:04 GMT

Dear Community Members and Friends!

I am new to QlikView and facing an issue with my Pivot table. I can see data renders well (i.e. no records are missing) with Table Box object but same when I present with a Pivot Table chart, I see some null / missing / empty (i.e. - ) values for fields. I am not adding condition/constraint in my Pivot Table dimensions and expressions.

Table Box object - temp7.jpg attached here.

Pivot Table chart object - temp9.jpg attached here.

I am not sure if it is a silly question. Sorry if it is really silly one!

Thanks for your help with this in advance.

Gaurav

Re: Pivot Table Null Values or Data Issue

buzzy996 — Tue, 07 Feb 2017 09:51:05 GMT

hi, the data which you showed on print screen is not full fledged.

kindly create a simple app and share ? tht helps to quickly solve ur issue.

Re: Pivot Table Null Values or Data Issue

khigaurav999 — Wed, 08 Feb 2017 07:28:50 GMT

Here is sample app with some dummy data. For some reason PIVOT table object is showing null/missing values at lot of place. it should be complete like table box object.

Gaurav

Re: Pivot Table Null Values or Data Issue

stabben23 — Wed, 08 Feb 2017 07:40:02 GMT

Hi,

you are using Dimension as Expression whitout doing any Expression, thats whay it dont match.

Move all Fields that you use in Expression, add them instead in Dimension.

Add one Expression 1