topic Display 0% for Null in QlikView https://community.qlik.com/t5/QlikView/Display-0-for-Null/m-p/41264#M771801 <HTML><HEAD></HEAD><BODY><P>Hello.</P><P></P><P>I am currently making a market share chart for products. I am dividing our market share by the total market. There are some types of products in the market that we do not sell, or do not sell any of them in some months, so the chart will leave their values out. I want those values to display as 0% instead of not being there. How could I do this?</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT Anonymous 2020-11-25T16:16:04Z Display 0% for Null https://community.qlik.com/t5/QlikView/Display-0-for-Null/m-p/41264#M771801 <HTML><HEAD></HEAD><BODY><P>Hello.</P><P></P><P>I am currently making a market share chart for products. I am dividing our market share by the total market. There are some types of products in the market that we do not sell, or do not sell any of them in some months, so the chart will leave their values out. I want those values to display as 0% instead of not being there. How could I do this?</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Display-0-for-Null/m-p/41264#M771801 Anonymous 2020-11-25T16:16:04Z Re: Display 0% for Null https://community.qlik.com/t5/QlikView/Display-0-for-Null/m-p/41265#M771802 <HTML><HEAD></HEAD><BODY><P>use an If statement to check if it is null and then show 0% when true and normal value for false.</P></BODY></HTML> Wed, 16 May 2018 14:10:26 GMT https://community.qlik.com/t5/QlikView/Display-0-for-Null/m-p/41265#M771802 bramkn 2018-05-16T14:10:26Z