I know about Cross tables, but the file I have a little complex and could appreciate your help.
Here is a snapshop from Excel
In the first column we have countries/regions. after that every column is a year and a month. so 2006M04 - is April 2005. This goes from 2006 till present day.
The object in Qlikview is to make line graphs on this.
The problem i face with using Crosstable for this is that I can really put all of the 2006M04... into years or month as they include both. Ideally i would like to have both month and year to play around with later.
Would anyone know a solution for this? Could the first row be named in a better way to generate month and year perhaps!