topic Re: How to the sort vales in my Filter panel in App Development

How to the sort vales in my Filter panel

Verticurlqlik — Sat, 16 Nov 2024 04:35:55 GMT

Hi There

How to the sort vales in my Filter panel as shown in the screenshot. I've a pivot table in my dashboard with region and month filter's, but in month it is not in order. Please help on this.

Thanks

Nandhakumar

Re: How to the sort vales in my Filter panel

Arthur_Fong — Tue, 24 Sep 2019 04:52:40 GMT

Try formatting your date to date format. Currently the date is in text format:

date#([Date Field],'MMM-YYYY') as Date

Re: How to the sort vales in my Filter panel

Verticurlqlik — Tue, 24 Sep 2019 04:54:31 GMT

Hi JK

Thanks for your reply

Will it impact in filter value listing also?

Thanks

Nandhakumar

Re: How to the sort vales in my Filter panel

Arthur_Fong — Tue, 24 Sep 2019 04:56:54 GMT

Where did you apply filter in? Script or Set analysis?

Re: How to the sort vales in my Filter panel

Verticurlqlik — Tue, 24 Sep 2019 05:30:50 GMT

Hi JK

Actually i have a pivot table and a field called Month, there i'm using month filed in as filter option. So, not having any script or set analysis here.

Thanks

Nandhakumar

Re: How to the sort vales in my Filter panel

Arthur_Fong — Tue, 24 Sep 2019 05:39:18 GMT

Can you try formatting your date column first?

Possibly your date column is set as text and it couldn't reflect the correct sort order for date.

Re: How to the sort vales in my Filter panel

Verticurlqlik — Tue, 24 Sep 2019 05:58:10 GMT

Sure JK

will fix in data and check again as guided. Thanks again

Re: How to the sort vales in my Filter panel

wayne-a — Tue, 24 Sep 2019 12:24:53 GMT

Also be sure to check the sorting section on the pivot table properties and be sure that the settings are correct for your date field. Here is an example of one.