topic Re: Need help on sql to qlik in QlikView

Need help on sql to qlik

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

Hi team,

Can any one help me to convert below sql query to qlik

case(case when id='bose' then coalesce(incident id, id) else id end) when 'AD' then 'Application Desktop'

when 'NEW' then 'SCOPE' else Id end) as condition

And also please any one tell what lag function do in sql

And what is the similar function in qlik.

Thanks in advance,

Thanks,

Chinnu.

tomasz_tru — Mon, 28 Aug 2017 18:48:48 GMT

Why don'tt you use SQL in Qlik load script?

BTW. equivalent of COALESCENCE in Qlik is ALT() function - but only for numeric.

Tomasz

sergio0592 — Mon, 28 Aug 2017 19:16:08 GMT

Lag function returns values from a previous row in the table. Equivalent in Qlikview is Above() function.

sunny_talwar — Mon, 28 Aug 2017 19:24:16 GMT

May be this:

If(

If(id = 'bose', If(Len(Trim([incident id])) = 0, id, [incident id]), id) = 'AD', 'Application Desktop',

If(

If(id = 'bose', If(Len(Trim([incident id])) = 0, id, [incident id]), id) = 'NEW', 'SCOPE', id))) as condition

chinnu123 — Wed, 30 Aug 2017 08:55:34 GMT

Hi Sunny,

Thanks for your time on this, It's working fine

Thanks,

Chinnu.