Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
Highlighted
sarasmonu
Contributor

Get last available value if NULL

Hi Team,

I have list of dates with corresponding information(value) in a table in Qliksense.

If the value is NULL i want to list the last available value in my table

example: Input

Date               Value

1/2/2018          2

2/2/2018          -

3/3/2018          -

4/8/2018          10

10/8/2018         -

12/8/2018          -


Output:

Date               Value

1/2/2018          2

2/2/2018          2

3/3/2018          2

4/8/2018          10

10/8/2018         10

12/8/2018          10

Thanks,

Monu

1 Reply
Highlighted
vamsee
Valued Contributor

Re: Get last available value if NULL

Try

LOAD
Date,
IF(Len(Trim(Value))<1,Peek(Value), Value) as Value;