topic Re: Null flag in QlikView

Null flag

Mon, 24 Nov 2014 05:13:32 GMT

Hi,

I am creating a Flag that looks at another column, and if it is Null, set it as 1 in the flag. (If SuperiorIndicator is null, set SuperiorIndicatorFlag to 1.)

Here is my code:

SuperiorIndicatorTemp:

Load SuperiorIndicator,

EQUNR,

1 as SuperiorIndicatorFlag

Resident SCD

Where Len(SuperiorIndicator) = 0

;

Left Join (Equipment)

Load EQUNR,

SuperiorIndicatorFlag

Resident SuperiorIndicatorTemp

;

Drop Table SuperiorIndicatorTemp

;

Any help would be greatly appreciated.

Re: Null flag

sushil353 — Mon, 24 Nov 2014 05:21:44 GMT

Hi,

Try Below Code:

SuperiorIndicatorTemp:

Load SuperiorIndicator,

EQUNR,

if(ISNULL(SuperiorIndicatior),1,0) as SuperiorInidcatorFlag

RESIDENT SCD;

HTH

sushil

Re: Null flag

perumal_41 — Mon, 24 Nov 2014 05:36:05 GMT

Hi,

please check below code

.I hope it help to u

SuperiorIndicatorTemp:

Load SuperiorIndicator,

EQUNR,

1 as SuperiorIndicatorFlag

Resident SCD

Where Len(SuperiorIndicator) = 0 or isnull(SuperiorIndicator)

;

Left Join (Equipment)

Load EQUNR,

SuperiorIndicatorFlag

Resident SuperiorIndicatorTemp

;

Drop Table SuperiorIndicatorTemp

Re: Null flag

anbu1984 — Mon, 24 Nov 2014 05:40:11 GMT

If you don't have matching EQUNR, then still you will get nulls in SuperiorInidcatorFlag.

Left Join (Equipment)

Load EQUNR,

SuperiorIndicatorFlag

Resident SuperiorIndicatorTemp

Re: Null flag

Mon, 24 Nov 2014 05:44:59 GMT

That was it. Thanks Anbu.

Re: Null flag

sujeetsingh — Mon, 24 Nov 2014 05:45:35 GMT

SuperiorIndicatorTemp:

Load SuperiorIndicator,

EQUNR,

1 as SuperiorIndicatorFlag

Resident SCD

Where Len(SuperiorIndicator) = 0

;

InnerJoin (Equipment)

Load EQUNR,

SuperiorIndicatorFlag

Resident SuperiorIndicatorTemp

;

Drop Table SuperiorIndicatorTemp

;