topic legend in QlikView https://community.qlik.com/t5/QlikView/legend/m-p/964240#M960146 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P>I have below mentioned data. I have to create a stacked bar graph.</P><P>Dimension-Year,Customer Id</P><P>Expression-Sum(Sales)</P><P>My requirement is when nothing is selected the legend in graph should show all customer id although there is no data for last one.</P><P></P><P>Data</P><P></P><P><SPAN style="color: #0000ff; font-size: 8pt;"><STRONG>LOAD</STRONG></SPAN><SPAN style="font-size: 8pt;"> * </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">INLINE</SPAN><SPAN style="font-size: 8pt;"> </SPAN><SPAN style="color: #800000; font-size: 8pt;">[<BR /> CustomerID, Year, Sales<BR /> <BR /> 1,2010,2<BR /> 2,2010,2<BR /> 3,2010,2<BR /> 1,2011,2<BR /> 2,2011,2<BR /> 1,2012,2<BR /> 2,2012,2<BR /> 3,2012,2<BR /> 3,,2<BR /> 2,,2<BR /> 4,,2<BR /> 5,,0<BR /> ]</SPAN><SPAN style="font-size: 8pt;">;<BR /> <BR /> </SPAN></P></BODY></HTML> Mon, 26 Oct 2015 13:21:33 GMT ankit777 2015-10-26T13:21:33Z legend https://community.qlik.com/t5/QlikView/legend/m-p/964240#M960146 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P>I have below mentioned data. I have to create a stacked bar graph.</P><P>Dimension-Year,Customer Id</P><P>Expression-Sum(Sales)</P><P>My requirement is when nothing is selected the legend in graph should show all customer id although there is no data for last one.</P><P></P><P>Data</P><P></P><P><SPAN style="color: #0000ff; font-size: 8pt;"><STRONG>LOAD</STRONG></SPAN><SPAN style="font-size: 8pt;"> * </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">INLINE</SPAN><SPAN style="font-size: 8pt;"> </SPAN><SPAN style="color: #800000; font-size: 8pt;">[<BR /> CustomerID, Year, Sales<BR /> <BR /> 1,2010,2<BR /> 2,2010,2<BR /> 3,2010,2<BR /> 1,2011,2<BR /> 2,2011,2<BR /> 1,2012,2<BR /> 2,2012,2<BR /> 3,2012,2<BR /> 3,,2<BR /> 2,,2<BR /> 4,,2<BR /> 5,,0<BR /> ]</SPAN><SPAN style="font-size: 8pt;">;<BR /> <BR /> </SPAN></P></BODY></HTML> Mon, 26 Oct 2015 13:21:33 GMT https://community.qlik.com/t5/QlikView/legend/m-p/964240#M960146 ankit777 2015-10-26T13:21:33Z Re: legend https://community.qlik.com/t5/QlikView/legend/m-p/964241#M960147 <HTML><HEAD></HEAD><BODY><P>if you define "Show all values" and unclick "suppress Zero values"</P><P>the legend should Show all Customer Id</P></BODY></HTML> Mon, 26 Oct 2015 13:23:41 GMT https://community.qlik.com/t5/QlikView/legend/m-p/964241#M960147 Anonymous 2015-10-26T13:23:41Z