if logic help

[mahitham]

Hi Experts,

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

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

[Anonymous]

Where in Qlik do you want to implement this? In the load script or a straight table? You can use SQL directly in load script.

[mahitham]

In UI I have to use by converting into if logic.

these fields are coming from different tables.

[Anonymous]

Are you trying to calculate these two fields as expressions? If yes, then can you post some sample data? Or the app? It is possible to convert this case stmt.

Rgds,

Benazir