Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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);
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?
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