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: 
Masi_Sahargahi
Contributor III
Contributor III

sort order will be changed after selection

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.

4 Replies
Anil_Babu_Samineni

Reload this?

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
Frank_Hartmann
Master II
Master II

2 things to change:

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

2: Sort Expression: MONTH_NAME

Aufnahme_2018_06_02_10_13_39_23.gif

Masi_Sahargahi
Contributor III
Contributor III
Author

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..

Anil_Babu_Samineni

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

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful