topic Re: sort order will be changed after selection in QlikView

sort order will be changed after selection

Masi_Sahargahi — Wed, 25 Nov 2020 16:16:04 GMT

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.

Re: sort order will be changed after selection

Anil_Babu_Samineni — Sat, 02 Jun 2018 06:18:45 GMT

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

Re: sort order will be changed after selection

Frank_Hartmann — Sat, 02 Jun 2018 08:18:38 GMT

2 things to change:

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

2: Sort Expression: MONTH_NAME

Re: sort order will be changed after selection

Masi_Sahargahi — Sat, 02 Jun 2018 08:44:16 GMT

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

Jan,Feb,march,..

Re: sort order will be changed after selection

rwunderlich — Sun, 03 Jun 2018 15:57:43 GMT

Change your sort expression to ignore the Year:

=only({<CALENDAR_YEAR=>}MONTH_NUMBER_OF_YEAR)

-Rob

http://masterssummit.com

http://qlikviewcookbook.com

Re: sort order will be changed after selection

Masi_Sahargahi — Sun, 10 Jun 2018 08:56:15 GMT

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

Re: sort order will be changed after selection

Masi_Sahargahi — Wed, 27 Jun 2018 10:44:43 GMT

It did work,thank you so much!