topic Re: Join or Concatenate or Mapping in QlikView

Join or Concatenate or Mapping

bharatkishore — Tue, 04 Dec 2018 16:28:56 GMT

Hi All,

I have two tables like below

Table1:
LOAD date(Posting_Month, 'MM-YYYY') as Period,
left(Plant,2) as Country,
Plant,
Modality,
Part_Type as [Part Type],
System_Code as [System Code],
NormConsumption as Consumption

From
[..\Master.qvd]
(qvd) where Match(Contract_Type_Group,'Contract Covered','Warranty') and Posting_Month >= Date#('01-2017' , 'MM-YYYY');

Table2:

LOAD date(Period_Start_Date, 'MM-YYYY') as Period,
left(Plant,2) as Country,
Plant,
System_Code as [System Code],
Part_Type as [Part Type],
Entitlement_Count as [Install Base]

FROM
[..\Table.qvd]
(qvd) where Match(Contract_Type_Group,'Contract Covered','Warranty');

Now when i use concatenate i am getting current value for Install Base but when i select any modality data i am getting as 0. But when i do a left join or mapping the value is changing.

Can you please tell me what to use and how to solve it.

Thanks,

Bharat

Re: Join or Concatenate or Mapping

albert_guito — Tue, 04 Dec 2018 16:42:48 GMT

When contatenate this 2 tables the 1st table has no values for [Install Base] and the 2nd table has no values for Modality.

This is the reason for getting 0 Install base when select a modality

Albert

Re: Join or Concatenate or Mapping

bharatkishore — Tue, 04 Dec 2018 16:46:35 GMT

Thank you for your reply. Can you please suggest the approach what can i follow..

Re: Join or Concatenate or Mapping

dplr-rn — Tue, 04 Dec 2018 16:49:09 GMT

That is kind of the down side of concatenated fact tables. Solution in this case is generic keys
see below links
Quick question though; did you consider link table between the 2 fact tables. this is more maintainable and quicker to achieve but with downside of performance issues with huge data sets

https://community.qlik.com/t5/Qlik-Design-Blog/Fact-Table-with-Mixed-Granularity/ba-p/1468238
https://community.qlik.com/t5/QlikView-Documents/Generic-keys/ta-p/1496560