Excel report in Qlikview

[#1]

Hi

I have a requirement, to import the excel report and show in qlikview.

I have problem importing the first two rows.  I am able to import Number, name and total fields.

But how do I import Target date and Date of delivery.

I have attached the excel file.  Any help would be appreciated.

[nagaiank]

You may try the following script. It worked for me.

LOAD [Target Date],

     [Date of Delivery]

FROM Test.xlsx

(ooxml, embedded labels, table is Sheet1, filters(

Remove(Row, Pos(Top, 8)),

Remove(Row, Pos(Top, 7)),

Remove(Row, Pos(Top, 6)),

Remove(Row, Pos(Top, 5)),

Remove(Row, Pos(Top, 4)),

Remove(Row, Pos(Top, 3))

));

LOAD Number,

     Name,

     Total

FROM Test.xlsx

(ooxml, embedded labels, header is 2 lines, table is Sheet1);

[#3]

Hi Saaty,

As you've already know how to import Number, Name, and Total fields. Similarly, you can Import Target Date, and Date of Delivery.

You just need another load as shown below:

Table1:
LOAD

Number,
Name,
Total
FROM
C:\Test.xlsx
(ooxml, embedded labels, header is 2 lines, table is Sheet1);   

Table2:
LOAD

[Target Date],
[Date of Delivery]

// F3

FROM
C:\Test.xlsx
(ooxml, embedded labels, table is Sheet1, filters(
Remove(Row, RowCnd(Interval, Pos(Top, 3), Pos(Top, 8), Select(3, 0)))))

However before loading,

1. Go to 'Enable Transform Steps' \ 'Conditional Delete...' \ 'Range'

2. From: Top, row3

To: the end of the line in your Excel table, on your example is line 8, so the number is 8,

Select: 3, Skip 0, OK

3. Add

Finish and reload. (I made a few screenshots for you, but the failed to upload them)

[#4]

Thanks for the reply Krishna murthy and Quickview.

Thanks for the input.

Any suggestion how to replicate the excel sheet in qlikview, table box or chart?

[bumin]

Hi what does mean Select(3, 0)?

I have to delete several ranges like

Remove(Row, RowCnd(Compound,

    RowCnd(Interval, Pos(Top, 1), Pos(Top, 7), Select(7, 0)),

    RowCnd(Interval, Pos(Top, 2), Pos(Top, 25), Select(14, 0)),

    RowCnd(Interval, Pos(Top, 30), Pos(Top, 69), Select(50, 0)),

    RowCnd(Interval, Pos(Top, 72), Pos(Top, 83), Select(12, 0))

what do I have to enter in

select and skip?

thanks

Bumin