topic Re: Sorting dimension of type Date in QlikView https://community.qlik.com/t5/QlikView/Sorting-dimension-of-type-Date/m-p/642491#M235380 <HTML><HEAD></HEAD><BODY><P>How is D4 formatted?</P></BODY></HTML> Fri, 06 Jun 2014 14:18:34 GMT 2014-06-06T14:18:34Z Sorting dimension of type Date https://community.qlik.com/t5/QlikView/Sorting-dimension-of-type-Date/m-p/642489#M235378 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>I have a pivot table with 4 dimensions and 1 expression.</P><P>D1,D2,D3,D4</P><P></P><P>The D4 dimension is a date field, which i want to sort in descending order.</P><P></P><P>Now in a single D1, D4 are not in the desired order.</P><P></P><P>Is there any way to sort it base on D4 only so that within other D1, i get all the D4 in the desired order.</P><P></P><P>I cannot change the order of the dimensions also.</P><P></P><P>Thanking in advance...</P></BODY></HTML> Fri, 06 Jun 2014 13:37:30 GMT https://community.qlik.com/t5/QlikView/Sorting-dimension-of-type-Date/m-p/642489#M235378 2014-06-06T13:37:30Z Re: Sorting dimension of type Date https://community.qlik.com/t5/QlikView/Sorting-dimension-of-type-Date/m-p/642490#M235379 <HTML><HEAD></HEAD><BODY><P>You need to post some data to get a good answer.</P><P></P><P>However, a common case is that the "date" is not interpreted as a date (meaning that it gets a numeric value also), but is instead just a string, sorted alphabetically. </P><P></P><P>See more on</P><P><A _jive_internal="true" href="https://community.qlik.com/blogs/qlikviewdesignblog/2013/02/19/why-don-t-my-dates-work" title="http://community.qlik.com/blogs/qlikviewdesignblog/2013/02/19/why-don-t-my-dates-work">http://community.qlik.com/blogs/qlikviewdesignblog/2013/02/19/why-don-t-my-dates-work</A></P><P></P><P>HIC</P></BODY></HTML> Fri, 06 Jun 2014 14:08:19 GMT https://community.qlik.com/t5/QlikView/Sorting-dimension-of-type-Date/m-p/642490#M235379 hic 2014-06-06T14:08:19Z Re: Sorting dimension of type Date https://community.qlik.com/t5/QlikView/Sorting-dimension-of-type-Date/m-p/642491#M235380 <HTML><HEAD></HEAD><BODY><P>How is D4 formatted?</P></BODY></HTML> Fri, 06 Jun 2014 14:18:34 GMT https://community.qlik.com/t5/QlikView/Sorting-dimension-of-type-Date/m-p/642491#M235380 2014-06-06T14:18:34Z