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

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
ALERT: QlikView server communication interruptions following Microsoft Windows Domain Controller security updates
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
shravanveer
Contributor II
Contributor II
‎2022-05-17 01:32 AM

USING PREVIOUS

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
Labels (1)
Labels
1,031 Views
0 Likes
2 Replies
vchuprina
Specialist
Specialist
‎2022-05-17 03:12 AM

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").
996 Views
shravanveer
Contributor II
Contributor II
‎2022-06-10 03:03 AM
Author

In response to vchuprina

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
804 Views
0 Likes