topic Re: Date/join/trim in QlikView https://community.qlik.com/t5/QlikView/Date-join-trim/m-p/107582#M758741 <HTML><HEAD></HEAD><BODY><P>Hope the below attachment will help:</P></BODY></HTML> Wed, 22 Aug 2018 15:13:12 GMT trdandamudi 2018-08-22T15:13:12Z Date/join/trim https://community.qlik.com/t5/QlikView/Date-join-trim/m-p/107581#M758740 <HTML><HEAD></HEAD><BODY><P>Hi everyone, </P><P></P><P>My name is Solomon a new memeber of Qlikview family.</P><P></P><P>I have reccently joint and organisation just over 3 months ago and I am in charge of developing qlikview applications. </P><P>Am working on a procurement project developing an app which involves dates and I need help joining/triming two dates together. </P><P></P><P>within my original data I have a date format like</P><P></P><P>01/02/2017</P><P>05/04/2017</P><P>06/04/2017</P><P>04/01/2018</P><P>07/01/2018</P><P>05/12/2018</P><P>04/04/2019</P><P>03/04/2019</P><P></P><P> and I have create a seperate date format like </P><P></P><P>YEAR</P><P>2017</P><P>2018</P><P>2019</P><P></P><P>MONTHS</P><P>01</P><P>04</P><P>02</P><P></P><P>what I want to do is join 'YYYY' and 'MM' date seperately to my original data above so when I click on just 'YYYY' or 'MM' it will bring only the relevant year within the data.</P><P></P><P>I have tried using join [KEY year] on both the tabs but was not doing what I wanted</P><P></P><P>I hope I make sense and I can get answers from any Guru's out there </P><P></P><P>Thanks</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Date-join-trim/m-p/107581#M758740 solomonadjei 2020-11-25T16:16:04Z Re: Date/join/trim https://community.qlik.com/t5/QlikView/Date-join-trim/m-p/107582#M758741 <HTML><HEAD></HEAD><BODY><P>Hope the below attachment will help:</P></BODY></HTML> Wed, 22 Aug 2018 15:13:12 GMT https://community.qlik.com/t5/QlikView/Date-join-trim/m-p/107582#M758741 trdandamudi 2018-08-22T15:13:12Z