App Development

[qlikuser22]

HI

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]

Give a try with below:

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

Hope that helps...

[qlikuser22 · Accepted solution]

Hi

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

Solved: Fill column value with previous not null value - Qlik Community - 1524005