USING PREVIOUS - Qlik Community

shravanveer · ‎2022-05-17

HI,

I WANT EMPTY DATE FIELD TO BE FILLED WITH PREVIOUS DATES

ID	DATE
100	12-06-2022
101	13-06-2022
102
103	15-06-2022
104
105	18-06-2022
106	19-06-2022

vchuprina · ‎2022-05-17

Hi,

You can do it in the script:

IF(IsNull(DATE), Previous(DATE), DATE) AS DATE

Please note that you should order your data by ID

Regards,

Vitalii

Press LIKE if the given solution helps to solve the problem.
If it's possible please mark correct answers as "solutions" (you can mark up to 3 "solutions").

shravanveer · ‎2022-06-10

hi,

thank you

as you said IF(IsNull(DATE), Previous(DATE), DATE) AS DATE it has been worked ,and i need same script for more empty fileds on the same table like shown table

ID	DATE
100	12-06-2022
101	13-06-2022
102
103	15-06-2022
104
105
106	19-06-2022