topic Re: USING PREVIOUS in QlikView https://community.qlik.com/t5/QlikView/USING-PREVIOUS/m-p/1931458#M1227432 <P>Hi,&nbsp;</P> <P>You can do it in the script:</P> <P>IF(IsNull(DATE), Previous(DATE), DATE) AS DATE</P> <P>Please note that you should order your data by ID</P> <P>Regards,</P> <P>Vitalii</P> <P>&nbsp;</P> Tue, 17 May 2022 07:12:55 GMT vchuprina 2022-05-17T07:12:55Z USING PREVIOUS https://community.qlik.com/t5/QlikView/USING-PREVIOUS/m-p/1931398#M1227425 <P>HI,</P> <P>I WANT EMPTY DATE FIELD TO BE FILLED WITH PREVIOUS DATES</P> <P>&nbsp;</P> <TABLE width="138"> <TBODY> <TR> <TD width="64">ID</TD> <TD width="74">DATE</TD> </TR> <TR> <TD>100</TD> <TD>12-06-2022</TD> </TR> <TR> <TD>101</TD> <TD>13-06-2022</TD> </TR> <TR> <TD>102</TD> <TD>&nbsp;</TD> </TR> <TR> <TD>103</TD> <TD>15-06-2022</TD> </TR> <TR> <TD>104</TD> <TD>&nbsp;</TD> </TR> <TR> <TD>105</TD> <TD>18-06-2022</TD> </TR> <TR> <TD>106</TD> <TD>19-06-2022</TD> </TR> </TBODY> </TABLE> Mon, 26 Jan 2026 21:26:37 GMT https://community.qlik.com/t5/QlikView/USING-PREVIOUS/m-p/1931398#M1227425 shravanveer 2026-01-26T21:26:37Z Re: USING PREVIOUS https://community.qlik.com/t5/QlikView/USING-PREVIOUS/m-p/1931458#M1227432 <P>Hi,&nbsp;</P> <P>You can do it in the script:</P> <P>IF(IsNull(DATE), Previous(DATE), DATE) AS DATE</P> <P>Please note that you should order your data by ID</P> <P>Regards,</P> <P>Vitalii</P> <P>&nbsp;</P> Tue, 17 May 2022 07:12:55 GMT https://community.qlik.com/t5/QlikView/USING-PREVIOUS/m-p/1931458#M1227432 vchuprina 2022-05-17T07:12:55Z Re: USING PREVIOUS https://community.qlik.com/t5/QlikView/USING-PREVIOUS/m-p/1941976#M1227434 <P>hi,</P> <P>thank you&nbsp;</P> <P>as you said&nbsp;<SPAN>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&nbsp; like shown table</SPAN></P> <TABLE style="border-collapse: collapse; width: 96pt; box-sizing: border-box; outline: none; border-spacing: 0px; font-variant-ligatures: normal; font-variant-caps: normal; orphans: 2; widows: 2; -webkit-text-stroke-width: 0px; text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial;" border="0" width="128" cellspacing="0" cellpadding="0"> <TBODY> <TR style="height: 15.0pt; box-sizing: border-box; outline: none;"> <TD width="64" height="20" class="xl73" style="height: 15.0pt; width: 48pt; box-sizing: border-box; outline: none; min-width: 40px;"><SPAN>ID</SPAN></TD> <TD width="64" class="xl73" style="border-left: none; width: 48pt; box-sizing: border-box; outline: none; min-width: 40px;">DATE</TD> </TR> <TR style="height: 15.0pt; box-sizing: border-box; outline: none;"> <TD width="64" height="20" align="right" class="xl73" style="height: 15.0pt; border-top: none; width: 48pt; box-sizing: border-box; outline: none; min-width: 40px;">100</TD> <TD width="64" align="right" class="xl74" style="border-top: none; border-left: none; width: 48pt; box-sizing: border-box; outline: none; min-width: 40px;">12-06-2022</TD> </TR> <TR style="height: 15.0pt; box-sizing: border-box; outline: none;"> <TD width="64" height="20" align="right" class="xl73" style="height: 15.0pt; border-top: none; width: 48pt; box-sizing: border-box; outline: none; min-width: 40px;">101</TD> <TD width="64" align="right" class="xl74" style="border-top: none; border-left: none; width: 48pt; box-sizing: border-box; outline: none; min-width: 40px;">13-06-2022</TD> </TR> <TR style="height: 15.0pt; box-sizing: border-box; outline: none;"> <TD width="64" height="20" align="right" class="xl73" style="height: 15.0pt; border-top: none; width: 48pt; box-sizing: border-box; outline: none; min-width: 40px;">102</TD> <TD width="64" class="xl73" style="border-top: none; border-left: none; width: 48pt; box-sizing: border-box; outline: none; min-width: 40px;">&nbsp;</TD> </TR> <TR style="height: 15.0pt; box-sizing: border-box; outline: none;"> <TD width="64" height="20" align="right" class="xl73" style="height: 15.0pt; border-top: none; width: 48pt; box-sizing: border-box; outline: none; min-width: 40px;">103</TD> <TD width="64" align="right" class="xl74" style="border-top: none; border-left: none; width: 48pt; box-sizing: border-box; outline: none; min-width: 40px;">15-06-2022</TD> </TR> <TR style="height: 15.0pt; box-sizing: border-box; outline: none;"> <TD width="64" height="20" align="right" class="xl73" style="height: 15.0pt; border-top: none; width: 48pt; box-sizing: border-box; outline: none; min-width: 40px;">104</TD> <TD width="64" class="xl73" style="border-top: none; border-left: none; width: 48pt; box-sizing: border-box; outline: none; min-width: 40px;">&nbsp;</TD> </TR> <TR style="height: 15.0pt; box-sizing: border-box; outline: none;"> <TD width="64" height="20" align="right" class="xl73" style="height: 15.0pt; border-top: none; width: 48pt; box-sizing: border-box; outline: none; min-width: 40px;">105</TD> <TD width="64" class="xl74" style="border-top: none; border-left: none; width: 48pt;">&nbsp;</TD> </TR> <TR style="height: 15.0pt; box-sizing: border-box; outline: none;"> <TD width="64" height="20" align="right" class="xl73" style="height: 15.0pt; border-top: none; width: 48pt; box-sizing: border-box; outline: none; min-width: 40px;">106</TD> <TD width="64" align="right" class="xl74" style="border-top: none; border-left: none; width: 48pt; box-sizing: border-box; outline: none; min-width: 40px;">19-06-2022</TD> </TR> </TBODY> </TABLE> Fri, 10 Jun 2022 07:03:22 GMT https://community.qlik.com/t5/QlikView/USING-PREVIOUS/m-p/1941976#M1227434 shravanveer 2022-06-10T07:03:22Z