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