Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Load from an Crosstable formatted Excel

Hello everyone,

i need to load an excel file that is formatted this way into qlikview:

janfebmaradjustment
Customer1unit price101010
Customer1budget100
Customer1rolling 11050
Customer2unit price202020
Customer2budget200
Customer2rolling250

Is the first time i try to import this kind of data. I need them to be load in a linear way like:

CustomerMonthMetricValue
Customer1JanUnit Price10
Customer1febUnit Price10
Customer1janBudget100

Any idea's on how to achive this result?

Thanks and best regards,

Juan Pedro

1 Solution

Accepted Solutions
Employee
Employee

Re: Load from an Crosstable formatted Excel

Use the Crosstable prefix, and make sure to list the fields in the right order: First the non-months and then the months:

Crosstable (Month, Amount, 3)

Load Customer, AmountType, Adjustment, jan, feb, ... From ...

See also http://community.qlik.com/blogs/qlikviewdesignblog/2014/03/24/crosstable

HIC

2 Replies
Employee
Employee

Re: Load from an Crosstable formatted Excel

Use the Crosstable prefix, and make sure to list the fields in the right order: First the non-months and then the months:

Crosstable (Month, Amount, 3)

Load Customer, AmountType, Adjustment, jan, feb, ... From ...

See also http://community.qlik.com/blogs/qlikviewdesignblog/2014/03/24/crosstable

HIC

Not applicable

Re: Load from an Crosstable formatted Excel

Thank You Henric the "right order" made my day

Best Regards,

Juan Pedro

Community Browser