Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am using date as a dimension (in year-month format). However, in the visualisation the view cannot be sorted by sorting options both custom or automatic.
I think you would need to change sort order, try dragging the dimensions sort options to the top and then try enabling alphabetical or numerical sort option (depending on your underlying values).
I think you would need to change sort order, try dragging the dimensions sort options to the top and then try enabling alphabetical or numerical sort option (depending on your underlying values).
It seems that you [Trip Request Year Month] field is not read a date by Qlik Sense. May be fix this while loading the data
LOAD OtherFields,
Date(Date#([Trip Request Year Month], 'YYYY-MM'), 'YYYY-MM') as [Trip Request Year Month]
FROM Source
It worked! Thank you so much for your help.