https://community.qlik.com/t5/QlikView/Get-updated-data-using-expression/m-p/1676450#M728440 <P>Something like:</P><P>If(len(B) &gt; 0, B, A) as B,<BR />If(len(Date1) &gt; 0, Date1, Date) as Date,</P> Tue, 18 Feb 2020 05:43:21 GMT jonathandienst 2020-02-18T05:43:21Z https://community.qlik.com/t5/QlikView/Get-updated-data-using-expression/m-p/1676447#M728439 <P>Hello There,</P><P>My concern is how to get the updated data and if no update gets the previews data.</P><P>sample data:</P><TABLE border="1" width="87.11292702660876%"><TBODY><TR><TD width="12.5%">Name</TD><TD width="12.5%" height="24px">A</TD><TD width="25%" height="24px">Date</TD><TD width="25%" height="24px">B</TD><TD width="12.5%" height="24px">Date</TD></TR><TR><TD width="12.5%">MC Sy</TD><TD width="12.5%" height="24px">Collector</TD><TD width="25%" height="24px">08/25/2016</TD><TD width="25%" height="24px">Branch Name</TD><TD width="12.5%" height="24px">10/08/2019</TD></TR><TR><TD width="12.5%">Abiah Teng</TD><TD width="12.5%">Cashier</TD><TD width="25%">02/16/2017</TD><TD width="25%">-</TD><TD width="12.5%">&nbsp;</TD></TR><TR><TD width="12.5%">Ashly Tan</TD><TD width="12.5%" height="24px">Credit Asso.</TD><TD width="25%" height="24px">12/08/2017</TD><TD width="25%" height="24px">Credit Approver</TD><TD width="12.5%" height="24px">08/28/2019</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>I try this expression but the output its not working base on the output I need.</P><P>If(len(A)&gt;,A,If(len(B)&gt;,B))</P><P>The output should be that I need is like below:</P><TABLE border="1" width="50%"><TBODY><TR><TD width="12.5%" height="24px">Name</TD><TD width="12.5%" height="24px">B</TD><TD width="25%" height="24px">Date</TD></TR><TR><TD width="12.5%" height="24px">MC Sy</TD><TD width="12.5%" height="24px">Branch Name</TD><TD width="25%" height="24px">10/08/2019</TD></TR><TR><TD width="12.5%">Abiah Teng</TD><TD width="12.5%">Cashier</TD><TD width="25%">02/16/2017</TD></TR><TR><TD width="12.5%" height="24px">Ashly Tan</TD><TD width="12.5%" height="24px">Credit Approver</TD><TD width="25%" height="24px">08/28/2019</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>Is there any other way for this kind of concern?</P><P>Best Regards,</P><P>Bing</P><P>&nbsp;</P> Sat, 16 Nov 2024 01:15:38 GMT https://community.qlik.com/t5/QlikView/Get-updated-data-using-expression/m-p/1676447#M728439 bsbernabe 2024-11-16T01:15:38Z https://community.qlik.com/t5/QlikView/Get-updated-data-using-expression/m-p/1676450#M728440 <P>Something like:</P><P>If(len(B) &gt; 0, B, A) as B,<BR />If(len(Date1) &gt; 0, Date1, Date) as Date,</P> Tue, 18 Feb 2020 05:43:21 GMT https://community.qlik.com/t5/QlikView/Get-updated-data-using-expression/m-p/1676450#M728440 jonathandienst 2020-02-18T05:43:21Z