topic Date dimension not sorting properly in pivot chart in QlikView https://community.qlik.com/t5/QlikView/Date-dimension-not-sorting-properly-in-pivot-chart/m-p/144526#M23437 <HTML><HEAD></HEAD><BODY><P>Generally speaking, I would use a date field for Month_Year. Using the formats that QlikView likes just makes things go so much more smoothly. Another possibility is to use a dual() value, such as "dual(Month_Year,monthstart(Master_Date)) as Month_Year", and then sort by numeric value. Another possiblity is to load all the Month_Years before you load the main table, load them in the order you want, and then sort by original load order. I'm sure there are a number of other solutions as well.</P></BODY></HTML> Wed, 20 May 2009 05:40:04 GMT johnw 2009-05-20T05:40:04Z Date dimension not sorting properly in pivot chart https://community.qlik.com/t5/QlikView/Date-dimension-not-sorting-properly-in-pivot-chart/m-p/144525#M23436 <HTML><HEAD></HEAD><BODY><P>Hey guys. I've got a pivot chart with two dimensions, one is a name and one is a date dimension. I'm doing a rollup count by Month_Year in my calendar dimension. The counts work fine, but the dang dates aren't sorting properly. The Month_Year field is a text field, not an actual date field. I've got a Master_Date field that's a date, as well as a Date_Key field that's like 20090519. I tried going to the sort tab and sorting by numic value, or by Master_Date or Date_Key for the expression. Nothing seems to be working. The dates are all out of order. Any ideas or advice? Thanks!</P></BODY></HTML> Wed, 20 May 2009 05:02:40 GMT https://community.qlik.com/t5/QlikView/Date-dimension-not-sorting-properly-in-pivot-chart/m-p/144525#M23436 2009-05-20T05:02:40Z Date dimension not sorting properly in pivot chart https://community.qlik.com/t5/QlikView/Date-dimension-not-sorting-properly-in-pivot-chart/m-p/144526#M23437 <HTML><HEAD></HEAD><BODY><P>Generally speaking, I would use a date field for Month_Year. Using the formats that QlikView likes just makes things go so much more smoothly. Another possibility is to use a dual() value, such as "dual(Month_Year,monthstart(Master_Date)) as Month_Year", and then sort by numeric value. Another possiblity is to load all the Month_Years before you load the main table, load them in the order you want, and then sort by original load order. I'm sure there are a number of other solutions as well.</P></BODY></HTML> Wed, 20 May 2009 05:40:04 GMT https://community.qlik.com/t5/QlikView/Date-dimension-not-sorting-properly-in-pivot-chart/m-p/144526#M23437 johnw 2009-05-20T05:40:04Z