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
Issue with your Data Model is that you have linked the fixed Calender and Master Calender with the MonthName Field.
in Fixed Calender, The MonthName(i.e. CREATED_AT_MONAT) is in with Pure Text Value.
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.....
Hence it is showing one Mrz Field on the Left Side(bcoz of Text) and another on Right Side(bcoz of Numeric)....
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.
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.
Issue with your Data Model is that you have linked the fixed Calender and Master Calender with the MonthName Field.
in Fixed Calender, The MonthName(i.e. CREATED_AT_MONAT) is in with Pure Text Value.
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.....
Hence it is showing one Mrz Field on the Left Side(bcoz of Text) and another on Right Side(bcoz of Numeric)....
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.
