Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
WE ARE LISTENING! New Navigation for Qlik Community, Sept. 26: TELL ME MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
mahitham
Creator II
Creator II

Cumulative bar chart help

Hi ,

Can any one please help me on below cumulative chart issue.

I have created the cumulative chart which is 2nd one. But business want to see the month sorting from May to June with May as highest value.But when i have changed the sorting order getting May as lowest value please help me on this.

bar chart sorting.png

 

Thanks in advance.

Labels (1)
3 Replies
jwjackso
Specialist III
Specialist III

Under sorting for the chart, "Sort by expression" try

=match(Month(your date field here),'Dec','Nov','Oct','Sep','Aug','Jul','Jun','May','Apr','Mar','Feb','Jan')

Basically it returns 5 for May and 12 for Jan and reverses the normal month sort order.

mahitham
Creator II
Creator II
Author

Hi @jwjackso 

By using this expression May to Jan sorting is getting but the issue is still may showing less count.

I am looking for sorting should be reverse from may to jan and cumulative is from Jan to may. so May will show highest number.

Could you please help me on this.

mahitham
Creator II
Creator II
Author

Hi @sunny_talwar 

could you please help on this cumulative with sorting.