This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion Board for collaboration related to QlikView App Development.
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?
Thanks in Advance
Can you share Screenshot of your pivot table chart.
Go to char properties and tick option "Supress When Value is Null"
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.
Can you tried to Select "Surpress When Value is Null" check box under dimension tab???
Null column might be occurring due to month missing in one of the data and same applied for other dimension as well.