Qlik Community

Ask a Question

Qlik Sense Advanced Authoring

Discussion board where members can learn more about Qlik Sense Advanced Authoring.

Announcements
Welcome to our newly redesigned Qlik Community! Read our blog to learn about all the new updates: READ BLOG and REPORTED ISSUES
cancel
Showing results for 
Search instead for 
Did you mean: 
Contributor III
Contributor III

Qlik Sense Filter List Sorting

Hi All,

I am looking for a way to sort desending a date field in the filter pannel, somethign like document properties that we have in Qlik View where you can set how the field should be presented.

I tried with Dual() but that caused other issues, the date picker dashboard bundle object stopped working correctly and the min max also have issues because they try to show as date the 'sorting' column.

does anyone have other ideas on how we can force the date field to show descending oder (newest dates first) because like it is it's not very useful for the users to see data  for years ago that is only seldomly used.

Thanks a lot!

Iulia

Labels (4)
12 Replies
Creator III
Creator III

You can use sorting properties of the filter

filter.JPG

Contributor III
Contributor III

I would like to do this without adding the filter pannel, so just using the selections pannel which then generates the top bar filter. There is where the sort order can't be changed.

Creator III
Creator III

You can try to load the table with order clause like below and see if it helps

Load *
Resident test
order by id;

 

Contributor III
Contributor III

That did not work, same order as before.

Creator III
Creator III

can you post where exactly you are looking for the sort
Contributor III
Contributor III

selections bar sort orderselections bar sort order

Please see how the selections bar filter looks like, it shows the selected date and then the oldest dates, not the lastes dates, which is what the users would like to see.

any ideas if we can control this?

Creator III
Creator III

I also tried at my end and I don't think is so it possible now to sort the data in current selection bar. 

 

Contributor III
Contributor III

It is possible with the user of the Dual() function in the script but because this is a date, the calendar object no longer works anymore, it looks like it's trying to convert into date the dual expression instead of using the normal date.

Creator III
Creator III

can you post the sample app