Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
dotnetfan
New Contributor II

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

Re: How to display descending in data filter panel?

Change the sort order from the object properties

dotnetfan
New Contributor II

Re: How to display descending in data filter panel?

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

Re: How to display descending in data filter panel?

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

ansh04
New Contributor II

Re: How to display descending in data filter panel?

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 !

 

 

 

Community Manager
Community Manager

Re: How to display descending in data filter panel?

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

Sue Macaluso