help: variance waterfall chart extension

bc5891 — Sat, 16 Nov 2024 02:32:21 GMT

Hi guys,

I am trying to implement the Qliksense variance waterfall chart and am having some issues. The example shown in the help documentation has 3 fields: e.g. qtr, sales and budget

qtr, sales, budget

1, 9, 10

2, 12, 9

3, 10, 10

I can see that it would sum budget as the "start" option and then sum sales for the "end" and then movements are calculated between the budget vs sales per quarter.

In my dataset I have 1 value field. within the one field I have the opening balance and closing balance, and the movements pre-calculated in between... as shown below:

balance_type	VALUE
A - OPENING	1000
B - MOVEMENT 1	400
C - MOVEMENT 2	-100
D - MOVEMENT 3	200
E - CLOSING	1500

My question is - can the waterfall variance extension be used to build this chart?

The requirements are that the chart should be dynamic so it should not just be individual expressions for each column. Secondly, there should be drill down functionality, meaning that we can go to a more granular level of detail.

I have looked at other attempts at creating waterfall charts also without the extension but i think the issue in the charts I've analysed is that when the first column is negative the visualisation is unclear as all "negative" values are converted into absolute values.

If anyone can look at my small table below and think that they can use the extension to get the desired outcome I would be very keen to see it.

Many thanks

Re: help: variance waterfall chart extension

bc5891 — Thu, 07 May 2020 07:48:58 GMT

Just a "bump" to see if anyone has ideas on the query above?

thanks in advance all!

topic Re: help: variance waterfall chart extension in App Development

help: variance waterfall chart extension

Re: help: variance waterfall chart extension