topic Re: How to handle data not exist in pivot table in QlikView https://community.qlik.com/t5/QlikView/How-to-handle-data-not-exist-in-pivot-table/m-p/424266#M158076 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-family: calibri,verdana,arial,sans-serif;">Hi Dipak,</SPAN></P><P></P><P><SPAN style="font-family: calibri,verdana,arial,sans-serif;">You can check the option Show all value in chart properties-&gt;Dimensions.</SPAN></P><P><SPAN style="font-family: calibri,verdana,arial,sans-serif;">and in presentation tab uncheck supress zero values.</SPAN></P><P><SPAN style="font-family: calibri,verdana,arial,sans-serif;">Not sure whether you are looking for this.</SPAN></P><P></P><P><SPAN style="font-family: calibri,verdana,arial,sans-serif;">Regards,</SPAN></P><P><SPAN style="font-family: calibri,verdana,arial,sans-serif;">Tom</SPAN></P></BODY></HTML> Thu, 18 Oct 2012 01:55:09 GMT thomas_skariah 2012-10-18T01:55:09Z How to handle data not exist in pivot table https://community.qlik.com/t5/QlikView/How-to-handle-data-not-exist-in-pivot-table/m-p/424264#M158074 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>Does any one have idea how to handle data not exist in pivot table? Becuase of that it will not giving me the correct sum at the end of the column.</P><P></P><P>Thanks</P></BODY></HTML> Wed, 17 Oct 2012 15:53:53 GMT https://community.qlik.com/t5/QlikView/How-to-handle-data-not-exist-in-pivot-table/m-p/424264#M158074 2012-10-17T15:53:53Z Re: How to handle data not exist in pivot table https://community.qlik.com/t5/QlikView/How-to-handle-data-not-exist-in-pivot-table/m-p/424265#M158075 <HTML><HEAD></HEAD><BODY><P>What exactly do you mean with data not existing in the pivot table? Can you give an example?</P></BODY></HTML> Wed, 17 Oct 2012 16:00:40 GMT https://community.qlik.com/t5/QlikView/How-to-handle-data-not-exist-in-pivot-table/m-p/424265#M158075 2012-10-17T16:00:40Z Re: How to handle data not exist in pivot table https://community.qlik.com/t5/QlikView/How-to-handle-data-not-exist-in-pivot-table/m-p/424266#M158076 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-family: calibri,verdana,arial,sans-serif;">Hi Dipak,</SPAN></P><P></P><P><SPAN style="font-family: calibri,verdana,arial,sans-serif;">You can check the option Show all value in chart properties-&gt;Dimensions.</SPAN></P><P><SPAN style="font-family: calibri,verdana,arial,sans-serif;">and in presentation tab uncheck supress zero values.</SPAN></P><P><SPAN style="font-family: calibri,verdana,arial,sans-serif;">Not sure whether you are looking for this.</SPAN></P><P></P><P><SPAN style="font-family: calibri,verdana,arial,sans-serif;">Regards,</SPAN></P><P><SPAN style="font-family: calibri,verdana,arial,sans-serif;">Tom</SPAN></P></BODY></HTML> Thu, 18 Oct 2012 01:55:09 GMT https://community.qlik.com/t5/QlikView/How-to-handle-data-not-exist-in-pivot-table/m-p/424266#M158076 thomas_skariah 2012-10-18T01:55:09Z