problem "where not" statement sql

Thu, 27 Jan 2011 07:09:20 GMT

I'm writing a very simple query, which unexpectedly is giving me headache:

concatenate (Temp) load * from '$(ArchiveFile)' (qvd)

where not (YearQtr = '$(LoadQtr)' and Scenario = '$(LoadScenario)')

I expected NOT to see only those records, which satisfy both conditions of there where statement. But as a result I see nothing at all. Tried trimming the variables, but to no avail.

To narrow down the problem, the following two "where" statements give me different results. Why?

1) where not (YearQtr = '$(LoadQtr)')

2) where YearQtr <> '$(LoadQtr)'

Thank you!

problem "where not" statement sql

Thu, 27 Jan 2011 07:37:19 GMT

I tried the same splitted where conditions with sample data ,it worked perfectly for me. Probably can you recheck your data again. But the splitted where conditions is correct.

Pls post the sample data if the issue is not resolved.

topic problem "where not" statement sql in QlikView

problem "where not" statement sql

problem "where not" statement sql