topic Looping in qlikivew for getting the latest loaded data in QlikView https://community.qlik.com/t5/QlikView/Looping-in-qlikivew-for-getting-the-latest-loaded-data/m-p/650718#M237995 <HTML><HEAD></HEAD><BODY><P>Hi&nbsp; All,</P><P></P><P>I have a requirement, my fact will be loaded every day with the data.</P><P>So I have to take the latest data in the report, for that i have a snapshot dt and one is active flg.</P><P>I need to check for latest snapshot ie. max(snapshot_dt) and check for the active flg=y, this is ok.</P><P>But now if the latest snapshot dt is having the active flg=N, then i hae to check for previous snapshot date and if its active_flg=n</P><P>thne i have to take previous snapshot dt...so on till i get active_flg=y and limit for checking this previous snapshot dt is distinct count of (snapshot _dt).</P><P></P><P>So i have to do this in qlikview while loading the data in qvds.</P><P>I was trying to write the SQL procdure for it but itys a long process.</P><P>Can any one please tell me how&nbsp; can i acheive this in qlikiview??</P></BODY></HTML> Tue, 10 Jun 2014 12:57:19 GMT 2014-06-10T12:57:19Z Looping in qlikivew for getting the latest loaded data https://community.qlik.com/t5/QlikView/Looping-in-qlikivew-for-getting-the-latest-loaded-data/m-p/650718#M237995 <HTML><HEAD></HEAD><BODY><P>Hi&nbsp; All,</P><P></P><P>I have a requirement, my fact will be loaded every day with the data.</P><P>So I have to take the latest data in the report, for that i have a snapshot dt and one is active flg.</P><P>I need to check for latest snapshot ie. max(snapshot_dt) and check for the active flg=y, this is ok.</P><P>But now if the latest snapshot dt is having the active flg=N, then i hae to check for previous snapshot date and if its active_flg=n</P><P>thne i have to take previous snapshot dt...so on till i get active_flg=y and limit for checking this previous snapshot dt is distinct count of (snapshot _dt).</P><P></P><P>So i have to do this in qlikview while loading the data in qvds.</P><P>I was trying to write the SQL procdure for it but itys a long process.</P><P>Can any one please tell me how&nbsp; can i acheive this in qlikiview??</P></BODY></HTML> Tue, 10 Jun 2014 12:57:19 GMT https://community.qlik.com/t5/QlikView/Looping-in-qlikivew-for-getting-the-latest-loaded-data/m-p/650718#M237995 2014-06-10T12:57:19Z