Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
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. 

Did you find a solution to your question? Mark the solution as accepted : and if you found it useful, press the like button!