Waterfall Chart - Measures sorted from largest absolute value - Show real +/- value

[MarcCheese]

Hi,

I would like to use the Waterfall Chart to display financial deviation per cost categories between budget and actual figures.

I have 18 cost categories named here A to P. The deviation value per cost category can be positive or negative. To have a better picture of what are the main deviations, I need to show the 6 largest deviations (either positive or negative) in the chart and group the rest under one "other" category. Please see the table below which illustrate my need.

What I know:  How to find Min, Max, 2nd Min, 2nd Max etc.. Usage of Fabs function. Basically I know how to show the first largest +/- deviation, but I am quickly blocked when I am trying to find the second largest +/- deviation.

	Deviation Value
A	-81
B	126
C	-16
D	55
E	49
F	195
G	-122
H	54
I	152
J	124
K	110
L	-83
M	-196
N	-153
O	11
P	-9
K	-89
R	-42

	Sorted	Waterfall chart
M	-196	Shown
F	195	Shown
N	-153	Shown
I	152	Shown
B	126	Shown
J	124	Shown
G	-122	Grouped under "Other deviation"
K	110	Grouped under "Other deviation"
K	-89	Grouped under "Other deviation"
L	-83	Grouped under "Other deviation"
A	-81	Grouped under "Other deviation"
D	55	Grouped under "Other deviation"
H	54	Grouped under "Other deviation"
E	49	Grouped under "Other deviation"
R	-42	Grouped under "Other deviation"
C	-16	Grouped under "Other deviation"
O	11	Grouped under "Other deviation"
P	-9	Grouped under "Other deviation"

Thank you !!!

[MarcCheese]

Hi Qlik Community, 

Any hint or advice on this ?

Best

[andreykh]

Take a look at a waterfall chart as we see it, in the AnyChart extension: See the waterfall chart documentation showing what is possible and how to implement what, and let's discuss this new feature as our roadmap is largely determined by customers and we can definitely consider adding exactly what you need. Thanks.