topic pivot table experssion in QlikView https://community.qlik.com/t5/QlikView/pivot-table-experssion/m-p/438637#M562148 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P><BR />Im geeting Zero values is in my pivot table expressions.when i drag the group dimension in to the vertical my expressions is showing zero values which are not related to that perticular group.</P><P>How to hide this not related expression for that group.</P><P></P><P>Thanks in advance.</P></BODY></HTML> Wed, 13 Mar 2013 18:11:25 GMT srinivasa1 2013-03-13T18:11:25Z pivot table experssion https://community.qlik.com/t5/QlikView/pivot-table-experssion/m-p/438637#M562148 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P><BR />Im geeting Zero values is in my pivot table expressions.when i drag the group dimension in to the vertical my expressions is showing zero values which are not related to that perticular group.</P><P>How to hide this not related expression for that group.</P><P></P><P>Thanks in advance.</P></BODY></HTML> Wed, 13 Mar 2013 18:11:25 GMT https://community.qlik.com/t5/QlikView/pivot-table-experssion/m-p/438637#M562148 srinivasa1 2013-03-13T18:11:25Z Re: pivot table experssion https://community.qlik.com/t5/QlikView/pivot-table-experssion/m-p/438638#M562149 <HTML><HEAD></HEAD><BODY><P>You can't. The expression is always shown for all values of the dimension. You cannot change that behaviour.</P></BODY></HTML> Wed, 13 Mar 2013 18:24:15 GMT https://community.qlik.com/t5/QlikView/pivot-table-experssion/m-p/438638#M562149 Gysbert_Wassenaar 2013-03-13T18:24:15Z Re: pivot table experssion https://community.qlik.com/t5/QlikView/pivot-table-experssion/m-p/438639#M562150 <HTML><HEAD></HEAD><BODY><P>Hi </P><P></P><P>Thanks for you replay. I have done IT <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /> dimension we need to supress Null value, it will work.</P></BODY></HTML> Wed, 13 Mar 2013 19:26:20 GMT https://community.qlik.com/t5/QlikView/pivot-table-experssion/m-p/438639#M562150 srinivasa1 2013-03-13T19:26:20Z Re: pivot table experssion https://community.qlik.com/t5/QlikView/pivot-table-experssion/m-p/438640#M562151 <HTML><HEAD></HEAD><BODY><P>check on supress zero value in presentation tab..</P></BODY></HTML> Wed, 13 Mar 2013 19:48:01 GMT https://community.qlik.com/t5/QlikView/pivot-table-experssion/m-p/438640#M562151 er_mohit 2013-03-13T19:48:01Z