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

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
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
MVP
MVP

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
MVP
MVP

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
Former Employee
Former Employee

@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!