topic If condition in where clause during data load in QlikView

If condition in where clause during data load

Sun, 23 Nov 2014 18:18:52 GMT

Hi all,

I have a data set with the following sttucture

Type	Date	Value
A	1/1/2001	10
A	2/2/2001	20
B		15
B		90
A		70

The Data is such that Type B will always have null in Date Column. While loading the data, I need to filter all values where Date is null for Type A. In this case, I should not load the last row. How can I achieve this while loading the script? Any help?

I tried the below and it doesn't seem to work:

where ( if([Type]='A', [Date]>0));

Re: If condition in where clause during data load

maxgro — Sun, 23 Nov 2014 18:23:39 GMT

to get records with Type = 'A' and Date not null you can use len(trim(.....))

load

....

from

.....

where

Type = 'A' and len(trim(Date))>0

;

Re: If condition in where clause during data load

Sun, 23 Nov 2014 18:25:38 GMT

But I would also like to keep records where Type='B' and date will be null for them

Re: If condition in where clause during data load

maxgro — Sun, 23 Nov 2014 18:29:33 GMT

(Type = 'A' and len(trim(Date))>0) or Type='B'

Re: If condition in where clause during data load

robert99 — Sun, 23 Nov 2014 18:33:59 GMT

Could you use <>

where

Type <> ('A' and len(trim(Date))>0))

Re: If condition in where clause during data load

MarcoWedel — Sun, 23 Nov 2014 20:22:00 GMT

Where not (Type='A' and IsNull(Date))

Re: If condition in where clause during data load

MarcoWedel — Sun, 23 Nov 2014 20:25:13 GMT

Where Type<>'A' or not IsNull(Date)