Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
dotnetfan
Contributor III
Contributor III

How to display descending in data filter panel?

Now I have a data filter shows ascending, like 

2018/01/01

2018/01/02

2018/01/03 ...

I would like to display with descending, could you please let me know how to do it?

 

Thanks!

5 Replies
sunny_talwar

Change the sort order from the object properties

dotnetfan
Contributor III
Contributor III
Author

Thank you, I changed the sorting order as descending however, the column shows as descending however, when I clicked the search button, the data is showing ascending

Untitled.png

sunny_talwar

I am not sure, may be someone else can help you better with this.

ansh04
Contributor II
Contributor II

Try using Dual function at the scripting level :

Example :   Dual(Date,Num(Date)) as CreatedDate

Above script will store your data in Number as well as in Date format and then i assume your sorting will work.

Cheers !

 

 

 

Sue_Macaluso
Community Manager
Community Manager

@dotnetfan Are you using QlikView or Sense?  I would like to move this into the correct product forum. 

Sue Macaluso