sort order will be changed after selection

[Masi_Sahargahi]

Hi all,

I have a line chart which shows  cumulative sum of price for each month, (For 2018 ,it shows just 5 month which we have data for them).

The problem is :as I specified  year with set analysis, I don’t expect chart changes after select any year, But when I select a year, my chart order will be changed! Can anybody help me out if this.

[Anil_Babu_Samineni]

Don't create duplicate threads sort order will be changed after selection

[Frank_Hartmann]

2 things to change:

1: Add expression: =avg({1}1/1) and make it invisible

2: Sort Expression: MONTH_NAME

[Masi_Sahargahi]

But it doesn't work for me,I expect sort order as follow:

Jan,Feb,march,..

[rwunderlich · Accepted solution]

Change your sort expression to ignore the Year:

=only({<CALENDAR_YEAR=>}MONTH_NUMBER_OF_YEAR)

-Rob

http://masterssummit.com

http://qlikviewcookbook.com

[Masi_Sahargahi]

But  what I want is showing  value for different months of max year and its previous year

[Masi_Sahargahi]

It did work,thank you so much!