topic Re: Planning Data from Excel in QlikView

Planning Data from Excel

Fri, 08 Nov 2013 09:45:34 GMT

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

Re: Planning Data from Excel

salto — Fri, 08 Nov 2013 09:51:19 GMT

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);

Re: Planning Data from Excel

Fri, 08 Nov 2013 10:00:37 GMT

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

Re: Planning Data from Excel

Fri, 08 Nov 2013 10:03:11 GMT

Great - this works! Many thanks!

Armin