topic Joining data from seperate rows in QlikView https://community.qlik.com/t5/QlikView/Joining-data-from-seperate-rows/m-p/1060784#M643552 <HTML><HEAD></HEAD><BODY><P>Hi all</P><P></P><P>I am a novice to Qlikview and using Qlikview for sports analysis</P><P></P><P>For this question I am looking to create a straight table showing the Top 3 Pitch Type sequences for the 1st 3 pitches in Baseball</P><P></P><P>I have attached the source file</P><P>I am using the 6. Pitch Count as the Pitch count to identify the 1st, second and 3rd Pitches</P><P>0--1, 1--0 = 1st Pitch</P><P>2--0, 0--1, 1--0 = 2nd Pitch</P><P>3--0, 2--1, 1--2, Strikeout = 3rd Pitch</P><P></P><P>Thank you</P></BODY></HTML> Mon, 11 Jan 2016 06:55:16 GMT 2016-01-11T06:55:16Z Joining data from seperate rows https://community.qlik.com/t5/QlikView/Joining-data-from-seperate-rows/m-p/1060784#M643552 <HTML><HEAD></HEAD><BODY><P>Hi all</P><P></P><P>I am a novice to Qlikview and using Qlikview for sports analysis</P><P></P><P>For this question I am looking to create a straight table showing the Top 3 Pitch Type sequences for the 1st 3 pitches in Baseball</P><P></P><P>I have attached the source file</P><P>I am using the 6. Pitch Count as the Pitch count to identify the 1st, second and 3rd Pitches</P><P>0--1, 1--0 = 1st Pitch</P><P>2--0, 0--1, 1--0 = 2nd Pitch</P><P>3--0, 2--1, 1--2, Strikeout = 3rd Pitch</P><P></P><P>Thank you</P></BODY></HTML> Mon, 11 Jan 2016 06:55:16 GMT https://community.qlik.com/t5/QlikView/Joining-data-from-seperate-rows/m-p/1060784#M643552 2016-01-11T06:55:16Z