topic Re: where codniton with multiple fields in QlikView

where codniton with multiple fields

soniasweety — Fri, 15 Nov 2024 23:33:25 GMT

Hi all,

I want to load data where multiples is not null or non Zero for 3 fields

I have tried this but not working any other alternate?

Where isnull(Avgscore)=0 and isnull(Isdate)=0 and isnull(attendies)=0;

QFabian — Thu, 26 Nov 2020 12:09:53 GMT

Hi @soniasweety , please check if this works :

Where
not isnull(Avgscore) and Avgscore <>0 and
not isnull(Isdate) and Isdate<>0 and
not isnull(attendies) and attendies<>0;

MayilVahanan — Thu, 26 Nov 2020 13:07:42 GMT

Try like below

where Len(Trim(Avgscore)) > 0 and Len(Trim(Isdate))>0 and Len(Trim(attendies))>0 and Avgscore <> 0 and Isdate <> 0 and attendies<> 0;

-- Len(Trim(Avgscore)) > 0 and Len(Trim(Isdate))>0 and Len(Trim(attendies))>0 <-- it will check for null values

-- Avgscore <> 0 and Isdate <> 0 and attendies<> 0 <-- it will check for zero values