Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Show All values

Hi All,

I am using Show all values option to show all the null values and missing values by unchecking supress null values and zero values.

When Doing so everything is working fine but an extra column and row is getting added in the pivot table.How to avoid that?

Any Ideas?

Thanks in Advance

5 Replies
jsingh71
Partner
Partner

Can you share Screenshot of your pivot table chart.

amit_saini
Master III
Master III

Hi Murali,

Go to char properties and tick option "Supress When Value is Null"

Thanks,
AS

Not applicable
Author

Hi PFA

Here I am using show all values by unchecking suppress zero values and Null Values.In doing that an extra column and row is getting added.

jsingh71
Partner
Partner

Can you tried to Select "Surpress When Value is Null" check box under dimension tab???

manojkulkarni
Partner
Partner

Null column might be occurring due to month missing in one of the data and same applied for other dimension as well.