Planning Data from Excel

[#1]

Dear all,

we have a Planning Sheet in Excel with following format:

                    Jan     Feb     Mar     Apr     May     Jun    

Produkt A     10     12          14       14       13       15    

Produkt B     4        3              3        3          5       6

Do someone has an idee how to implement this (the excel sheet has more than 4000 lines) in Qlikview?

Best regards,

Armin

[salto · Accepted solution]

You can read it as a crosstable:

CrossTable(Jan, Data)

LOAD F1,

     Jan,

     Feb,

     Mar,

     Apr,

     May,

     Jun

FROM

D:\Planning.xlsx

(ooxml, embedded labels, table is Sheet1);

[#3]

As Salto points out you can use the crosstable wizard. It's part of the Table files wizard in the script editor. Click next and select "Enable transformation step" then the crosstable button on the top right. Your Produkt field should be a "qualifier field", Type somthing like PlanningMonth as "attribute field" and maybe Amount/Quantity or what ever is suitable for the numeric values as "Data Field".

Good Luck

[#4]

Great - this works! Many thanks!

Armin