
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
where clause
Hi,
I'm trying to run a query with a where clause saying where "YEAR" = '2011' and '2012'; but i keep getting an error message. What is the correct way of doing this?
Thanks
- « Previous Replies
-
- 1
- 2
- Next Replies »


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
where YEAR = '2011' AND YEAR = '2012'
YOU CAN DO
WHERE YEAR> '2011' TOO..
REGARDS

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thanks. What if i wanted to only pick up years, say, 2006 & 2012 but not the ones in between?

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
HI
where YEAR = '2006' AND YEAR = '2012'
or
use match(Year,'2006','2012') also
Hope it helps
Please close the thread by marking correct answer & give likes if you like the post.


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
where YEAR = '2006' AND YEAR = '2012'
only load thesse yaer.
where YEAR > '2006' AND YEAR < '2012'
will be 2007,, 2008, 2009, 2010, 2011.
Hope it help..
you can add = too..
=<
=>


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
where YEAR = '2006' OR YEAR = '2012'
So you get both.
The Value in Field YEAR" can not be '2006" AND '2012' in one Row.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
where "SSS_BATCH_ID" = '726' AND "SSS_BATCH_ID" = '829';

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi
Did you try match function?
Like
Where match(SSS_BATCH_ID,726,829)
Please close the thread by marking correct answer & give likes if you like the post.


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
where SSS_BATCH_ID = '726' OR SSS_BATCH_ID = '829';
The quotes say QlikView that it is not a field.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Yes i tried the match function and that didn't work either

- « Previous Replies
-
- 1
- 2
- Next Replies »