Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
Not applicable

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

1 Solution

Accepted Solutions
shraddha_g
Honored Contributor III

Re: where match

Try

where  match(QueueReporting, 'P896', 'P893', 'P899', 'P840') or (match( 'P841', 'P842', 'P843', 'P844') and date(Datefield) = makedate(2017,02,15));

3 Replies
vikasmahajan
Esteemed Contributor

Re: where match

PFA demo

Vikas

shraddha_g
Honored Contributor III

Re: where match

Try

where  match(QueueReporting, 'P896', 'P893', 'P899', 'P840') or (match( 'P841', 'P842', 'P843', 'P844') and date(Datefield) = makedate(2017,02,15));

Not applicable

Re: where match

Thanks Shraddha