topic Re: need to display empty campain in QlikView https://community.qlik.com/t5/QlikView/need-to-display-empty-campain/m-p/882715#M1006063 <HTML><HEAD></HEAD><BODY><P>In the table properties | Presentation tab check the Suppress Zero Value option. If contacts, ideas and opportunities are expressions (not dimensions), then any row with all 3 zero will not be displayed.</P><P></P><P>I am not sure what you mean by related records? Please elaborate.</P></BODY></HTML> Tue, 19 May 2015 05:16:42 GMT jonathandienst 2015-05-19T05:16:42Z need to display empty campain https://community.qlik.com/t5/QlikView/need-to-display-empty-campain/m-p/882714#M1006062 <HTML><HEAD></HEAD><BODY><P>i have a straight table following are the fields </P><P></P><P>emp id&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; contacts&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; leads&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; opportunities</P><P><SPAN style="font-size: 13.3333330154419px;">344&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0</SPAN></P><P>1111&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 9</P><P>222&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1</P><P>333&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0</P><P></P><P>like this i have lot of records,scenario is if i have all three fields(contacts,leads,opportunities) are 0 then it should dislpay only related records. needed expression for this</P></BODY></HTML> Tue, 19 May 2015 03:36:17 GMT https://community.qlik.com/t5/QlikView/need-to-display-empty-campain/m-p/882714#M1006062 2015-05-19T03:36:17Z Re: need to display empty campain https://community.qlik.com/t5/QlikView/need-to-display-empty-campain/m-p/882715#M1006063 <HTML><HEAD></HEAD><BODY><P>In the table properties | Presentation tab check the Suppress Zero Value option. If contacts, ideas and opportunities are expressions (not dimensions), then any row with all 3 zero will not be displayed.</P><P></P><P>I am not sure what you mean by related records? Please elaborate.</P></BODY></HTML> Tue, 19 May 2015 05:16:42 GMT https://community.qlik.com/t5/QlikView/need-to-display-empty-campain/m-p/882715#M1006063 jonathandienst 2015-05-19T05:16:42Z