I wonder if anybody could tell me if there is any way to solve the following problem. I have an SQL which looks like :
select Country, Month, Column1, Column2, ColumnN
I would like the result of this SQL to be "transformed" to fill a QlikView table which has the following format :
For example if the SQL produced the following result :
Germany, Jan2014, 10, 20, 30
this would be placed in the QlikView table as :
I would be very gratefully for any ideas / suggestions.