How to create this kind of information

[rcandeo]

Hi, is there a way to create a dinamic table like this? Attached the excel file with all the information that I need.

[Mark_Little]

Hi,

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.

Mark

[mvanlutterveld]

Hi,

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. 

[gsbeaton]

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

[thomaslg_wq]

Hi,

1 : You must create one "out of the data model dimension":

LOAD * INLINE [

    Dimension

    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,

Thomas,