topic How to display descending in data filter panel? in App Development

How to display descending in data filter panel?

dotnetfan — Mon, 10 Jun 2019 12:29:38 GMT

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!

Re: How to display descending in data filter panel?

sunny_talwar — Mon, 10 Jun 2019 12:31:25 GMT

Change the sort order from the object properties

Re: How to display descending in data filter panel?

dotnetfan — Mon, 10 Jun 2019 13:02:33 GMT

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

Re: How to display descending in data filter panel?

sunny_talwar — Mon, 10 Jun 2019 13:14:59 GMT

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

Re: How to display descending in data filter panel?

ansh04 — Mon, 10 Jun 2019 13:44:15 GMT

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 !

Re: How to display descending in data filter panel?

Sue_Macaluso — Wed, 12 Jun 2019 19:35:21 GMT

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