Null values in Table box and Straight Table
Article Number: 000007306 | Last Modified: 2018/06/12
By exporting null values to Excel, you may find the outcome is different between table box and straight table.
This is due to two objects defines null values differently.
Straight Table: Text( '-' )
Since it has a setting to deine a null symbol in chart properties, this symbol replaces the null values in the object.
Exported to Excel as a text, not null(nothing in a cell.)
Table Box: Text( Null() )
Because of a table box doesn't the null symbol setting like a straight tale, null value is an empty space, which is visible as a dash sign in the table and other QlikView objects.
Therefore, if exported to Excel, the null value is now an empty string. No dash sign.