How to add Cell Value to Qlikview table - Page 2 - Qlik Community

madhubabum · ‎2015-09-16

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

PrashantSangle · ‎2015-09-16

Hi,

Yes you can. Do it while Transformation Table.

Regards

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

PradeepReddy · ‎2015-09-16

Try something like this...

Test:

LOAD @1 as Temp_ClientSite

FROM

community.xlsx

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

Remove(Row, Pos(Top, 1)),

Remove(Row, Pos(Top, 1))

));

Final_Table:

LOAD [Output Count],

PC,

[Opportunity Type],

[Opportunity ID],

Role,

PEEK('Temp_ClientSite',0,'Test') as Client_Site

FROM

community.xlsx

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

Remove(Row, RowCnd(CellValue, 3, StrCnd(null)))

));