Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

arivqlik
New 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

Re: Sort Dynamic Columns in Pivot Table

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
New Contributor II

Re: Sort Dynamic Columns in Pivot Table

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

 

Re: Sort Dynamic Columns in Pivot Table

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

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