topic Re: Records in QlikView

Records

Tue, 08 Sep 2015 15:51:21 GMT

Hi,

I have an excel shhet with two fields like S.NO(1-30 ) and NAME(A-Z and AA,AB,AC,AD) are the field values.

Now my requirement is like, whenever i loaded this excel into qlikview i don't want the records from 25 to 30.rest of the records will disply.

Please help in this.

Thanks&Regards,

CHIRUMAMILLA

Anonymous — Tue, 08 Sep 2015 16:01:01 GMT

Do you not want them loaded at all?

If that's the case you can just use a where clause at the end of your load statement, after the spreadsheet name.

In this case it would be

Where S.NO < 25;

settu_periasamy — Tue, 08 Sep 2015 16:13:18 GMT

Hi,

Try this (if you want only to delete 26 to 30 rows)

LOAD S.No,

Name

FROM

[..\Yourfile.xlsx]

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

Remove(Row, RowCnd(Interval, Pos(Top, 27), Pos(Top, 30), Select(1, 0)))

));