Removing synthetic key for calendar dates

[kishorj1982]

Hi All,

I have date field from differnet table on the top of that calendar fileds has been generated but when I am concatenating those fileds into 1 table and dropping those fields I am getting incorrect results

I have attached sample app for this please suggest.

Thanks

[vinieme12]

http://qlikviewcookbook.com/recipes/download-info/tutorial-using-common-date-dimensions/

https://community.qlik.com/thread/66717

[Anil_Babu_Samineni]

I have not seen any calendar on your Data model. And meantime, Fields are common first you need to do this. Like helps to you

https://www.analyticsvidhya.com/blog/2014/12/remove-synthetic-key-concatenation-link-table-qlikview/

[kishorj1982]

In that case results are not matching

I have done with below

//Calendar:
//
//load
//Key,
//Month,
//MonthNum,
//MonthNum1,
//Year
//
//Resident
//AR_VarianceSummary;
//
//Concatenate
//
//load
//Key,
//Month,
//MonthNum,
//MonthNum1,
//Year
//
//Resident
//AR_CustomerLedger;
//
//Concatenate
//
//load
//Key,
//Month,
//MonthNum,
//MonthNum1,
//Year
//
//Resident
//AR_GLSummary;
//
//Concatenate
//
//load
//Key,
//Month,
//MonthNum,
//MonthNum1,
//Year
//
//Resident
//AR_UnpostedInv;
//
//
//Concatenate
//
//load
//Key,
//Month,
//MonthNum,
//MonthNum1,
//Year
//
//Resident
//AR_UnpostedRc;
//
//Concatenate
//
//load
//Key,
//Month,
//MonthNum,
//MonthNum1,
//Year
//
//Resident
//AR_UnpostedVoidRc;
//
//Concatenate
//
//load
//Key,
//Month,
//MonthNum,
//MonthNum1,
//Year
//
//Resident
//AR_UnpostedVoidInv;
//
//load
//Key,
//Month,
//MonthNum,
//MonthNum1,
//Year
//
//Resident
//AR_GLDetail;
//
//
//
//
//DROP Fields Month,MonthNum,MonthNum1,Year From AR_VarianceSummary;
//DROP Fields Month,MonthNum,MonthNum1,Year From AR_CustomerLedger;
//DROP Fields Month,MonthNum,MonthNum1,Year From AR_GLSummary;
//DROP Fields Month,MonthNum,MonthNum1,Year From AR_UnpostedInv;
//DROP Fields Month,MonthNum,MonthNum1,Year From AR_UnpostedRc;
//DROP Fields Month,MonthNum,MonthNum1,Year From AR_UnpostedVoidRc;
//DROP Fields Month,MonthNum,MonthNum1,Year From AR_UnpostedVoidInv;
//DROP Fields Month,MonthNum,MonthNum1,Year From AR_GLDetail;

it seems we have diff granularity level in Key field(Composite key using 5 diff keys)

[Anil_Babu_Samineni]

I am not sure or may be not following of your explanation. Would you restrict code / script and try to explain here