sort date range in bar chart dimension

[Arvind_Singh]

Hi all,

I have below dimension in the Qlik Sense bar chart -

= DATE(weekstart (DATE(floor([date_id]), 'DD-MM-YYYY')),'DD-MMM-YYYY') & ' to '& DATE(Weekend(DATE(floor([date_id]), 'DD-MM-YYYY')),'DD-MMM-YYYY')  

• the format of [date_id] is MM/DD/YYYY.
• the measure is count([incident_num])

Could you please advice how can the date range in X axis be sorted?

[Or · Accepted solution]

Several options, but the easiest one would be to use Dual(DATE(weekstart (DATE(floor([date_id]), 'DD-MM-YYYY')),'DD-MMM-YYYY') & ' to '& DATE(Weekend(DATE(floor([date_id]), 'DD-MM-YYYY')),'DD-MMM-YYYY'), num(weekstart (DATE(floor([date_id]), 'DD-MM-YYYY')),'DD-MMM-YYYY')). This would assign the numeric value of the week start to each of these calculated dimensions and they'd sort numerically.