
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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 |
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 !!!

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi Qlik Community,
Any hint or advice on this ?
Best

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
