Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
ToniKautto
Employee
Employee

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/

View solution in original post

8 Replies
alex_nerush
Partner - Creator II
Partner - Creator II

I think you need to build extension

Not applicable
Author

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.

ToniKautto
Employee
Employee

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
Luminary Alumni
Luminary Alumni

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

raju_insights
Partner - Creator III
Partner - Creator III

Not applicable
Author

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
Author

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
Author

Thank you, very very much, Peter!

It works fine for me!