Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
In UI I have to use by converting into if logic.
these fields are coming from different tables.
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