topic How to handle this? in QlikView https://community.qlik.com/t5/QlikView/How-to-handle-this/m-p/207106#M62980 <HTML><HEAD></HEAD><BODY><P>How is the data build up?? Might have to do with this ...</P><P></P><P>Seems that ID 1 with status is not correctly connected to the time in your case ...</P></BODY></HTML> Tue, 29 Jun 2010 15:14:35 GMT Anonymous 2010-06-29T15:14:35Z How to handle this? https://community.qlik.com/t5/QlikView/How-to-handle-this/m-p/207105#M62979 <HTML><HEAD></HEAD><BODY><P>Hi</P><P>I am loading an qvd</P><P>It contains</P><P>ID Status Time(hr)</P><P>1 Success -</P><P>2 Fail -</P><P>1 - 2</P><P></P><P></P><P>I want the result like this</P><P>ID Status Time</P><P>1 Success 2</P><P>2 Fail -</P><P></P><P>How to handle?</P><P>Can anyone help me out?</P></BODY></HTML> Tue, 29 Jun 2010 15:10:18 GMT https://community.qlik.com/t5/QlikView/How-to-handle-this/m-p/207105#M62979 2010-06-29T15:10:18Z How to handle this? https://community.qlik.com/t5/QlikView/How-to-handle-this/m-p/207106#M62980 <HTML><HEAD></HEAD><BODY><P>How is the data build up?? Might have to do with this ...</P><P></P><P>Seems that ID 1 with status is not correctly connected to the time in your case ...</P></BODY></HTML> Tue, 29 Jun 2010 15:14:35 GMT https://community.qlik.com/t5/QlikView/How-to-handle-this/m-p/207106#M62980 Anonymous 2010-06-29T15:14:35Z How to handle this? https://community.qlik.com/t5/QlikView/How-to-handle-this/m-p/207107#M62981 <HTML><HEAD></HEAD><BODY><P>Something like this:</P><P></P><BLOCKQUOTE style="overflow-x: scroll;"><PRE style="margin: 0px;"><BR />ResultTable:<BR />Load distinct ID<BR />Resident QvdTable;<BR />Left join (ResultTable)<BR />Load ID, Status<BR />Resident QvdTable;<BR />Left join (ResultTable)<BR />Load ID, Time(hr) as Time<BR />Resident QvdTable;<BR /></PRE></BLOCKQUOTE><BR /><BR /></BODY></HTML> Tue, 29 Jun 2010 15:19:50 GMT https://community.qlik.com/t5/QlikView/How-to-handle-this/m-p/207107#M62981 2010-06-29T15:19:50Z How to handle this? https://community.qlik.com/t5/QlikView/How-to-handle-this/m-p/207108#M62982 <HTML><HEAD></HEAD><BODY><P>Or possibly:</P><P style="padding-left:30px;">LOAD<BR /> ID<BR />,maxstring(Success) as Success<BR />,max("Time(hr)") as Time<BR />FROM MyQVD.qvd (QVD)<BR />GROUP BY ID<BR />;</P></BODY></HTML> Wed, 30 Jun 2010 01:00:27 GMT https://community.qlik.com/t5/QlikView/How-to-handle-this/m-p/207108#M62982 johnw 2010-06-30T01:00:27Z