Pivot Table Null Values or Data Issue

[khigaurav999]

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

[buzzy996]

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.

[khigaurav999]

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

[stabben23 · Accepted solution]

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