topic Need Help in QlikView

topic Need Help in QlikView https://community.qlik.com/t5/QlikView/Need-Help/m-p/1658776#M448554 <P>Hello Team,</P><P>Please help me on below scenario. </P><P>we have raw data like below:</P><TABLE><TBODY><TR><TD>ID</TD><TD>NAME</TD><TD>D</TD><TD>STATUS</TD></TR><TR><TD>1216</TD><TD>GIREESH</TD><TD>D1</TD><TD>PASS</TD></TR><TR><TD>1216</TD><TD>GIREESH</TD><TD>D2</TD><TD> </TD></TR><TR><TD>1216</TD><TD>GIREESH</TD><TD>D3</TD><TD> </TD></TR><TR><TD>1216</TD><TD>GIREESH</TD><TD>D4</TD><TD> </TD></TR><TR><TD>1217</TD><TD>NARESH</TD><TD> </TD><TD>FAIL</TD></TR><TR><TD>1217</TD><TD>NARESH</TD><TD>D5</TD><TD> </TD></TR><TR><TD>1217</TD><TD>NARESH</TD><TD>D6</TD><TD> </TD></TR><TR><TD>1217</TD><TD>NARESH</TD><TD>D7</TD><TD> </TD></TR></TBODY></TABLE><P> </P><P>Result: Need STATUS as New Status column if ID and NAME is same.</P><TABLE><TBODY><TR><TD>ID</TD><TD>NAME</TD><TD>D</TD><TD>STATUS</TD><TD><FONT face="arial black,avant garde"><STRONG>New Status</STRONG></FONT></TD></TR><TR><TD>1216</TD><TD>GIREESH</TD><TD>D1</TD><TD>PASS</TD><TD>PASS</TD></TR><TR><TD>1216</TD><TD>GIREESH</TD><TD>D2</TD><TD> </TD><TD>PASS</TD></TR><TR><TD>1216</TD><TD>GIREESH</TD><TD>D3</TD><TD> </TD><TD>PASS</TD></TR><TR><TD>1216</TD><TD>GIREESH</TD><TD>D4</TD><TD> </TD><TD>PASS</TD></TR><TR><TD>1217</TD><TD>NARESH</TD><TD> </TD><TD>FAIL</TD><TD>FAIL</TD></TR><TR><TD>1217</TD><TD>NARESH</TD><TD>D5</TD><TD> </TD><TD>FAIL</TD></TR><TR><TD>1217</TD><TD>NARESH</TD><TD>D6</TD><TD> </TD><TD>FAIL</TD></TR><TR><TD>1217</TD><TD>NARESH</TD><TD>D7</TD><TD> </TD><TD>FAIL</TD></TR></TBODY></TABLE> Wed, 18 Dec 2019 03:42:10 GMT gireesh1216 2019-12-18T03:42:10Z Need Help https://community.qlik.com/t5/QlikView/Need-Help/m-p/1658776#M448554 <P>Hello Team,</P><P>Please help me on below scenario. </P><P>we have raw data like below:</P><TABLE><TBODY><TR><TD>ID</TD><TD>NAME</TD><TD>D</TD><TD>STATUS</TD></TR><TR><TD>1216</TD><TD>GIREESH</TD><TD>D1</TD><TD>PASS</TD></TR><TR><TD>1216</TD><TD>GIREESH</TD><TD>D2</TD><TD> </TD></TR><TR><TD>1216</TD><TD>GIREESH</TD><TD>D3</TD><TD> </TD></TR><TR><TD>1216</TD><TD>GIREESH</TD><TD>D4</TD><TD> </TD></TR><TR><TD>1217</TD><TD>NARESH</TD><TD> </TD><TD>FAIL</TD></TR><TR><TD>1217</TD><TD>NARESH</TD><TD>D5</TD><TD> </TD></TR><TR><TD>1217</TD><TD>NARESH</TD><TD>D6</TD><TD> </TD></TR><TR><TD>1217</TD><TD>NARESH</TD><TD>D7</TD><TD> </TD></TR></TBODY></TABLE><P> </P><P>Result: Need STATUS as New Status column if ID and NAME is same.</P><TABLE><TBODY><TR><TD>ID</TD><TD>NAME</TD><TD>D</TD><TD>STATUS</TD><TD><FONT face="arial black,avant garde"><STRONG>New Status</STRONG></FONT></TD></TR><TR><TD>1216</TD><TD>GIREESH</TD><TD>D1</TD><TD>PASS</TD><TD>PASS</TD></TR><TR><TD>1216</TD><TD>GIREESH</TD><TD>D2</TD><TD> </TD><TD>PASS</TD></TR><TR><TD>1216</TD><TD>GIREESH</TD><TD>D3</TD><TD> </TD><TD>PASS</TD></TR><TR><TD>1216</TD><TD>GIREESH</TD><TD>D4</TD><TD> </TD><TD>PASS</TD></TR><TR><TD>1217</TD><TD>NARESH</TD><TD> </TD><TD>FAIL</TD><TD>FAIL</TD></TR><TR><TD>1217</TD><TD>NARESH</TD><TD>D5</TD><TD> </TD><TD>FAIL</TD></TR><TR><TD>1217</TD><TD>NARESH</TD><TD>D6</TD><TD> </TD><TD>FAIL</TD></TR><TR><TD>1217</TD><TD>NARESH</TD><TD>D7</TD><TD> </TD><TD>FAIL</TD></TR></TBODY></TABLE> Wed, 18 Dec 2019 03:42:10 GMT https://community.qlik.com/t5/QlikView/Need-Help/m-p/1658776#M448554 gireesh1216 2019-12-18T03:42:10Z Re: Need Help https://community.qlik.com/t5/QlikView/Need-Help/m-p/1658781#M448555 <P>Don't create Dump</P><P><STRONG>If(ID&NAME=Previous(ID&NAME), peek('New_Status'), STATUS) as New_Status</STRONG></P> Wed, 18 Dec 2019 04:43:32 GMT https://community.qlik.com/t5/QlikView/Need-Help/m-p/1658781#M448555 Anil_Babu_Samineni 2019-12-18T04:43:32Z