Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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')
Could you please advice how can the date range in X axis be sorted?
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.
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.