Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Not applicable

Waterfall chart in Qlik Sense

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

1 Solution

Accepted Solutions
Employee
Employee

Re: Waterfall chart in Qlik Sense

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/

8 Replies
alex_nerush
Contributor II

Re: Waterfall chart in Qlik Sense

I think you need to build extension

Not applicable

Re: Waterfall chart in Qlik Sense

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.

Employee
Employee

Re: Waterfall chart in Qlik Sense

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/

pablolabbe
Valued Contributor II

Re: Waterfall chart in Qlik Sense

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

raju_insights
Contributor III

Re: Waterfall chart in Qlik Sense

Not applicable

Re: Waterfall chart in Qlik Sense

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!!

Not applicable

Re: Waterfall chart in Qlik Sense

Hi Douglas,

This worked for me:

  1. Include all of the fields you want to use to filter in the load of Step_1
  2. Specify all filtering fields in the group by syntax of Step_1.
  3. 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;

Not applicable

Re: Waterfall chart in Qlik Sense

Thank you, very very much, Peter!

It works fine for me!

Community Browser