Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
mahitham
Creator II
Creator II

isnull()

Hi Experts,

Can any one please help me to convert below two sql logics into Qlik.

SELECT

ID,

ISNULL(CAST (RESTI.KEY as NVARCHAR(1024))," ") KEY

FROM

Thanks in advance.

1 Solution

Accepted Solutions
jyothish8807
Master II
Master II

Hi Mahitha,

Try like this:

Load

ID,

if(isnull(PKEY)=-1,' ',PKEY) as PKEY,

if(isnull(DESCRIPTION)=-1,' ',DESCRIPTION) as DESCRIPTION

from

<>

Best Regards,
KC

View solution in original post

1 Reply
jyothish8807
Master II
Master II

Hi Mahitha,

Try like this:

Load

ID,

if(isnull(PKEY)=-1,' ',PKEY) as PKEY,

if(isnull(DESCRIPTION)=-1,' ',DESCRIPTION) as DESCRIPTION

from

<>

Best Regards,
KC