topic Re: Problem with MasterCalendar in QlikView https://community.qlik.com/t5/QlikView/Problem-with-MasterCalendar/m-p/564594#M1117941 <HTML><HEAD></HEAD><BODY><P>You have two distinct Mrz values in field CREATED_AT_MONAT. Are they spelled exactly the same? Otherwise Qv will treat them as different values. Most likely M is in English in one case and in German in the other.</P></BODY></HTML> Mon, 10 Feb 2014 13:24:30 GMT giakoum 2014-02-10T13:24:30Z Problem with MasterCalendar https://community.qlik.com/t5/QlikView/Problem-with-MasterCalendar/m-p/564593#M1117940 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>i've generate an MasterCalendar and load also a fixed calendar into iIn my time-box there are two fields with Mrz an the fixed calendar does'nt work. Please can you give me a solution to fixed the problem</P><P></P><P>Regards<BR />Stefan </P></BODY></HTML> Mon, 10 Feb 2014 13:15:31 GMT https://community.qlik.com/t5/QlikView/Problem-with-MasterCalendar/m-p/564593#M1117940 Anonymous 2014-02-10T13:15:31Z Re: Problem with MasterCalendar https://community.qlik.com/t5/QlikView/Problem-with-MasterCalendar/m-p/564594#M1117941 <HTML><HEAD></HEAD><BODY><P>You have two distinct Mrz values in field CREATED_AT_MONAT. Are they spelled exactly the same? Otherwise Qv will treat them as different values. Most likely M is in English in one case and in German in the other.</P></BODY></HTML> Mon, 10 Feb 2014 13:24:30 GMT https://community.qlik.com/t5/QlikView/Problem-with-MasterCalendar/m-p/564594#M1117941 giakoum 2014-02-10T13:24:30Z Re: Problem with MasterCalendar https://community.qlik.com/t5/QlikView/Problem-with-MasterCalendar/m-p/564595#M1117942 <HTML><HEAD></HEAD><BODY><P>Hi Stefan,</P><P></P><P>Issue with your Data Model is that you have linked the fixed Calender and Master Calender with the MonthName Field.</P><P>in Fixed Calender, The MonthName(i.e. CREATED_AT_MONAT) is in with Pure Text Value.</P><P>Whereas, in Master Calender, the MonthName(i.e. CREATED_AT_MONAT) is formed by the Month() Function of Qlikview which returns a Dual Character i.e. numeric Value.....</P><P></P><P>Hence it is showing one Mrz Field on the Left Side(bcoz of Text) and another on Right Side(bcoz of Numeric)....</P><P></P><P>My Suggestion, Instead of linking with CREATED_AT_MONAT you can link with the CREATED_AT_SORTMON by creating the same field in Master Calender.</P><P></P><P>Hope this helps...</P><P></P><P>Regards</P><P>Rahul</P></BODY></HTML> Mon, 10 Feb 2014 13:37:57 GMT https://community.qlik.com/t5/QlikView/Problem-with-MasterCalendar/m-p/564595#M1117942 rahulgupta 2014-02-10T13:37:57Z