topic Re: Sort Year-Week in graph in QlikView https://community.qlik.com/t5/QlikView/Sort-Year-Week-in-graph/m-p/1418803#M513998 <HTML><HEAD></HEAD><BODY><P>This solved my problem</P><P>Thank You</P></BODY></HTML> Fri, 01 Sep 2017 07:46:46 GMT stekol61 2017-09-01T07:46:46Z Sort Year-Week in graph https://community.qlik.com/t5/QlikView/Sort-Year-Week-in-graph/m-p/1418801#M513996 <HTML><HEAD></HEAD><BODY><P>Hi!</P><P>I have a report where data is presented in a graph.</P><P>The time dimention in the graph shows Year-Week, e,g "2017-35".</P><P>This dimention is created in the loading script as " <STRONG>Year &amp;'-'&amp;replace(upper(Week),'W','') as YearWeek </STRONG> "</P><P></P><P>The problem is that the sorting of 'YearWeek' is not correct as you see in the graph below.</P><P></P><P>How can this be solved?<STRONG><BR /></STRONG></P><P><IMG alt="" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/175262_pastedImage_1.png" style="max-width: 1200px; max-height: 900px;" /></P></BODY></HTML> Thu, 31 Aug 2017 14:27:00 GMT https://community.qlik.com/t5/QlikView/Sort-Year-Week-in-graph/m-p/1418801#M513996 stekol61 2017-08-31T14:27:00Z Re: Sort Year-Week in graph https://community.qlik.com/t5/QlikView/Sort-Year-Week-in-graph/m-p/1418802#M513997 <HTML><HEAD></HEAD><BODY><P>Try creating it like this</P><P></P><P><STRONG>Dual(" Year &amp;'-'&amp;replace(upper(Week),'W',''), Year*100 + replace(upper(Week),'W','')) as YearWeek "</STRONG></P></BODY></HTML> Thu, 31 Aug 2017 14:29:18 GMT https://community.qlik.com/t5/QlikView/Sort-Year-Week-in-graph/m-p/1418802#M513997 sunny_talwar 2017-08-31T14:29:18Z Re: Sort Year-Week in graph https://community.qlik.com/t5/QlikView/Sort-Year-Week-in-graph/m-p/1418803#M513998 <HTML><HEAD></HEAD><BODY><P>This solved my problem</P><P>Thank You</P></BODY></HTML> Fri, 01 Sep 2017 07:46:46 GMT https://community.qlik.com/t5/QlikView/Sort-Year-Week-in-graph/m-p/1418803#M513998 stekol61 2017-09-01T07:46:46Z