Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
khigaurav999
Creator
Creator

Pivot Table Null Values or Data Issue

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

1 Solution

Accepted Solutions
stabben23
Partner - Master
Partner - Master

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

View solution in original post

3 Replies
buzzy996
Master II
Master II

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
Creator
Creator
Author

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
Partner - Master
Partner - Master

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