topic Excel extract data scenario in QlikView

Excel extract data scenario

nareshthavidishetty — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I believe the attached spreadsheet will give more explanation than me.

Please find the attached spreadsheet.LET ME KNOW IF REQUIRED ANY INFORMATION.

Thanks..

Chanty4u — Tue, 12 Jun 2018 11:38:12 GMT

try this

LOAD id,

sales

FROM

(ooxml, embedded labels, table is Sheet1);

Data:

LOAD *,

If(sales, sales, Peek(Value1)) as Value1

Resident a Order By id Asc;

Drop table a;

Chanty4u — Tue, 12 Jun 2018 11:39:27 GMT

nareshthavidishetty — Tue, 12 Jun 2018 11:48:37 GMT

Excellent

Can you explain what value1 will do.

Thanks..

Chanty4u — Tue, 12 Jun 2018 11:52:41 GMT

here clearly explained the Peek function go through it

Please close the thread if you got the ansswer