Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Sorting by date dimension

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.

1 Solution

Accepted Solutions
swuehl
MVP
MVP

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).

View solution in original post

3 Replies
swuehl
MVP
MVP

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).

View solution in original post

sunny_talwar

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

Why don’t my dates work?

QlikView Date fields

Not applicable
Author

It worked!  Thank you so much for your help.