Problem loading excelfiles data correct

[#1]

Hey, I am having some trouble loading this Excelfile in a good manner into Qlikview, the problem is I would like to have CategoryName as a table soo that i can link the data to whatever category they exists in. How could this be solved?

[VishalWaghole]

Hi Bjorn,

You can achive your task by using CrossTable Concept.

- Regards,

Vishal Waghole

[Anonymous]

Bjorn

You will probably need to do 2 passes

1. Load the other required in a second table
2. Load the Category Dimension into a second  table

But you will need to have a suitable field of name in both tables for them to link.

The 2nd pass could either be from the xls, or from the the first resident table.

Best regards,     Bill

[#4]

Hi Bjon,

Please find the below script,

CrossTable(Catogrey, Data, 2)

LOAD Year,

     DivisionName,

     [Baby Clothes],

     [Children's Clothes],

     [Men's Clothes],

     [Men's Footwear],

     Sportswear,

     Swimwear,

     [Women's Clothes],

     [Women's Footwear]

FROM

<Your Path Name > \SummaryReport.xls]     /*table is $(vSheet));*/

(biff, embedded labels, table is [2010$]);