Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor
Contributor

Secondary sort of a stacked bar chart

Hi all

I have a stacked bar chart that I can´t sort the way I want to. Equal values they are sorted alphabetically but I want them sorted according to which one scores highest in the dark blue field.

I sort using this script:

(Numericcount(L_$(Year)_2)+Numericcount(L_$(Year)_1))/(NumericCount(L_$(Year)_1)+NumericCount(L_$(Year)_2)+NumericCount(L_$(Year)_3)+NumericCount(L_$(Year)_4))

And I want to do a secondary sort for equal values using this:

(Numericcount(L_$(Year)_1))/(NumericCount(L_$(Year)_1)+NumericCount(L_$(Year)_2)+NumericCount(L_$(Year)_3)+NumericCount(L_$(Year)_4))

2018-07-12_11-52-28.jpg

Any ideas?

/Måns

0 Replies