topic Re: IsNull Syntax in QlikView

IsNull Syntax

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: IsNull Syntax

fvelascog72 — Wed, 16 May 2018 14:38:43 GMT

Hi,

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

Saludos.

Re: IsNull Syntax

Anonymous — Wed, 16 May 2018 14:44:47 GMT

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

Re: IsNull Syntax

Anonymous — Wed, 16 May 2018 14:53:27 GMT

I fixed it by unclicking suppress 0 values.

Re: IsNull Syntax

vishsaggi — Wed, 16 May 2018 15:08:54 GMT

Another way you can try like

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