topic Re: Presentation of Values from MonthDiff as Year, Month in Visualization and Usability https://community.qlik.com/t5/Visualization-and-Usability/Presentation-of-Values-from-MonthDiff-as-Year-Month/m-p/1420443#M110577 <HTML><HEAD></HEAD><BODY><P>can you try something like wherever you are calculating the Monthdiff</P><P></P><P>dual(Monthdiff expression ,date(End,'MMM-YYYY')) </P><P></P><P>regards</P><P>Pradosh</P></BODY></HTML> Tue, 10 Oct 2017 14:53:01 GMT pradosh_thakur 2017-10-10T14:53:01Z Presentation of Values from MonthDiff as Year, Month https://community.qlik.com/t5/Visualization-and-Usability/Presentation-of-Values-from-MonthDiff-as-Year-Month/m-p/1420442#M110576 <HTML><HEAD></HEAD><BODY><P>Hi Folks,</P><P></P><P>i have a question,</P><P>i have the fields: Start, End, MonthDiff</P><P></P><P>for example:</P><P>Start,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; End,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; MonthDiff</P><P>06.10.2017&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 06.05.2019&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 20</P><P>06.10.2017&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 06.10.2018&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 13</P><P></P><P>if i splitt the amounts: 2,78 : 20 and 1,14 : 20</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0,68 : 13 and 0,51 : 13</P><P></P><P>and have the following chart (see attached screenshot)</P><P></P><P>my issue:</P><P></P><P>how can i show below of my chart the date-values like: Okt 2017, Nov 2017 until Mai 2019&nbsp; and&nbsp; not 13, 8 , 20, 27?</P><P></P><P>does anybody have any ideas?</P><P></P><P>thanks a lot</P><P>Beck</P></BODY></HTML> Mon, 09 Oct 2017 17:13:21 GMT https://community.qlik.com/t5/Visualization-and-Usability/Presentation-of-Values-from-MonthDiff-as-Year-Month/m-p/1420442#M110576 beck_bakytbek 2017-10-09T17:13:21Z Re: Presentation of Values from MonthDiff as Year, Month https://community.qlik.com/t5/Visualization-and-Usability/Presentation-of-Values-from-MonthDiff-as-Year-Month/m-p/1420443#M110577 <HTML><HEAD></HEAD><BODY><P>can you try something like wherever you are calculating the Monthdiff</P><P></P><P>dual(Monthdiff expression ,date(End,'MMM-YYYY')) </P><P></P><P>regards</P><P>Pradosh</P></BODY></HTML> Tue, 10 Oct 2017 14:53:01 GMT https://community.qlik.com/t5/Visualization-and-Usability/Presentation-of-Values-from-MonthDiff-as-Year-Month/m-p/1420443#M110577 pradosh_thakur 2017-10-10T14:53:01Z Re: Presentation of Values from MonthDiff as Year, Month https://community.qlik.com/t5/Visualization-and-Usability/Presentation-of-Values-from-MonthDiff-as-Year-Month/m-p/1420444#M110578 <HTML><HEAD></HEAD><BODY><P>The issue is solved</P><P></P><P>Solution: <A href="https://community.qlik.com/thread/277421">FromDate, ToDate in Master Calender</A></P></BODY></HTML> Thu, 12 Oct 2017 15:42:48 GMT https://community.qlik.com/t5/Visualization-and-Usability/Presentation-of-Values-from-MonthDiff-as-Year-Month/m-p/1420444#M110578 beck_bakytbek 2017-10-12T15:42:48Z