Help needed with Cross tables years and month data.
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!
I have followed you, once you accept it, you will be able to send me private message where I can provide you with my email id.
But I feel that, in order to get best solutions, you need to share your information with everyone and I think Piet Hein van der Stigchel solution is also a good solution. It will all depend on your exact requirement.