topic Re: Order by/Sort by Problems in QlikView https://community.qlik.com/t5/QlikView/Order-by-Sort-by-Problems/m-p/6546#M607183 <HTML><HEAD></HEAD><BODY><P>This actually worked perfect, thank you. </P></BODY></HTML> Wed, 24 Jan 2018 18:45:10 GMT MalcolmCICWF 2018-01-24T18:45:10Z Order by/Sort by Problems https://community.qlik.com/t5/QlikView/Order-by-Sort-by-Problems/m-p/6544#M607179 <HTML><HEAD></HEAD><BODY><P>I am trying to get two fields in the YYYY-MMM formatting to sort newest to oldest without any luck. I format them as <SPAN style="color: #0000ff; font-size: 8pt;">Date</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #800000; font-size: 8pt;">MyDate</SPAN><SPAN style="font-size: 8pt;">,'YYYY-MMM')&nbsp; <SPAN style="font-size: 10pt;">but when I display it in a chat with a simple count of the data it duplicates the Year/Months...</SPAN></SPAN></P><P></P><P><SPAN style="font-size: 10pt;">I also tried <SPAN style="color: #0000ff; font-size: 8pt;">year</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #800000; font-size: 8pt;">MyDate</SPAN><SPAN style="font-size: 8pt;">)&amp;'-'&amp;</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">month</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #800000; font-size: 8pt;">MyDate</SPAN><SPAN style="font-size: 8pt;">)&nbsp; <SPAN style="font-size: 10pt;">after doing an "Order By' in the table below.... this works... but I have two dates I am doing this for. It of course only orders by the first one I list. </SPAN></SPAN></SPAN></P><P></P><P><SPAN style="font-size: 10pt;">Is there a sort expression I can use in the chart itself to sort by a date field? Sort By---&gt; Expression----&gt; Desc----&gt; and maybe =MyDate or something?</SPAN></P></BODY></HTML> Wed, 24 Jan 2018 16:27:35 GMT https://community.qlik.com/t5/QlikView/Order-by-Sort-by-Problems/m-p/6544#M607179 MalcolmCICWF 2018-01-24T16:27:35Z Re: Order by/Sort by Problems https://community.qlik.com/t5/QlikView/Order-by-Sort-by-Problems/m-p/6545#M607181 <HTML><HEAD></HEAD><BODY><P>Add MonthStart here</P><P></P><P><STRONG>Date(<SPAN style="color: #ff0000;">MonthStart</SPAN>(MyDate),'YYYY-MMM')</STRONG></P></BODY></HTML> Wed, 24 Jan 2018 16:31:10 GMT https://community.qlik.com/t5/QlikView/Order-by-Sort-by-Problems/m-p/6545#M607181 sunny_talwar 2018-01-24T16:31:10Z Re: Order by/Sort by Problems https://community.qlik.com/t5/QlikView/Order-by-Sort-by-Problems/m-p/6546#M607183 <HTML><HEAD></HEAD><BODY><P>This actually worked perfect, thank you. </P></BODY></HTML> Wed, 24 Jan 2018 18:45:10 GMT https://community.qlik.com/t5/QlikView/Order-by-Sort-by-Problems/m-p/6546#M607183 MalcolmCICWF 2018-01-24T18:45:10Z