
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
where match
I'm still fairly new to QlikView so apologies if this seems like a really simple question
I have an extract which retrieves information from our phone system and is extracting data based on queue numbers, i.e.
where match(QueueReporting, 'P896', 'P893', 'P899', 'P840', 'P841', 'P842', 'P843', 'P844');
Queues P841-P844 have been used in the past but for reporting purposes, only need to report from the 15/02/17. What's the expression needed to single out these four queues to report from a particular date only?
Many thanks for your help
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Try
where match(QueueReporting, 'P896', 'P893', 'P899', 'P840') or (match( 'P841', 'P842', 'P843', 'P844') and date(Datefield) = makedate(2017,02,15));

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
PFA demo
Vikas
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Try
where match(QueueReporting, 'P896', 'P893', 'P899', 'P840') or (match( 'P841', 'P842', 'P843', 'P844') and date(Datefield) = makedate(2017,02,15));

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thanks Shraddha
