5 Replies Latest reply: Nov 16, 2016 4:15 AM by omri levi RSS

    In Clause in QlikView

    omri levi

      Hello,

      I have a table with the following:

           PARENT_ACCOUNT_NO,

           SUBSCR_NO,

           OFFER_INST_ID,

           OFFER_ID,

           DISPLAY_VALUE,

           ACTIVE_DT,

           INACTIVE_DT,

       

      I want to filter something like this sql:

      select SUBSCR_NO from TABLE

      where SUBSCR_NO in (select SUBSCR_NO from TABLE where OFFER_ID in (3,5,6))

      and OFFER_ID in (7,8,9)

       

      So basically I want subscribers that have both offers. This is pretty easy with sql but in qlikview I can't seem to do it.

       

      BTW I know about match function

       

      Thank you