topic Re: what is the reason? in QlikView https://community.qlik.com/t5/QlikView/what-is-the-reason/m-p/106119#M753262 <HTML><HEAD></HEAD><BODY><P>From Layout tab, Disable the feature called "<STRONG style="text-decoration: underline;">Size to Data</STRONG>"</P></BODY></HTML> Tue, 16 Oct 2018 08:53:57 GMT Anil_Babu_Samineni 2018-10-16T08:53:57Z what is the reason? https://community.qlik.com/t5/QlikView/what-is-the-reason/m-p/106118#M753260 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>i have a different issue&nbsp;&nbsp; i just want to know the reason behind that</P><P></P><P></P><P>i have&nbsp; a filter with&nbsp; market and&nbsp; country&nbsp;&nbsp;&nbsp; and&nbsp; one pivot table&nbsp;&nbsp;&nbsp;&nbsp; if i select&nbsp;&nbsp; one country and one market value&nbsp;&nbsp;&nbsp; </P><P></P><P>the sum(value) =0&nbsp;&nbsp; which is correct but&nbsp;&nbsp;&nbsp;&nbsp; the table is showing&nbsp; zero&nbsp;&nbsp; as a result.</P><P></P><P></P><P>my req:&nbsp; is&nbsp;&nbsp; table should not show anything&nbsp; empty table should show,<IMG alt="reason.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/215976_reason.PNG" style="height: 41px; width: 620px;" /></P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/what-is-the-reason/m-p/106118#M753260 soniasweety 2020-11-25T16:16:04Z Re: what is the reason? https://community.qlik.com/t5/QlikView/what-is-the-reason/m-p/106119#M753262 <HTML><HEAD></HEAD><BODY><P>From Layout tab, Disable the feature called "<STRONG style="text-decoration: underline;">Size to Data</STRONG>"</P></BODY></HTML> Tue, 16 Oct 2018 08:53:57 GMT https://community.qlik.com/t5/QlikView/what-is-the-reason/m-p/106119#M753262 Anil_Babu_Samineni 2018-10-16T08:53:57Z Re: what is the reason? https://community.qlik.com/t5/QlikView/what-is-the-reason/m-p/106120#M753263 <HTML><HEAD></HEAD><BODY><P>Hi Sony, </P><P></P><P>I think you need to surpress zero values: </P><P></P><P>Open Properties, Register "Dimension", then "surpress 0-values":</P><P></P><P><IMG alt="Unbenannt.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/215991_Unbenannt.PNG" style="height: 482px; width: 620px;" /></P><P>Hope this helps.</P><P></P><P>Jakob</P></BODY></HTML> Tue, 16 Oct 2018 08:59:14 GMT https://community.qlik.com/t5/QlikView/what-is-the-reason/m-p/106120#M753263 jakobjosef 2018-10-16T08:59:14Z