topic Re: Table shows December as the first month of the year, but only in AccessPoint in QlikView

Table shows December as the first month of the year, but only in AccessPoint

fluis — Mon, 26 Jan 2026 18:19:17 GMT

Title says it all. Instead of January through December, the table starts with December and ends the year with November. The data is correct, as in December data is showing under December.

Both dev and production in the designer show the correct order of months.

I'm new to Qlikview and took over this app from someone else, and I'm at a loss.

Re: Table shows December as the first month of the year, but only in AccessPoint

Ray_Strother — Thu, 14 Apr 2022 14:21:36 GMT

Hello ,

This link below may help you,

https://community.qlik.com/t5/QlikView-App-Dev/Sort-Month-Name/m-p/836194

If not post what your script looks like and I will research the behavior further.

Thanks

Re: Table shows December as the first month of the year, but only in AccessPoint

Claude1 — Tue, 26 Apr 2022 05:17:29 GMT

@fluis wrote:

Title says it all. Instead of January through December, the table starts with December and ends the year with November. The data is correct, as in December data is showing under December.

Both dev and production in the designer show the correct order of months.

I'm new to Qlikview and took over this app from someone else, and I'm at a loss.

If you have created Month field in QlikView using Month() function, then QV stores both numeric and string representation of it (Dual). And it should sort the values from Jan to Dec by default. If not, check sort tab. If the field is not created using Month() function, then you have to use dual() function to assign both number and text values to it.

ACE Flare Account