Qlik Community

Qlik Sense App Development

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

Highlighted
dotnetfan
New Contributor

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

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