Need help on sql to qlik

[chinnu123]

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]

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]

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

[sunny_talwar · Accepted solution]

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]

Hi Sunny,

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

Thanks,

Chinnu.