topic Chart Problem in QlikView https://community.qlik.com/t5/QlikView/Chart-Problem/m-p/273320#M102280 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>The 'Top(Sales,1,RowNo()-0)' bit seems to force every Salesman/Month combination to be displayed, overriding the chart settings for suppress zero/null values.</P><P></P><P>Adding a further aggregation e.g. aggr(&nbsp; rangesum(top(Sales, 1, RowNo() -0))&nbsp; ,Salesman,Month) may solve the problem,</P><P></P><P>Regards,</P><P></P><P>HD</P></BODY></HTML> Tue, 16 Aug 2011 09:26:10 GMT hdonald 2011-08-16T09:26:10Z Chart Problem https://community.qlik.com/t5/QlikView/Chart-Problem/m-p/273319#M102279 <HTML><HEAD></HEAD><BODY><P>I have a trellis chart that simply shows sales by month by Salesman. The chart works fine. As soon as I add a cummulative sales line using:</P><P>rangesum(top(Sales, 1, RowNo() -0)) </P><P>all Salesman show up even when they do not have any sales.</P><P>Why?</P><P>Thanks,</P><P>Stephen</P></BODY></HTML> Mon, 15 Aug 2011 18:13:08 GMT https://community.qlik.com/t5/QlikView/Chart-Problem/m-p/273319#M102279 2011-08-15T18:13:08Z Chart Problem https://community.qlik.com/t5/QlikView/Chart-Problem/m-p/273320#M102280 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>The 'Top(Sales,1,RowNo()-0)' bit seems to force every Salesman/Month combination to be displayed, overriding the chart settings for suppress zero/null values.</P><P></P><P>Adding a further aggregation e.g. aggr(&nbsp; rangesum(top(Sales, 1, RowNo() -0))&nbsp; ,Salesman,Month) may solve the problem,</P><P></P><P>Regards,</P><P></P><P>HD</P></BODY></HTML> Tue, 16 Aug 2011 09:26:10 GMT https://community.qlik.com/t5/QlikView/Chart-Problem/m-p/273320#M102280 hdonald 2011-08-16T09:26:10Z