Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
arivqlik
Contributor II
Contributor II

Sort Dynamic Columns in Pivot Table

I have a report with below format. How to Sort the columns with month and yr.

clipboard_image_0.png

3 Replies
sunny_talwar

If Month year is a dual field, sort it numerically in ascending or descending order. If it is not, then I suggest fixing this in the script to make it a dual field and then sort it numerically.

arivqlik
Contributor II
Contributor II
Author

It is the date field and i converted to =month(column name) & '-' & Year(column name) format. Columns are not sorting

 

sunny_talwar

Instead of creating it like this =month(column name) & '-' & Year(column name), create it like this

Date(MonthStart(column name), 'MMM-YYYY')