Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

cole3481
New Contributor III

Display 0% for Null

Hello.

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?

Tags (1)
1 Solution

Accepted Solutions
Partner
Partner

Re: Display 0% for Null

use an If statement to check if it is null and then show 0% when true and normal value for false.

1 Reply
Partner
Partner

Re: Display 0% for Null

use an If statement to check if it is null and then show 0% when true and normal value for false.