QlikView App Dev

[#1]

Hello All,

I am new to QlikView and have an issue...

I need to force join the "Year" and "Period" from the FPPS table with the Load Incline table I created 'New YPQ Table'

FPPS:

LOAD Year,

     Period,

     [FPPS customer],

     Material,

     [FPPS Material desc],

     [FPPS line item],

     data

FROM

[Qlikview_FPPS Ger mkt_v2.xlsx]

(ooxml, embedded labels, table is [Qlikview_FPPS Ger mkt 2010]);

New_YPQ_Table:

LOAD F1,

     [Metrics],

     Year,

     Period,

     Quarter

FROM

[..\..\..\Book1.xlsx]

(ooxml, embedded labels, table is Sheet1);

Any help would be appreciated!!!!

[#2 · Accepted solution]

Make a custom Key to join it, for example

FPPS:

LOAD [Year] & '_' & [Period] as KeyYP,

     Year as [Year FPPS],

     Period as [Period FPPS],

     [FPPS customer],

     Material,

     [FPPS Material desc],

     [FPPS line item],

     data

FROM

[Qlikview_FPPS Ger mkt_v2.xlsx]

(ooxml, embedded labels, table is [Qlikview_FPPS Ger mkt 2010]);

New_YPQ_Table:

LOAD [Year] & '_' & [Period] as KeyYP,

     F1,

     [Metrics],

     Year as [Year YPQ],

     Period as [Period YPQ],

     Quarter

FROM

[..\..\..\Book1.xlsx]

(ooxml, embedded labels, table is Sheet1);

Hope it helps.

[#3]

Thank you very much Juan for your help, its much appreciated and fixed my issue