topic Re: where clause Question in QlikView

where clause Question

Anonymous — Fri, 07 Oct 2016 21:10:48 GMT

I am trying to load all rows besides the first 2 in below table. my code is under, it is not working. any clue?

From [one.qvd](qvd)

where ([Date] <> '1/17/2016' and [File name] <> 'abc')

or ([Date] <> '1/17/2016' and [File name] <> 'def');

I also tried: but no success

where not ([Date] = '1/17/2016' and [File name] = 'abc')

or ([Date] = '1/17/2016' and [File name] = 'def');

sunny_talwar — Fri, 07 Oct 2016 21:14:42 GMT

This seems to be working:

Table:

LOAD * INLINE [

Date, File name

1/17/2015, abc

1/17/2015, def

1/17/2015, ghj

3/21/2015, abc

3/21/2015, def

3/21/2015, ghj

4/12/2016, abc

4/12/2016, def

4/12/2016, ghj

]

Where not (Date = MakeDate(2015, 1, 17) and Match([File name], 'abc', 'def'));

Anonymous — Fri, 07 Oct 2016 21:42:01 GMT

Sunny, you never miss your target. it worked like a charm. Thank you so much. however I have some questions which I will post later.

sunny_talwar — Fri, 07 Oct 2016 21:43:36 GMT

Sounds like a plan

Anonymous — Wed, 12 Oct 2016 22:52:25 GMT

I tried without the make date :>>>>>>>>>

where Not ([Date] = '1/17/2016' and Match([File name], 'abc', 'def')); This works.

But this one should also work logic wise: where ([Date] <> '1/17/2016' and File name <> 'abc')

or ([Date] <> '1/17/2016' and File name <> 'def');any idea why this is not working. In my sample app, it did not load any data for 1/17/2016.

sunny_talwar — Wed, 12 Oct 2016 23:44:49 GMT

I think ands and ors are off... try this:

Where ([Date] <> '1/17/2016' or File name <> 'abc') and ([Date] <> '1/17/2016' or File name <> 'def');

Where ([Date] <> '1/17/2016' or (File name <> 'abc' and File name <> 'def'));

Anonymous — Thu, 13 Oct 2016 16:19:10 GMT

both of your codes worked. Thank you. I need to reassess my logic.