one great advantage of Qlikview is that you don't need to predefine and load any cubes or(and) cross tables. Just load the data and build the cross tables using new object --> charts --> pivot table --> dimensions are month and color, expression is sum(count).
Just take a look at my example application.
62821.cross table.qvw 150.8 K
Thank you for your response. I think I will find that tecnique useful in the future
However the example I posted above is just to learn the technique of buliding from cross tables because my final and real LOAD will be a long piece of SQL which has many sub headings which I cannot reproduce through a pivot table and I need to restructure my data first in the edit script
My ultimate aim is to produce a scorecard type table with many subheadings.....Hence the need to cross table
If you are able to help me with how I can get to a cross table situation using the example I posted above, any help would be greatly appreciated
to achieve the first table, load it similar to a SQL group by:
LOAD Month, Colour, Sum(Count) AS Count Inline [
Group by Month, Colour
To build crosstables like your second example I would always use the design utilities as mentioned in my post above.
May be any one else has some ideas ?
If you want to create the crosstable fields in your script, you can use GENERIC LOAD prefix for this.
Check out the HELP and Rob's blog which explains how to do this, including some samples: