topic Re: Sorting by Year and Month in QlikView https://community.qlik.com/t5/QlikView/Sorting-by-Year-and-Month/m-p/1255339#M396761 <HTML><HEAD></HEAD><BODY><P>It's impossible to tell with the information you provide. The calendar data is that a table you are generating in your load-script? Is this a master-calendar? Could you show us some screenshots or upload a sample app that demonstrates your problem?</P></BODY></HTML> Thu, 23 Feb 2017 17:01:12 GMT petter 2017-02-23T17:01:12Z Sorting by Year and Month https://community.qlik.com/t5/QlikView/Sorting-by-Year-and-Month/m-p/1255338#M396760 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>My data set contains calendar data with the following format YYYY-MM. For some reason the charts I'm creating are not sorting by date. it starts with 2016 but then there's a 2015 bar right in the middle of 2016. Any idea? The filter I've added is sorting properly, so I'm not sure why the graph isn't doing the same.</P></BODY></HTML> Thu, 23 Feb 2017 15:56:02 GMT https://community.qlik.com/t5/QlikView/Sorting-by-Year-and-Month/m-p/1255338#M396760 Anonymous 2017-02-23T15:56:02Z Re: Sorting by Year and Month https://community.qlik.com/t5/QlikView/Sorting-by-Year-and-Month/m-p/1255339#M396761 <HTML><HEAD></HEAD><BODY><P>It's impossible to tell with the information you provide. The calendar data is that a table you are generating in your load-script? Is this a master-calendar? Could you show us some screenshots or upload a sample app that demonstrates your problem?</P></BODY></HTML> Thu, 23 Feb 2017 17:01:12 GMT https://community.qlik.com/t5/QlikView/Sorting-by-Year-and-Month/m-p/1255339#M396761 petter 2017-02-23T17:01:12Z Re: Sorting by Year and Month https://community.qlik.com/t5/QlikView/Sorting-by-Year-and-Month/m-p/1255340#M396762 <HTML><HEAD></HEAD><BODY><P>Thanks for responding, screenshots below. </P><P> <IMG class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/154282_pastedImage_0.png" style="max-height: 900px; max-width: 1200px;" /></P><P>As you can see Qlik is automatically applying the calendar script to the "ValueDate" and "BookDate" fields. What I really want is the "ValueDateMonth" and "BookDateMonth" to be the dates I use</P><P><IMG class="jive-image image-2" src="https://community.qlik.com/legacyfs/online/154286_pastedImage_2.png" style="max-height: 900px; max-width: 1200px;" /></P><P>The above screenshot is the automated calendar script I believe. Again, the format of "ValueDateMonth" and "BookDateMonth" is "YYYY-MM".</P><P>Hope this helps.</P></BODY></HTML> Thu, 23 Feb 2017 17:07:02 GMT https://community.qlik.com/t5/QlikView/Sorting-by-Year-and-Month/m-p/1255340#M396762 Anonymous 2017-02-23T17:07:02Z Re: Sorting by Year and Month https://community.qlik.com/t5/QlikView/Sorting-by-Year-and-Month/m-p/1255341#M396763 <HTML><HEAD></HEAD><BODY><P>screenshot of the chart is below</P><P><IMG class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/154288_pastedImage_0.png" style="max-height: 900px; max-width: 1200px;" /></P></BODY></HTML> Thu, 23 Feb 2017 18:03:33 GMT https://community.qlik.com/t5/QlikView/Sorting-by-Year-and-Month/m-p/1255341#M396763 Anonymous 2017-02-23T18:03:33Z Re: Sorting by Year and Month https://community.qlik.com/t5/QlikView/Sorting-by-Year-and-Month/m-p/1255342#M396764 <HTML><HEAD></HEAD><BODY><P>A sample application would be better - I can't determine whether the source dates are really interpreted as real dates by what you show. And not knowing which fields you use in your chart for dimensions it is hard to know what could be "wrong" ...</P></BODY></HTML> Thu, 23 Feb 2017 18:03:42 GMT https://community.qlik.com/t5/QlikView/Sorting-by-Year-and-Month/m-p/1255342#M396764 petter 2017-02-23T18:03:42Z