I've been searching this community for ways to sort bar charts by date. I've seen some examples in which people asked for sorting graphs by month (in which the suggestion is to use MonthStart), but I would like to sort by day.
In the data load editor I'm loading the date by using the following code:
Date("Trade Date",'YYYY-MM-DD') as "Trade Date",
FROM [lib://Desktop/sheet1.xlsx] (ooxml, embedded labels, table is 'sheet1');
since I'm working with Qlik Sense, I'm curious where exactly to put the formulas you are suggesting in your article. Do I need to put it in the Data model viewer? Or should I use it to sort my bar chart by expression? I tried both, like Michael Solomovich suggested in his reply, but no success unfortunately.
It's really the same thing. What both Michael and I are suggesting, is to use the combination Date(Date#(...)) in the Load script, and sort the object numerically. You can use sort by expression, too, but this is overkill and not as efficient...