topic Re: Hiding lines with zero value from pivot table in QlikView https://community.qlik.com/t5/QlikView/Hiding-lines-with-zero-value-from-pivot-table/m-p/886903#M998280 <HTML><HEAD></HEAD><BODY><P>Hi !</P><P></P><P>You can use this in the Chart Properties:</P><P></P><P><IMG alt="Supress when Value is Null.jpg" class="jive-image image-1" src="/legacyfs/online/89431_Supress when Value is Null.jpg" style="height: auto;" /></P><P>Best Regards</P><P></P><P>Mike Preuss</P></BODY></HTML> Mon, 15 Jun 2015 11:33:07 GMT qlikview2015 2015-06-15T11:33:07Z Hiding lines with zero value from pivot table https://community.qlik.com/t5/QlikView/Hiding-lines-with-zero-value-from-pivot-table/m-p/886901#M998278 <HTML><HEAD></HEAD><BODY><P>Hello All,</P><P><SPAN style="font-size: 10pt; line-height: 1.5em;"><BR /></SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;">I am having a table where I want to exclude lines with zero value.</SPAN></P><P>Is there a have only those dimension where value exist?</P><P></P><P>Thanks in advance.</P><P>Regards,</P><P>IK </P></BODY></HTML> Sat, 13 Jun 2015 18:49:30 GMT https://community.qlik.com/t5/QlikView/Hiding-lines-with-zero-value-from-pivot-table/m-p/886901#M998278 2015-06-13T18:49:30Z Re: Hiding lines with zero value from pivot table https://community.qlik.com/t5/QlikView/Hiding-lines-with-zero-value-from-pivot-table/m-p/886902#M998279 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>You can use if(len(dimension)&gt;0,dimension)</P><P></P><P>Also this can be handled from scipt side.</P><P></P><P>Please be more descriptive or please share a sample qvw as your question is not clear.</P><P></P><P>Regards</P></BODY></HTML> Mon, 15 Jun 2015 10:14:50 GMT https://community.qlik.com/t5/QlikView/Hiding-lines-with-zero-value-from-pivot-table/m-p/886902#M998279 2015-06-15T10:14:50Z Re: Hiding lines with zero value from pivot table https://community.qlik.com/t5/QlikView/Hiding-lines-with-zero-value-from-pivot-table/m-p/886903#M998280 <HTML><HEAD></HEAD><BODY><P>Hi !</P><P></P><P>You can use this in the Chart Properties:</P><P></P><P><IMG alt="Supress when Value is Null.jpg" class="jive-image image-1" src="/legacyfs/online/89431_Supress when Value is Null.jpg" style="height: auto;" /></P><P>Best Regards</P><P></P><P>Mike Preuss</P></BODY></HTML> Mon, 15 Jun 2015 11:33:07 GMT https://community.qlik.com/t5/QlikView/Hiding-lines-with-zero-value-from-pivot-table/m-p/886903#M998280 qlikview2015 2015-06-15T11:33:07Z