topic Re: Show All values in QlikView https://community.qlik.com/t5/QlikView/Show-All-values/m-p/575257#M214166 <HTML><HEAD></HEAD><BODY><P>Can you tried to Select "Surpress When Value is Null" check box under dimension tab???</P></BODY></HTML> Fri, 14 Mar 2014 10:05:54 GMT jsingh71 2014-03-14T10:05:54Z Show All values https://community.qlik.com/t5/QlikView/Show-All-values/m-p/575253#M214162 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I am using Show all values option to show all the null values and missing values by unchecking supress null values and zero values.</P><P>When Doing so everything is working fine but an extra column and row is getting added in the pivot table.How to avoid that?</P><P></P><P>Any Ideas?</P><P>Thanks in Advance</P></BODY></HTML> Fri, 14 Mar 2014 08:35:52 GMT https://community.qlik.com/t5/QlikView/Show-All-values/m-p/575253#M214162 2014-03-14T08:35:52Z Re: Show All values https://community.qlik.com/t5/QlikView/Show-All-values/m-p/575254#M214163 <HTML><HEAD></HEAD><BODY><P>Can you share Screenshot of your pivot table chart.</P></BODY></HTML> Fri, 14 Mar 2014 08:51:21 GMT https://community.qlik.com/t5/QlikView/Show-All-values/m-p/575254#M214163 jsingh71 2014-03-14T08:51:21Z Re: Show All values https://community.qlik.com/t5/QlikView/Show-All-values/m-p/575255#M214164 <HTML><HEAD></HEAD><BODY><P>Hi Murali,</P><P></P><P>Go to char properties and tick option "Supress When Value is Null"</P><P></P><P><IMG alt="" class="jiveImage" src="https://community.qlik.com/legacyfs/online/54978_pastedImage_0.png" style="width: 620px; height: 538px;" /></P><P></P><P>Thanks,<BR />AS</P></BODY></HTML> Fri, 14 Mar 2014 09:00:39 GMT https://community.qlik.com/t5/QlikView/Show-All-values/m-p/575255#M214164 amit_saini 2014-03-14T09:00:39Z Re: Re: Show All values https://community.qlik.com/t5/QlikView/Show-All-values/m-p/575256#M214165 <HTML><HEAD></HEAD><BODY><P>Hi PFA</P><P></P><P>Here I am using show all values by unchecking suppress zero values and Null Values.In doing that an extra column and row is getting added.</P></BODY></HTML> Fri, 14 Mar 2014 09:58:30 GMT https://community.qlik.com/t5/QlikView/Show-All-values/m-p/575256#M214165 2014-03-14T09:58:30Z Re: Show All values https://community.qlik.com/t5/QlikView/Show-All-values/m-p/575257#M214166 <HTML><HEAD></HEAD><BODY><P>Can you tried to Select "Surpress When Value is Null" check box under dimension tab???</P></BODY></HTML> Fri, 14 Mar 2014 10:05:54 GMT https://community.qlik.com/t5/QlikView/Show-All-values/m-p/575257#M214166 jsingh71 2014-03-14T10:05:54Z Re: Show All values https://community.qlik.com/t5/QlikView/Show-All-values/m-p/575258#M214167 <HTML><HEAD></HEAD><BODY><P>Null column might be occurring due to month missing in one of the data and same applied for other dimension as well.</P></BODY></HTML> Fri, 14 Mar 2014 10:09:58 GMT https://community.qlik.com/t5/QlikView/Show-All-values/m-p/575258#M214167 manojkulkarni 2014-03-14T10:09:58Z