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
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
MarcCheese
Contributor
Contributor

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

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
B126
C-16
D55
E49
F195
G-122
H54
I152
J124
K110
L-83
M-196
N-153
O11
P-9
K-89
R-42

 

 SortedWaterfall chart
M-196Shown
F195Shown
N-153Shown
I152Shown
B126Shown
J124Shown
G-122Grouped under "Other deviation"
K110Grouped under "Other deviation"
K-89Grouped under "Other deviation"
L-83Grouped under "Other deviation"
A-81Grouped under "Other deviation"
D55Grouped under "Other deviation"
H54Grouped under "Other deviation"
E49Grouped under "Other deviation"
R-42Grouped under "Other deviation"
C-16Grouped under "Other deviation"
O11Grouped under "Other deviation"
P-9Grouped under "Other deviation"

 

Thank you !!!

Labels (4)
2 Replies
MarcCheese
Contributor
Contributor
Author

Hi Qlik Community, 

Any hint or advice on this ?

Best

andreykh
Creator II
Creator II

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.