3 Replies Latest reply: Feb 26, 2013 3:01 PM by Jim Chadwick RSS

    "in" statement? or something like it? help! :)

      Hey guys. Is there a way to use an "IN" statement, like in SQL, inside of Qlikview?


      Here's the piece of my expression where I need to use it (I know that my expression isn't complete):


      sum(if(apel_ltr_snt_dt - [Received_Date]<=60 and dsft_sevy_ds = 'Standard60' and [Medicare Type] in  'C', 'D', 'W', 'P'


      See where I used the "in" at the end?


      Can this be done? If so, how would I write it?