topic Re: Exclude garbade Data in QlikView

Exclude garbade Data

mario-sarkis — Wed, 25 Nov 2020 16:16:04 GMT

Dear all

here is my example and hope that you can help:

I have a field PeridoDate number form:

i.e.: I have the below field (PeriodDate)

PeriodDate:

42005

42006

42007

42008

2|Ce

40|dsad

dasf.....

I need to exclude everything note date how can I do it ?

Hope that you can help.

Thanks in Advance

Mario

sunny_talwar — Fri, 14 Jul 2017 15:09:16 GMT

May be like this if everything else is text

LOAD PeriodDate

FROM ...

Where IsNum(PeriodDate);

Anonymous — Fri, 14 Jul 2017 15:14:19 GMT

where isnum(num#(PeriodDate));

when using non numerical field as input...

MarcoWedel — Fri, 14 Jul 2017 23:36:21 GMT

or just

Where PeriodDate;

as all numerical values not qual 0 evaluate as true.

regards

Marco