Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
@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.