topic Re: Null Column in QlikView https://community.qlik.com/t5/QlikView/Null-Column/m-p/792052#M1261115 <HTML><HEAD></HEAD><BODY><P>IF the whole column has nothing but nulls or zeroes you can suppress it using these properties circled below. </P><P></P><P>additionally, a common trick is put an IF expression on the expression to make it zero or null based on a condition... then use these to remove the unwanted rows/columns as well.</P><P></P><P><IMG alt="Capture.PNG.png" class="jive-image" src="https://community.qlik.com/legacyfs/online/70763_Capture.PNG.png" style="width: 620px; height: 544px;" /></P></BODY></HTML> Fri, 07 Nov 2014 20:33:27 GMT JonnyPoole 2014-11-07T20:33:27Z Null Column https://community.qlik.com/t5/QlikView/Null-Column/m-p/792051#M1261113 <HTML><HEAD></HEAD><BODY><P>Hello I have a pivot table</P><P></P><P>i have several columns<BR /> i use in one column the after expression.<BR /> so i can show the difference between the same columns of two years.</P><P>2014&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2013<BR />&nbsp;&nbsp; </P><P>number difference&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; number&nbsp;&nbsp;&nbsp;&nbsp; difference</P><P>100&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 50&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 50&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -</P><P></P><P>e.g. 2014 difference from 2013. but the difference column of 2013 is empty. all null values.</P><P>Is it possible to not showing this empty column?</P></BODY></HTML> Mon, 26 Jan 2026 18:19:17 GMT https://community.qlik.com/t5/QlikView/Null-Column/m-p/792051#M1261113 2026-01-26T18:19:17Z Re: Null Column https://community.qlik.com/t5/QlikView/Null-Column/m-p/792052#M1261115 <HTML><HEAD></HEAD><BODY><P>IF the whole column has nothing but nulls or zeroes you can suppress it using these properties circled below. </P><P></P><P>additionally, a common trick is put an IF expression on the expression to make it zero or null based on a condition... then use these to remove the unwanted rows/columns as well.</P><P></P><P><IMG alt="Capture.PNG.png" class="jive-image" src="https://community.qlik.com/legacyfs/online/70763_Capture.PNG.png" style="width: 620px; height: 544px;" /></P></BODY></HTML> Fri, 07 Nov 2014 20:33:27 GMT https://community.qlik.com/t5/QlikView/Null-Column/m-p/792052#M1261115 JonnyPoole 2014-11-07T20:33:27Z