Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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.