https://community.qlik.com/t5/App-Development/Issues-with-join-on-Master-Calendar/m-p/1737863#M56437 <P>Hi all -&nbsp;</P><P>&nbsp;</P><P>I am having an issue with a join on the master calendar I created. I have an excel spreadsheet that contains the fiscal month name, and the expected number (20) for each month. I joined that fiscal month with the fiscal month in the master calendar.&nbsp; The only dimension in this graph is joined value fmonth-fiscalmonth. For the dimensions I have the actual values accounted for in 2017,2018,2019 as well as the target numbers. As you can see, the x axis contains the fiscal month name and the projected numbers, as well as the fiscal month number and the actuals from previous years on the right. Essentially, I need them all conglomerated by fiscal month name, with the blue number projections in an upward slope overtop of them, as we are trying to create a sloped line projection/expectation.</P><P>&nbsp;</P><P>I have changed the spreadsheet and tried joining on fiscal month number, joining fiscal month number with fiscal month name, and many other combinations. I have no clue why this is happening, or why the fiscal month names are out of order on the left. Any help would be sincerely appreciated!!</P><P>&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="mastercalendarissuescreenshot.JPG" style="width: 999px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/39430iA0B19D9B7F24963F/image-size/large?v=v2&amp;px=999" role="button" title="mastercalendarissuescreenshot.JPG" alt="mastercalendarissuescreenshot.JPG" /></span></P> Sat, 16 Nov 2024 18:11:58 GMT Acfrish 2024-11-16T18:11:58Z https://community.qlik.com/t5/App-Development/Issues-with-join-on-Master-Calendar/m-p/1737863#M56437 <P>Hi all -&nbsp;</P><P>&nbsp;</P><P>I am having an issue with a join on the master calendar I created. I have an excel spreadsheet that contains the fiscal month name, and the expected number (20) for each month. I joined that fiscal month with the fiscal month in the master calendar.&nbsp; The only dimension in this graph is joined value fmonth-fiscalmonth. For the dimensions I have the actual values accounted for in 2017,2018,2019 as well as the target numbers. As you can see, the x axis contains the fiscal month name and the projected numbers, as well as the fiscal month number and the actuals from previous years on the right. Essentially, I need them all conglomerated by fiscal month name, with the blue number projections in an upward slope overtop of them, as we are trying to create a sloped line projection/expectation.</P><P>&nbsp;</P><P>I have changed the spreadsheet and tried joining on fiscal month number, joining fiscal month number with fiscal month name, and many other combinations. I have no clue why this is happening, or why the fiscal month names are out of order on the left. Any help would be sincerely appreciated!!</P><P>&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="mastercalendarissuescreenshot.JPG" style="width: 999px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/39430iA0B19D9B7F24963F/image-size/large?v=v2&amp;px=999" role="button" title="mastercalendarissuescreenshot.JPG" alt="mastercalendarissuescreenshot.JPG" /></span></P> Sat, 16 Nov 2024 18:11:58 GMT https://community.qlik.com/t5/App-Development/Issues-with-join-on-Master-Calendar/m-p/1737863#M56437 Acfrish 2024-11-16T18:11:58Z https://community.qlik.com/t5/App-Development/Issues-with-join-on-Master-Calendar/m-p/1740569#M56688 <P>Can you please post sample data and rough image of what you are expecting.</P><P>&nbsp;</P><P>Regards,</P><P>AB</P> Wed, 02 Sep 2020 10:05:17 GMT https://community.qlik.com/t5/App-Development/Issues-with-join-on-Master-Calendar/m-p/1740569#M56688 AbhijitBansode 2020-09-02T10:05:17Z