topic Re: Waterfall chart in Qlik Sense in App Development

Waterfall chart in Qlik Sense

Wed, 24 Sep 2014 09:30:43 GMT

Hi,

The offsetting check box in QlikView doesn't exist in Qlik Sense. Anyone out there who knows how to create a Waterfall chart in Qlik Sense?

Regards,

Pedro

Re: Waterfall chart in Qlik Sense

alex_nerush — Wed, 24 Sep 2014 09:40:17 GMT

I think you need to build extension

Re: Waterfall chart in Qlik Sense

Wed, 24 Sep 2014 11:35:08 GMT

Can you use transparent bars and stacking those with the bars you want to show? That way you should also be able to simulate a waterfall.

Re: Waterfall chart in Qlik Sense

ToniKautto — Wed, 24 Sep 2014 14:57:25 GMT

Qlik Sense extensions open up for customized chart objects or presentation. Qlik Branch is a forum where developers can share open projects. This might be a good place to look for available extensions and ongoing developments.

http://branch.qlik.com/

Re: Waterfall chart in Qlik Sense

pablolabbe — Thu, 06 Nov 2014 16:53:38 GMT

Offsets in charts are necessary to produce waterfall charts and Gantt style chart. Hope to see this feature in a future release.

Re: Waterfall chart in Qlik Sense

rajuamet — Mon, 09 Nov 2015 05:28:29 GMT

Hi check this

Qlik Sense Waterfall Chart (No Extension)

Re: Waterfall chart in Qlik Sense

Mon, 14 Mar 2016 15:39:46 GMT

Hi, Rangaraju R

I am using the model you showed (Dynamic Waterfall) but I only can filter one field.

How can I adjust the script to be able to apply unlimited filters (I have sales group, area, month/year, for example)?

Thanks a lot!!

Re: Waterfall chart in Qlik Sense

Wed, 16 Mar 2016 13:51:58 GMT

Hi Douglas,

This worked for me:

Include all of the fields you want to use to filter in the load of Step_1
Specify all filtering fields in the group by syntax of Step_1.
Include number of filtering fields in crosstable syntax of Step_2

Using Rangaraju R's example the updated script for Step_1 and Step_2 for two filters - Year and Quarter - would be:

Step_1:

Load

"YEAR",

"Quarter",

SUM(REV_A) as Rev_A,

SUM(REV_B) as Rev_B,

SUM(REV_C) as Rev_C,

SUM(COGS) as COGS,

SUM(EXPENSES) as Expenses,

SUM(LOSS) as Loss,

SUM("NET INCOME") as [Net Income]

Resident Dynamic_Data Group By "YEAR", "Quarter";

Drop Table Dynamic_Data;

Step_2:

Crosstable(Stage,Amount,2)

Load * Resident Step_1;

Drop Table Step_1;

Re: Waterfall chart in Qlik Sense

Thu, 17 Mar 2016 13:47:25 GMT

Thank you, very very much, Peter!

It works fine for me!