3 Replies Latest reply: Mar 1, 2017 9:01 AM by Melanie Simmonds RSS

    where match

    Melanie Simmonds

      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