Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

hlines_usacs
Contributor II

Qlik Sense Pivot Table Date Drop Down not sorting numerically

Hello, I have a pivot table which has a dimension of "Month" in the format of "Jan 2014." I have it set to sort numerically, but the drop down selection on the pivot table is not sorting. How would I be able to get this list sorted properly?

In the screen shot, the red box shows the drop down values that are not sorted correctly. The blue box shows the rows in the pivot table that are sorted correctly. I would like to sort the drop down values the same as the row values.

month.jpgmonth2.jpg

1 Solution

Accepted Solutions
hlines_usacs
Contributor II

Re: Qlik Sense Pivot Table Date Drop Down not sorting numerically

I solved my issue. I loaded the data using the dual() function.

dual(month, monthyear)

where "month" is in the format of "Jan 2015"

and "monthyear" is in the format of 201501

4 Replies

Re: Qlik Sense Pivot Table Date Drop Down not sorting numerically

I suspect your "Month" field is stored in Text format and not Numeric.

hlines_usacs
Contributor II

Re: Qlik Sense Pivot Table Date Drop Down not sorting numerically

Wouldn't that be affected everywhere and not just in the drop down?

Re: Qlik Sense Pivot Table Date Drop Down not sorting numerically

Quite likely - hard for me to see "everywhere" without the qvf.

hlines_usacs
Contributor II

Re: Qlik Sense Pivot Table Date Drop Down not sorting numerically

I solved my issue. I loaded the data using the dual() function.

dual(month, monthyear)

where "month" is in the format of "Jan 2015"

and "monthyear" is in the format of 201501