Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

How do I manually select data to construct my visualisations?

So I've just dabbled into Qlikview Sense and I want to incoporate some football match analysis into a visual form.

Since the amount of data I have is not excessive, it would make sense to include them all in one sheet.

Fields issue.jpg

I want to separate each group into their own fields. E.g. Shots, Possession, Possession in thirds, Short passing, etc.

Also, I've tried making a new sheet in Excel for every variable, but Qlikview Sense groups up my Match variables (match 1, 2, etc.).

Is there a way around this? Thanks!

1 Reply
Not applicable

Re: How do I manually select data to construct my visualisations?


In this case, you should save each group into a separate CSV or XLS file.

Qliksense links the tables by a common key, so you have to change your data schema in order to make it happen.

I suggest you to create a key called MatchId as the following example, and to use the same idea for each group:

short passing.png

By doing so you will have a data model such as:


And will be able to create tables, pivot tables, etc.

I also recommend this tutorial Qlik Sense Desktop - Comprehensive Quick Build Tutorial to get started.

I hope it helps,


Community Browser