topic Re: Problem loading excelfiles data correct in QlikView

Problem loading excelfiles data correct

Fri, 20 Dec 2013 12:04:04 GMT

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?

Re: Problem loading excelfiles data correct

VishalWaghole — Fri, 20 Dec 2013 12:07:45 GMT

Hi Bjorn,

You can achive your task by using CrossTable Concept.

- Regards,

Vishal Waghole

Re: Problem loading excelfiles data correct

Anonymous — Fri, 20 Dec 2013 12:10:29 GMT

Bjorn

You will probably need to do 2 passes

Load the other required in a second table
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

Re: Problem loading excelfiles data correct

Fri, 20 Dec 2013 17:40:51 GMT

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