topic How to handle data with sub listings within a row level data ? in QlikView

How to handle data with sub listings within a row level data ?

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

Hi All ,

How to handle data with sub listings within a row level data ? Please find attached sample data .

Example Pedros is a client which actually is group of three separate entity of even client .

Thanks & Regards

Shekar

shekhar_analyti — Fri, 29 Dec 2017 10:13:26 GMT

Basically i want to ignore records like Pedros , not its sub group during load ....

prma7799 — Fri, 29 Dec 2017 10:18:21 GMT

Like this???

Test:

LOAD Shipping_Client,

Nautical_Miles,

Max_Stops,

Staked

FROM

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

Remove(Row, Pos(Top, 15)),

Remove(Row, Pos(Top, 13)),

Remove(Row, Pos(Top, 10)),

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

Remove(Row, Pos(Top, 3))

));