topic Re: if logic help in QlikView

if logic help

mahitham — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: if logic help

Anonymous — Thu, 12 Apr 2018 07:34:46 GMT

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.

Re: if logic help

mahitham — Thu, 12 Apr 2018 07:59:54 GMT

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

these fields are coming from different tables.

Re: if logic help

Anonymous — Thu, 12 Apr 2018 08:23:55 GMT

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