topic Re: NULL values in table in App Development

NULL values in table

qlikuser22 — Fri, 18 Feb 2022 10:58:16 GMT

I have a table which has Address, city , Country and Unique IDs's

Table:
Load
IDs,
Addr,
city,
Country

from abc.qvd;

Sample raw data:

Since I have NULL value , i am getting 2 rows in qliksense table, one with proper address and the other with NULL.

I want to do, if Country is NULL, pick the values which is not null.

I tried the below expression in my load statement and I am not getting the desired result.

if(isnull(country), peek('country', -1), country) as COUNTRY.

I am sure this is a common problem and I am not how to fix this. Please help.

Thanks in advance!

Raja2022 — Fri, 18 Feb 2022 11:29:18 GMT

Give a try with below:

if(Len(country)=0, peek('country', -1), country) as COUNTRY

Hope that helps...

qlikuser22 — Fri, 18 Feb 2022 13:35:09 GMT

I used this link and solved my issue. Thanks to qlik community.