Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
cole3481
New Contributor III

IsNull Syntax

Hello. I am making a market share chart by dividing our market share over total market. My problem is that we do not make some of the products, so I want these to display as 0%. I am new to QlikView, and I do not know how I would write the syntax to do this.

This is what I tried:

If(IsNull(sum(mfg),0,sum(Mfg)/sum(Mkt_) ))

Tags (1)
1 Solution

Accepted Solutions
vishsaggi
Esteemed Contributor III

Re: IsNull Syntax

Another way you can try like

= Alt(sum(Mfg)/sum(Mkt_), 0)

4 Replies
Partner
Partner

Re: IsNull Syntax

Hi,

Could you give us a set of data to better understand your problem?

Saludos.

cole3481
New Contributor III

Re: IsNull Syntax

  Mkt                 Mfg

15,494
41,353412

Our market share(mfg) is null in some spots, so it is not displaying the product in the table when I divide our market share by market. I want this to display as 0%.

cole3481
New Contributor III

Re: IsNull Syntax

I fixed it by unclicking suppress 0 values.

vishsaggi
Esteemed Contributor III

Re: IsNull Syntax

Another way you can try like

= Alt(sum(Mfg)/sum(Mkt_), 0)