Discussion board where members can get started with QlikView.
I have the following excel table:
I can now load the date using the following script to pivot the age group columns (omitting the average age)
Crosstable (Age, Proportion, 2)
The table I would like to load would looks like this, where the average age fills in all of the relevent cells for the country \ region:
Go to Solution.
Why not just do this?
Crosstable (Age, Proportion, 3)
The columns don't need to be loaded in the same order that they are in the Excel file...
Spot on, many thanks!