Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
See why BI users voted Qlik #1 in 11 categories. GET REPORT
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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 !!!

2 Replies
Highlighted
Contributor
Contributor

Hi Qlik Community, 

Any hint or advice on this ?

Best

Highlighted
Creator
Creator

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.