topic Populating 0 value in missing month in QlikView https://community.qlik.com/t5/QlikView/Populating-0-value-in-missing-month/m-p/501685#M1129807 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-family: calibri, verdana, arial, sans-serif;">Hi All,</SPAN></P><P><SPAN style="font-family: calibri, verdana, arial, sans-serif;">Can anyone suggest how to populate 0 value in missing month and can be done in back end scripting side?</SPAN></P><P><SPAN style="font-family: calibri, verdana, arial, sans-serif;">Pls find attach sample application.</SPAN></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, 28 Nov 2013 03:56:38 GMT thomas_skariah 2013-11-28T03:56:38Z Populating 0 value in missing month https://community.qlik.com/t5/QlikView/Populating-0-value-in-missing-month/m-p/501685#M1129807 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-family: calibri, verdana, arial, sans-serif;">Hi All,</SPAN></P><P><SPAN style="font-family: calibri, verdana, arial, sans-serif;">Can anyone suggest how to populate 0 value in missing month and can be done in back end scripting side?</SPAN></P><P><SPAN style="font-family: calibri, verdana, arial, sans-serif;">Pls find attach sample application.</SPAN></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, 28 Nov 2013 03:56:38 GMT https://community.qlik.com/t5/QlikView/Populating-0-value-in-missing-month/m-p/501685#M1129807 thomas_skariah 2013-11-28T03:56:38Z Re: Populating 0 value in missing month https://community.qlik.com/t5/QlikView/Populating-0-value-in-missing-month/m-p/501686#M1129808 <HTML><HEAD></HEAD><BODY><P>Have a look here: <A _jive_internal="true" href="https://community.qlik.com/blogs/qlikviewdesignblog/2013/02/05/populating-a-sparsely-populated-field" title="http://community.qlik.com/blogs/qlikviewdesignblog/2013/02/05/populating-a-sparsely-populated-field">http://community.qlik.com/blogs/qlikviewdesignblog/2013/02/05/populating-a-sparsely-populated-field</A></P></BODY></HTML> Thu, 28 Nov 2013 05:20:35 GMT https://community.qlik.com/t5/QlikView/Populating-0-value-in-missing-month/m-p/501686#M1129808 tresB 2013-11-28T05:20:35Z Re: Populating 0 value in missing month https://community.qlik.com/t5/QlikView/Populating-0-value-in-missing-month/m-p/501687#M1129809 <HTML><HEAD></HEAD><BODY><P>Not sure you have formatted data. But logic in script creates missing values for your dimension. Then use sum(value)+0.0001, will show some values for your missing dimension. Later change number format to integer it will round off to zero.</P></BODY></HTML> Thu, 28 Nov 2013 08:13:36 GMT https://community.qlik.com/t5/QlikView/Populating-0-value-in-missing-month/m-p/501687#M1129809 sivarajs 2013-11-28T08:13:36Z