topic Suppress Zero Values behaviour differs between QV11.20 and QV12.10 when using ValueList as dimension in QlikView https://community.qlik.com/t5/QlikView/Suppress-Zero-Values-behaviour-differs-between-QV11-20-and-QV12/m-p/25977#M4283 <HTML><HEAD></HEAD><BODY><P>Currently testing our apps on QV 12.10 before we upgrade from QV 11.20.<BR />I've noticed that some of our straight table charts are suddenly suppressing zero values where they weren't before.</P><P>It seems to only be the case in those objects where the <STRONG>Dimension</STRONG> is a <STRONG>ValueList()</STRONG>. Suppress Values is checked by default, so this problem is just lurking there.<BR />We use NPrinting so have utilised ValueList() with Pick(RowNo()..) quite a bit to create many custom tables with user friendly notations.</P><P></P><P>My question is whether I might be misinterpreting this issue?<BR />OR if it is a bug - is the 'fix' documented anywhere and if not, would be good to get this out there to inform others who might encounter the issue.</P><P></P><P>I've attached the TestApp.qvw which demonstrates the issue if opened in QV11 ie. a zero value is showing where it shouldn't.<BR />Screenshots to support this. Please excuse my handwriting!</P><P></P><P><IMG __jive_id="200952" alt="ValueListDimensionQV11.png" class="jive-image image-1" height="469" src="https://community.qlik.com/legacyfs/online/200952_ValueListDimensionQV11.png" style="height: 469.283px; width: 448px;" width="448" /><IMG __jive_id="200953" alt="ValueListDimensionQV12.png" class="jive-image image-2" height="396" src="https://community.qlik.com/legacyfs/online/200953_ValueListDimensionQV12.png" style="font-size: 13.3333px; height: 395.721px; width: 448px;" width="448" /></P></BODY></HTML> Fri, 27 Apr 2018 07:34:35 GMT duncanblaine 2018-04-27T07:34:35Z Suppress Zero Values behaviour differs between QV11.20 and QV12.10 when using ValueList as dimension https://community.qlik.com/t5/QlikView/Suppress-Zero-Values-behaviour-differs-between-QV11-20-and-QV12/m-p/25977#M4283 <HTML><HEAD></HEAD><BODY><P>Currently testing our apps on QV 12.10 before we upgrade from QV 11.20.<BR />I've noticed that some of our straight table charts are suddenly suppressing zero values where they weren't before.</P><P>It seems to only be the case in those objects where the <STRONG>Dimension</STRONG> is a <STRONG>ValueList()</STRONG>. Suppress Values is checked by default, so this problem is just lurking there.<BR />We use NPrinting so have utilised ValueList() with Pick(RowNo()..) quite a bit to create many custom tables with user friendly notations.</P><P></P><P>My question is whether I might be misinterpreting this issue?<BR />OR if it is a bug - is the 'fix' documented anywhere and if not, would be good to get this out there to inform others who might encounter the issue.</P><P></P><P>I've attached the TestApp.qvw which demonstrates the issue if opened in QV11 ie. a zero value is showing where it shouldn't.<BR />Screenshots to support this. Please excuse my handwriting!</P><P></P><P><IMG __jive_id="200952" alt="ValueListDimensionQV11.png" class="jive-image image-1" height="469" src="https://community.qlik.com/legacyfs/online/200952_ValueListDimensionQV11.png" style="height: 469.283px; width: 448px;" width="448" /><IMG __jive_id="200953" alt="ValueListDimensionQV12.png" class="jive-image image-2" height="396" src="https://community.qlik.com/legacyfs/online/200953_ValueListDimensionQV12.png" style="font-size: 13.3333px; height: 395.721px; width: 448px;" width="448" /></P></BODY></HTML> Fri, 27 Apr 2018 07:34:35 GMT https://community.qlik.com/t5/QlikView/Suppress-Zero-Values-behaviour-differs-between-QV11-20-and-QV12/m-p/25977#M4283 duncanblaine 2018-04-27T07:34:35Z