0 Replies Latest reply: Jan 11, 2016 1:55 AM by Kevin Bouwer RSS

    Joining data from seperate rows

    Kevin Bouwer

      Hi all

       

      I am a novice to Qlikview and using Qlikview for sports analysis

       

      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

       

      I have attached the source file

      I am using the 6. Pitch Count as the Pitch count to identify the 1st, second and 3rd Pitches

      0--1, 1--0 = 1st Pitch

      2--0, 0--1, 1--0 = 2nd Pitch

      3--0, 2--1, 1--2, Strikeout = 3rd Pitch

       

      Thank you