How to add Cell Value to Qlikview table

[madhubabum]

Hi all

How to add  cell A5 (Client Site) from given excel to the QV table which is marked as yellow shade,Here the  loaded QV table should have Client Site  with the value specified in cell A5. PFA

Best Regards

Madhu

[Anonymous]

goto sctript Editor and chhose your Excel file via table files

then you get the structure of your file

youneed to define Header size 5 lines to skip the first 5 lines and you Need to define embedded labels

in a next tab you can define a where clause "where Output Count < 13)

finish and you should have the rows in yellow

[qlikmsg4u]

Try this

LOAD [Output Count],

     PC,

     [Opportunity Type],

     [Opportunity ID],

     Role,

     F6,

     G,

     H

FROM

community.xlsx

(ooxml, embedded labels, header is 5 lines, table is Sheet1) where [Output Count] <13;

[madhubabum]

Hi Rudolf Linder

No , I want to fill Cell A5 Value into the (F Column from F7 onwords) Field name Like "Client Site"(in Cell F6)

[madhubabum]

HI K N

No , I want to fill Cell A5 Value into the (F Column from F7 onwords) Field name Like "Client Site"(in Cell F6)

Thanks

Madhu

[teiswamsler]

hi Madhu

look at script in qvw - this script can be use if Excel format is the same every time with the school at A4

/Teis

[PrashantSangle]

Hi,

Try below script,

Test:
LOAD [Output Count],
     PC,
     [Opportunity Type],
     [Opportunity ID],
     Role,
     F6
     
FROM
community.xlsx
(ooxml, embedded labels, header is 5 lines, table is Sheet1);

Join
LOAD @1 as Client_Site
FROM
community.xlsx
(ooxml, no labels, header is 4 lines, table is Sheet1, filters(
Remove(Col, Pos(Top, 8)),
Remove(Col, Pos(Top, 7)),
Remove(Col, Pos(Top, 6)),
Remove(Col, Pos(Top, 5)),
Remove(Col, Pos(Top, 4)),
Remove(Col, Pos(Top, 3)),
Remove(Col, Pos(Top, 2)),
Remove(Row, RowCnd(Interval, Pos(Top, 2), Pos(Bottom, 1), Select(1, 0)))
));

Regards

[madhubabum]

HI Max Dreamer ,

it is working great

Thanks for your reply

Madhu

[madhubabum]

Hi Max Dreamer

How can i delete the unwanted row values from 13 onwords

[qlikmsg4u]

Use where condition

where [Output Count] <13