topic 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:17:50 GMT

Reload this?

Re: sort order will be changed after selection

Frank_Hartmann — Sat, 02 Jun 2018 08:16:23 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:50:03 GMT

NO need to reload

I couldn't download the file,have you made any change in my file?

Please reply on the main link,then I'll remove the thread..

Re: sort order will be changed after selection

Anil_Babu_Samineni — Sat, 02 Jun 2018 09:05:03 GMT

Instead, Can you just use this as expression from sort TAB and test?

Only({1} MONTH_NUMBER_OF_YEAR)

If not, Will share script which i changed