Qlik Community

Ask a Question

New to Qlik Sense

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

Announcements
QlikWorld starts MONDAY! last chance to register is now ! REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
somenathroy
Creator III
Creator III

Sorting order of Bar Chart not working on Date field

Hi All,

I am facing an issue for sorting order of a Bar chart in Qlik Sense app. Added one date(M/D/YYYY) column as dimension and sum(Sales) as an expression. Would like to set sorting order ascending on date column. Same functionality is working fine for a Table and Filter Pane object. Please refer the below screen shot.

For all 3 objects sorting order has been set as Custom-> Sort numerically Ascending and sorting order of the Measure in table/Chart has been made disabled.

Any idea would be appreciated.

Capture.JPG

Thanks.

1 Solution

Accepted Solutions
rubenmarin

Hi Some, maybe it's sorting by load order of sales, in the right margin, on 'Sorting' -> try drag & drop 'Week Ending' before 'Sales'.

View solution in original post

3 Replies
rubenmarin

Hi Some, maybe it's sorting by load order of sales, in the right margin, on 'Sorting' -> try drag & drop 'Week Ending' before 'Sales'.

View solution in original post

kaushiknsolanki

Use Sort by Expression and put Date Field and Select Ascending.

Regards,

Kaushik Solanki

Regards,
Kaushik
If reply is satisfactory, please "Like" the post.
If reply is solution, please mark as "Correct".
somenathroy
Creator III
Creator III
Author

I tried sort by expression, but it did not work.

Reordering of the sorting columns worked as expected.

Thanks all for reply.