topic Query on pivot table in QlikView https://community.qlik.com/t5/QlikView/Query-on-pivot-table/m-p/903180#M314126 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>Query:</P><P></P><P>- 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 </P><P>&nbsp; by default in pivot table&nbsp; it is showing dash ( - ) rather than empty cell and also the position of column is shifted to last.</P><P>- This can be done manually using properties but how can we fix it using the back end script?</P><P></P><P>- Please find attachment. </P></BODY></HTML> Thu, 21 May 2015 07:43:32 GMT Mahamed_Qlik 2015-05-21T07:43:32Z Query on pivot table https://community.qlik.com/t5/QlikView/Query-on-pivot-table/m-p/903180#M314126 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>Query:</P><P></P><P>- 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 </P><P>&nbsp; by default in pivot table&nbsp; it is showing dash ( - ) rather than empty cell and also the position of column is shifted to last.</P><P>- This can be done manually using properties but how can we fix it using the back end script?</P><P></P><P>- Please find attachment. </P></BODY></HTML> Thu, 21 May 2015 07:43:32 GMT https://community.qlik.com/t5/QlikView/Query-on-pivot-table/m-p/903180#M314126 Mahamed_Qlik 2015-05-21T07:43:32Z Re: Query on pivot table https://community.qlik.com/t5/QlikView/Query-on-pivot-table/m-p/903181#M314127 <HTML><HEAD></HEAD><BODY><P>Replace the nulls in the script with real values. See this document: <A href="https://community.qlik.com/docs/DOC-3155">NULL handling in QlikView</A>‌</P><P></P><P>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.</P></BODY></HTML> Thu, 21 May 2015 15:48:09 GMT https://community.qlik.com/t5/QlikView/Query-on-pivot-table/m-p/903181#M314127 Gysbert_Wassenaar 2015-05-21T15:48:09Z