4 Replies Latest reply: May 17, 2014 3:48 AM by Yonattan Sentosa RSS

    One condition with more than one value

      Hello, I'm new to qlikview and I don't know how to translate this oracle query into qlikview query. Can someone please help me to translate this query or give me an explanation regarding IN at qlikview?

      Oracle Query :

      CASE

                        WHEN TRAN_TYPE IN

                                ('COS', 'ICO', 'ISI', 'ISS', 'IST', 'RSI', 'FAO')

                        THEN

                           TRAN_AMOUNT

                        ELSE

                           0

                     END