7 Replies Latest reply: Apr 12, 2018 8:15 AM by youssef belloum RSS

    if logic help

    Mahitha M

      Hi Experts,

       

      Can any one please help me on replicating below Oracle case logic rankfield and usage field into Qlik.

      Note:

      I cant use the direct query in the backend. I have to implement in UI only.

       

      Case

      when id in (7,8,9) then p.rank

      when id != 7 then r.rank

      else  null                                     as       rankfield

       

      ----------------------------------------------------

      Case

         when m.id in (7,8,9,10,11) then

           case

              when r.usd  is null then 1000

               else  r.usd

      end

                else null

      end                                        as udagefield

       

      --------------------------------------------------------------------------

      thanks in advance