topic zero as null in QlikView https://community.qlik.com/t5/QlikView/zero-as-null/m-p/74487#M784922 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>We have 3 filters.</P><P></P><P>Year</P><P>Product</P><P>Country</P><P></P><P>Chart: Pivot table</P><P></P><P>We the user selects year we have data for only 2018 and remaing all are zeros.</P><P>We the user selects product = Mobile we have data and remaing all were zeros.</P><P></P><P>Here the user needs like they don't want to see zeros when the user selects a year</P><P></P><P>and they want to see zeros for other selections.</P><P></P><P>Finally for time dimension we need to supress zeros if they select any year and if any zeros they need to supress.</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT nareshthavidishetty 2020-11-25T16:16:04Z zero as null https://community.qlik.com/t5/QlikView/zero-as-null/m-p/74487#M784922 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>We have 3 filters.</P><P></P><P>Year</P><P>Product</P><P>Country</P><P></P><P>Chart: Pivot table</P><P></P><P>We the user selects year we have data for only 2018 and remaing all are zeros.</P><P>We the user selects product = Mobile we have data and remaing all were zeros.</P><P></P><P>Here the user needs like they don't want to see zeros when the user selects a year</P><P></P><P>and they want to see zeros for other selections.</P><P></P><P>Finally for time dimension we need to supress zeros if they select any year and if any zeros they need to supress.</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/zero-as-null/m-p/74487#M784922 nareshthavidishetty 2020-11-25T16:16:04Z Re: zero as null https://community.qlik.com/t5/QlikView/zero-as-null/m-p/74488#M784923 <HTML><HEAD></HEAD><BODY><P>Replace all your expressions like this</P><P></P><P>If(Current exp &gt;0,Current Exp,Null())</P></BODY></HTML> Thu, 08 Mar 2018 13:57:20 GMT https://community.qlik.com/t5/QlikView/zero-as-null/m-p/74488#M784923 qlik4asif 2018-03-08T13:57:20Z Re: zero as null https://community.qlik.com/t5/QlikView/zero-as-null/m-p/74489#M784924 <HTML><HEAD></HEAD><BODY><P>Please provide a sample</P></BODY></HTML> Fri, 09 Mar 2018 12:31:27 GMT https://community.qlik.com/t5/QlikView/zero-as-null/m-p/74489#M784924 sasiparupudi1 2018-03-09T12:31:27Z