topic Formula in Loading in QlikView https://community.qlik.com/t5/QlikView/Formula-in-Loading/m-p/156094#M32093 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>During load you can use order by Num Ascending. Then Create another field using the following function:</P><P>Previous(Num) as Num2.</P><P>If there are repeating values for Num, then use</P><P>if(Num=previous(Num),Num2,previous(Num)) as Num2.</P><P></P><P>Regards,</P><P>Syed.</P></BODY></HTML> Sat, 23 Oct 2010 16:13:41 GMT syed_muzammil 2010-10-23T16:13:41Z Formula in Loading https://community.qlik.com/t5/QlikView/Formula-in-Loading/m-p/156093#M32092 <HTML><HEAD></HEAD><BODY><P>Dear all,</P><P>I have a QVD file with the following data:</P><P>Num:</P><P>13890101</P><P>13890201</P><P>13890231</P><P>13881229</P><P>How can I have Num and the greatest Num which is smaller than current num in load Time?</P><P>Output is like this:</P><P>Num,Num2</P><P>13890101, 13881229</P><P>13890201,13890101</P><P>13890231,13890201</P><P>13881229,13881229</P><P>Thats really kind of you if you help me.</P></BODY></HTML> Sat, 23 Oct 2010 16:04:17 GMT https://community.qlik.com/t5/QlikView/Formula-in-Loading/m-p/156093#M32092 2010-10-23T16:04:17Z Formula in Loading https://community.qlik.com/t5/QlikView/Formula-in-Loading/m-p/156094#M32093 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>During load you can use order by Num Ascending. Then Create another field using the following function:</P><P>Previous(Num) as Num2.</P><P>If there are repeating values for Num, then use</P><P>if(Num=previous(Num),Num2,previous(Num)) as Num2.</P><P></P><P>Regards,</P><P>Syed.</P></BODY></HTML> Sat, 23 Oct 2010 16:13:41 GMT https://community.qlik.com/t5/QlikView/Formula-in-Loading/m-p/156094#M32093 syed_muzammil 2010-10-23T16:13:41Z