topic Re: Data loading in QlikView

topic Re: Data loading in QlikView https://community.qlik.com/t5/QlikView/Data-loading/m-p/1604708#M735797 <P>PFA</P> Mon, 22 Jul 2019 15:11:21 GMT Anil_Babu_Samineni 2019-07-22T15:11:21Z Data loading https://community.qlik.com/t5/QlikView/Data-loading/m-p/1604302#M735795 <P>Hello Guys,</P><P>I have two fields (Date_of_Approval) and CHANGENR.</P><P>I want to load CHANGENR asc then everyday of first record in my application please check the below example and required output.</P><P>Data:</P><TABLE><TBODY><TR><TD>Date_of_Approval</TD><TD>[PR No]</TD><TD>CHANGENR</TD></TR><TR><TD>4/30/2019</TD><TD>1101040481</TD><TD>0043087912</TD></TR><TR><TD>5/9/2019</TD><TD>1101040502</TD><TD>0043088215</TD></TR><TR><TD>5/29/2019</TD><TD>1101040514</TD><TD>0043097780</TD></TR><TR><TD>5/29/2019</TD><TD>1101040514</TD><TD>0043097789</TD></TR><TR><TD>6/12/2019</TD><TD>1101040521</TD><TD>0043101344</TD></TR><TR><TD>6/20/2019</TD><TD>1101040530</TD><TD>0043101731</TD></TR><TR><TD>6/20/2019</TD><TD>1101040530</TD><TD>0043101740</TD></TR><TR><TD>7/17/2019</TD><TD>1101040511</TD><TD>0043104002</TD></TR><TR><TD>7/17/2019</TD><TD>1101040516</TD><TD>0043104004</TD></TR><TR><TD>7/17/2019</TD><TD>1104003905</TD><TD>0043104005</TD></TR><TR><TD>7/18/2019</TD><TD>1101040541</TD><TD>0043104403</TD></TR></TBODY></TABLE><P> </P><P> </P><P>Required Output:</P><TABLE><TBODY><TR><TD>Date_of_Approval</TD><TD>[PR No]</TD><TD>CHANGENR</TD></TR><TR><TD>4/30/2019</TD><TD>1101040481</TD><TD>0043087912</TD></TR><TR><TD>5/9/2019</TD><TD>1101040502</TD><TD>0043088215</TD></TR><TR><TD>5/29/2019</TD><TD>1101040514</TD><TD>0043097780</TD></TR><TR><TD>6/12/2019</TD><TD>1101040521</TD><TD>0043101344</TD></TR><TR><TD>6/20/2019</TD><TD>1101040530</TD><TD>0043101731</TD></TR><TR><TD>7/17/2019</TD><TD>1101040511</TD><TD>0043104002</TD></TR><TR><TD>7/18/2019</TD><TD>1101040541</TD><TD>0043104403</TD></TR></TBODY></TABLE><P> </P><P>Please help me the above issue.</P><P> </P><P>Thank you</P> Sat, 16 Nov 2024 02:57:27 GMT https://community.qlik.com/t5/QlikView/Data-loading/m-p/1604302#M735795 potti222 2024-11-16T02:57:27Z Re: Data loading https://community.qlik.com/t5/QlikView/Data-loading/m-p/1604666#M735796 <P><a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/19387">@potti222</a> Are you using QlikView or Sense? I would like to move this into the correct product forum. </P> Mon, 22 Jul 2019 13:45:54 GMT https://community.qlik.com/t5/QlikView/Data-loading/m-p/1604666#M735796 Sue_Macaluso 2019-07-22T13:45:54Z Re: Data loading https://community.qlik.com/t5/QlikView/Data-loading/m-p/1604708#M735797 <P>PFA</P> Mon, 22 Jul 2019 15:11:21 GMT https://community.qlik.com/t5/QlikView/Data-loading/m-p/1604708#M735797 Anil_Babu_Samineni 2019-07-22T15:11:21Z