Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
bharatkishore
Creator III
Creator III

Join or Concatenate or Mapping

Hi All,

@sunny_talwar

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

3 Replies
albert_guito
Creator II
Creator II

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

 

Ag+
bharatkishore
Creator III
Creator III
Author

Thank you for your reply. Can you please suggest the approach what can i follow..
dplr-rn
Partner - Master III
Partner - Master III

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