IsNull Syntax

[Anonymous]

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_) ))

[fvelascog72]

Hi,

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

Saludos.

[Anonymous]

  Mkt                 Mfg

15,494
41,353	412

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%.

[Anonymous]

I fixed it by unclicking suppress 0 values.

[vishsaggi · Accepted solution]

Another way you can try like

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