topic Generate 0 when there is no Sales in QlikView https://community.qlik.com/t5/QlikView/Generate-0-when-there-is-no-Sales/m-p/915432#M982275 <HTML><HEAD></HEAD><BODY><P>Hi Experts</P><P></P><P>I have a Sales Straight Table</P><P><SPAN style="font-size: 10pt; line-height: 1.5em;"><STRONG> dimensions are </STRONG></SPAN></P><P>Branch</P><P>Branch Name</P><P>Sales Manager</P><P><STRONG>Expressions are</STRONG></P><P>Monthly Targets against <SPAN style="font-size: 13.3333330154419px;">Sales Manager</SPAN></P><P>Sales </P><P>Now some branch don't have sales at the first week of the month, </P><P>so instead of their <SPAN style="font-size: 13.3333330154419px;">Sales values showing as Zero, the entire line is not showing up in the table</SPAN></P><P><SPAN style="font-size: 13.3333330154419px;">i tried un checking suppress&nbsp; when the value is null, check show all values&nbsp; in dimensions tab</SPAN></P><P><SPAN style="font-size: 13.3333330154419px;">i tried&nbsp; <SPAN style="font-size: 13.3333330154419px;">un checking suppress <SPAN style="font-size: 13.3333330154419px;">Zero&nbsp; </SPAN>values , 0 in null symbol and missing symbol </SPAN></SPAN></P><P><SPAN style="font-size: 13.3333330154419px;">Any other Ideas to generate <SPAN style="font-size: 13.3333330154419px;">Zero for branches with No <SPAN style="font-size: 13.3333330154419px;">Sales</SPAN></SPAN></SPAN></P><P></P><P>Please Suggest</P></BODY></HTML> Fri, 07 Aug 2015 11:12:59 GMT 2015-08-07T11:12:59Z Generate 0 when there is no Sales https://community.qlik.com/t5/QlikView/Generate-0-when-there-is-no-Sales/m-p/915432#M982275 <HTML><HEAD></HEAD><BODY><P>Hi Experts</P><P></P><P>I have a Sales Straight Table</P><P><SPAN style="font-size: 10pt; line-height: 1.5em;"><STRONG> dimensions are </STRONG></SPAN></P><P>Branch</P><P>Branch Name</P><P>Sales Manager</P><P><STRONG>Expressions are</STRONG></P><P>Monthly Targets against <SPAN style="font-size: 13.3333330154419px;">Sales Manager</SPAN></P><P>Sales </P><P>Now some branch don't have sales at the first week of the month, </P><P>so instead of their <SPAN style="font-size: 13.3333330154419px;">Sales values showing as Zero, the entire line is not showing up in the table</SPAN></P><P><SPAN style="font-size: 13.3333330154419px;">i tried un checking suppress&nbsp; when the value is null, check show all values&nbsp; in dimensions tab</SPAN></P><P><SPAN style="font-size: 13.3333330154419px;">i tried&nbsp; <SPAN style="font-size: 13.3333330154419px;">un checking suppress <SPAN style="font-size: 13.3333330154419px;">Zero&nbsp; </SPAN>values , 0 in null symbol and missing symbol </SPAN></SPAN></P><P><SPAN style="font-size: 13.3333330154419px;">Any other Ideas to generate <SPAN style="font-size: 13.3333330154419px;">Zero for branches with No <SPAN style="font-size: 13.3333330154419px;">Sales</SPAN></SPAN></SPAN></P><P></P><P>Please Suggest</P></BODY></HTML> Fri, 07 Aug 2015 11:12:59 GMT https://community.qlik.com/t5/QlikView/Generate-0-when-there-is-no-Sales/m-p/915432#M982275 2015-08-07T11:12:59Z Re: Generate 0 when there is no Sales https://community.qlik.com/t5/QlikView/Generate-0-when-there-is-no-Sales/m-p/915433#M982276 <HTML><HEAD></HEAD><BODY><P><A href="https://community.qlik.com/docs/DOC-3786">Generating Missing Data In QlikView</A></P></BODY></HTML> Fri, 07 Aug 2015 11:49:39 GMT https://community.qlik.com/t5/QlikView/Generate-0-when-there-is-no-Sales/m-p/915433#M982276 m_woolf 2015-08-07T11:49:39Z