Discussion board where members can get started with QlikView.
I'm having a problem with a data set that I need to combine in different ways in QV.
The problem is the data sources, I do not understand how I can make charts/pivots of this information.
The data is year-based and looks like this:
How do I turn this "back" into something like this (or do I even need to?):
Go to Solution.
See the attached sample file try to load data some thing like this.
By below code
(ooxml, embedded labels, table is Sheet1);
Let me know about this
try using CrossTable...I tried with this snippet....
YrsData:Load * Inline [country, 2001, 2002, 2003A, 1, 2, 3B, 2,3,4C,3,4,5];
CrossTable(Years, Sales) Load * Resident YrsData;
Thanks a million for pointing me in the right direction, I still dont understand how it works but seems QV has a CroosTable -wizzard built in that does the magic for you