Without a lot of playing I am not sure if you can achieve exactly what you are showing in the excel document. But I think you probably could get close if you set up a hierarchy in say in excel bring this into your script. You should then be able to pivot by the hierarchy levels. Example below...
Parent Child Product Line Books Product Line Electronics Product Line Movies & G..
Hope this will give you somewhere to start.
As your table is very wide I would create 4 straight tables and place them in a container. As dimension create a cycle with Day, Week and Month.
if you don't use a dimensions create 4 straight tables, hide the dimension column of the all except the first tables and place the tables exactly next to each other. As a drawback. this will force QlikView to show a scrollbar which is not user friendly.
Okay, usability issues aside, it would be possible to create a table in QlikView which replicated your excel almost identically. You would need to do a bit of transformation of your data to get it into a structure a bit like this:
Day Group SubGroup Sales 01/05/2008 Sales By Product Line Books 51640 01/05/2008 Sales By Product Line Electronics 17350 01/05/2008 Sales By Region North America 84789
You can then use a pivot table to display your data in exactly the way it is displayed in your Excel doc. You can use the background colour property of the dimension to colour the headings as you want.
Hope that helps
1 : You must create one "out of the data model dimension":
LOAD * INLINE [
Sales by product
Sales by region
2 : You create a pivot table with 3 dimensions:
1 : Day,
2 : Dimension,
3: =if(Dimension='Sales by product',Product,Region)
(where product and region are your dimension with books or europe)
3 : as usual ...your expression is sum(#Sales)
I think this is what you need,