Query on pivot table

[Mahamed_Qlik]

Hello,

Query:

- Suppose we have database in Excel and there is an empty cell (Not Null / Not Zero / Not dash ( - )) and if load this into qlik view then

  by default in pivot table  it is showing dash ( - ) rather than empty cell and also the position of column is shifted to last.

- This can be done manually using properties but how can we fix it using the back end script?

- Please find attachment.

[Gysbert_Wassenaar]

Replace the nulls in the script with real values. See this document: NULL handling in QlikView‌

Note, this does not work for missing values. It's possible that there simply isn't any record for the combination of pivot table dimension values. To solve that you will have to generate extra records for the missing combinations.