Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
Not applicable

Transforming data on an excel spreadsheet to load into Qlikview

I am having issues formatting invoices to load into Qlikview. The invoices are in an excel format and manually changing the format of the excel spreadsheet is not an option.

The top 11 rows of each invoice are not needed and I know how to remove them. Row 12 contains my headers. On this invoice there are 3 separate containers labeled shipment 1,2,3 in column A. I inserted this column so please disregard when providing a solution.

For each shipment I need to associate DC, PO, Item and CBM to Date, Container and Vessel/Voyage. I have tried everything I know please help. I have attached an example invoice.

Thanks

4 Replies
Not applicable

Transforming data on an excel spreadsheet to load into Qlikview

Hi Cory,

please see the attached explanations.

Hope it´s what you are looking for.

Good luck!

Rainer

Not applicable

Transforming data on an excel spreadsheet to load into Qlikview

Rainer,

Thanks for the explination. I am still having issues. When i follow your steps and reload the document It only shows the 1st container number and not the other 3. My Qvw file is attached so you can see what I am doing.

Not applicable

Transforming data on an excel spreadsheet to load into Qlikview

Hi,

the only difference I see at the moment are:

(biff, header is 8 lines, embedded labels, table is Summary$, filters(

//(biff, embedded labels, header is 8 lines, table is Summary$, filters(

my statement contains "embedded labels" and yours not.

Second I deleted the first column directly in the excel file (column A) .

Try to work it out using the files I send in the ZIP.

Rainer

MVP & Luminary
MVP & Luminary

AW:Re: Transforming data on an excel spreadsheet to load into Qlikview

Your qvw work fine (on MSO 2007 and QV 10 SR1, maybe you have selected this container?

- Ralf