Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Joining data from seperate rows

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

Community Browser