topic Hide null values in a pivot table in QlikView https://community.qlik.com/t5/QlikView/Hide-null-values-in-a-pivot-table/m-p/248929#M94667 <HTML><HEAD></HEAD><BODY><P> Hi, I have created a pivot table expression based on set analysis. The expression just calculates the average of sales for months &gt; Mar-11, however in my model I have sales figures for previous years. </P><P></P><P>In my pivot table I get null values for the months pre Mar-11, however I want to hide these months in my pivot table. I have tried the usual suspects suppress when value is null and suppress zero values. I have two dimensions Month and a Market description. </P><P></P><P>Any help gratefully received.&nbsp; Cheers Darrell.</P></BODY></HTML> Fri, 14 Oct 2011 08:56:22 GMT darrellbutler 2011-10-14T08:56:22Z Hide null values in a pivot table https://community.qlik.com/t5/QlikView/Hide-null-values-in-a-pivot-table/m-p/248929#M94667 <HTML><HEAD></HEAD><BODY><P> Hi, I have created a pivot table expression based on set analysis. The expression just calculates the average of sales for months &gt; Mar-11, however in my model I have sales figures for previous years. </P><P></P><P>In my pivot table I get null values for the months pre Mar-11, however I want to hide these months in my pivot table. I have tried the usual suspects suppress when value is null and suppress zero values. I have two dimensions Month and a Market description. </P><P></P><P>Any help gratefully received.&nbsp; Cheers Darrell.</P></BODY></HTML> Fri, 14 Oct 2011 08:56:22 GMT https://community.qlik.com/t5/QlikView/Hide-null-values-in-a-pivot-table/m-p/248929#M94667 darrellbutler 2011-10-14T08:56:22Z Hide null values in a pivot table https://community.qlik.com/t5/QlikView/Hide-null-values-in-a-pivot-table/m-p/248930#M94668 <HTML><HEAD></HEAD><BODY><P>in dimension take</P><P></P><P>if(Month='Mar-11',Month)</P><P></P><P>and make supress null</P></BODY></HTML> Fri, 14 Oct 2011 09:00:26 GMT https://community.qlik.com/t5/QlikView/Hide-null-values-in-a-pivot-table/m-p/248930#M94668 SunilChauhan 2011-10-14T09:00:26Z