topic insert targets (excel) by date in QlikView https://community.qlik.com/t5/QlikView/insert-targets-excel-by-date/m-p/869968#M655235 <HTML><HEAD></HEAD><BODY><P>Hello guys,</P><P>I want to insert a target table for salesperson by date and link that with the master calendar</P><P>How can I realize that ?</P><P></P><P>I Have all of my data in one table:</P><P></P><P>ALL:</P><P>DocNo,</P><P>Date,</P><P>Salesperson,</P><P>Amount,</P><P>...</P><P></P><P>ExcelTarget:</P><P>Salesperson &amp; '|' &amp; Date as %KEY_TARGET</P><P>Salesperson,</P><P>Date (2012 - 2015, fictitious dates per Month and year once ..)</P><P>TargetMonthAmount, TargetMonthAmount*12 as TargetYearAmount&nbsp; ( OR TargetYearAmount, TargetYearAmount/12 as TargetMonthAmount)..no relevant which way.</P><P></P><P>My problem is, I can't join / combine the 2 Date table, even with Join ..</P></BODY></HTML> Thu, 02 Jul 2015 10:55:47 GMT 2015-07-02T10:55:47Z insert targets (excel) by date https://community.qlik.com/t5/QlikView/insert-targets-excel-by-date/m-p/869968#M655235 <HTML><HEAD></HEAD><BODY><P>Hello guys,</P><P>I want to insert a target table for salesperson by date and link that with the master calendar</P><P>How can I realize that ?</P><P></P><P>I Have all of my data in one table:</P><P></P><P>ALL:</P><P>DocNo,</P><P>Date,</P><P>Salesperson,</P><P>Amount,</P><P>...</P><P></P><P>ExcelTarget:</P><P>Salesperson &amp; '|' &amp; Date as %KEY_TARGET</P><P>Salesperson,</P><P>Date (2012 - 2015, fictitious dates per Month and year once ..)</P><P>TargetMonthAmount, TargetMonthAmount*12 as TargetYearAmount&nbsp; ( OR TargetYearAmount, TargetYearAmount/12 as TargetMonthAmount)..no relevant which way.</P><P></P><P>My problem is, I can't join / combine the 2 Date table, even with Join ..</P></BODY></HTML> Thu, 02 Jul 2015 10:55:47 GMT https://community.qlik.com/t5/QlikView/insert-targets-excel-by-date/m-p/869968#M655235 2015-07-02T10:55:47Z Re: insert targets (excel) by date https://community.qlik.com/t5/QlikView/insert-targets-excel-by-date/m-p/869969#M655236 <HTML><HEAD></HEAD><BODY><P>Perhaps you can concatenate the tables: <A _jive_internal="true" class="font-color-normal" href="https://community.qlik.com/blogs/qlikviewdesignblog/2012/10/26/mixed-granularity" style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #3d3d3d;">Fact Table with Mixed Granularity</A></P></BODY></HTML> Thu, 02 Jul 2015 11:02:40 GMT https://community.qlik.com/t5/QlikView/insert-targets-excel-by-date/m-p/869969#M655236 Gysbert_Wassenaar 2015-07-02T11:02:40Z