topic Re: Month in the data model in QlikView https://community.qlik.com/t5/QlikView/Month-in-the-data-model/m-p/1460777#M610942 <HTML><HEAD></HEAD><BODY><P>i would definitely add the date field and add a master calender.</P><P><A href="https://community.qlik.com/docs/DOC-3858">Master Calendar Generation Script</A></P><P></P><P>i think you have to Keep the key as it is.</P></BODY></HTML> Tue, 09 Jan 2018 07:16:56 GMT zhadrakas 2018-01-09T07:16:56Z Month in the data model https://community.qlik.com/t5/QlikView/Month-in-the-data-model/m-p/1460776#M610941 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have defined a key to join the tables in my data model which conmprises of phone number and month. As the requirement earlier was to look at only the lastmonth. </P><P>Now I need to look at the last 6 months data and show a trend. </P><P>Should I keep the key as it is and then add a date field in each table that need to join to a calendar table?</P><P>Is there any better solution?</P><P></P><P>Thanks in advance.</P></BODY></HTML> Mon, 08 Jan 2018 18:44:11 GMT https://community.qlik.com/t5/QlikView/Month-in-the-data-model/m-p/1460776#M610941 qliktech_uk 2018-01-08T18:44:11Z Re: Month in the data model https://community.qlik.com/t5/QlikView/Month-in-the-data-model/m-p/1460777#M610942 <HTML><HEAD></HEAD><BODY><P>i would definitely add the date field and add a master calender.</P><P><A href="https://community.qlik.com/docs/DOC-3858">Master Calendar Generation Script</A></P><P></P><P>i think you have to Keep the key as it is.</P></BODY></HTML> Tue, 09 Jan 2018 07:16:56 GMT https://community.qlik.com/t5/QlikView/Month-in-the-data-model/m-p/1460777#M610942 zhadrakas 2018-01-09T07:16:56Z