Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP 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 - Specialist
Partner - Specialist

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

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

manojkulkarni
Partner - Specialist II
Partner - Specialist II

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