Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Skip the ticket, Chat with Qlik Support instead for instant assistance.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Help Needed with joining fields in one table with another

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!!!!

1 Solution

Accepted Solutions
Not applicable
Author

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.

View solution in original post

2 Replies
Not applicable
Author

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.

Not applicable
Author

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