Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

Question about Stacked Waterfall chart

Hey everyone,

Using the tips from other discussions/questions, I am attempting to put together a waterfall chart.

Having some trouble getting the "offset" columns to stick together -- as in the various dimensions making up the stacked column appear to disconnect (Image 1). Also -- wondering how to get the dollar amount labels broken out as 3 individual labels per column (Parts, Mods, Total).

Image 1:

Bad Qlik Waterfall.png

My desired result is a chart that looks similar to the one below.

Good Waterfall example.png

Thanks in advance for the help!!!

1 Solution

Accepted Solutions
Highlighted
Specialist
Specialist

Hello, Brian!

My apologize for delay with answer!

I've created a classic waterfall chart on your model. It means that for each next bar offset depends on previous bar value (there is no bars at the middle of the chart with hardcoded offset 0).

In that approach you may see that the last bar is not reaching the zero (for 1 quarter it is, but for the second it's not).

If you want to tie some bar to zero value - just comment the calculation offset in the first expression for wanted bar.

PFA.

P.S.: I've let myself to turn your table view into a camomile 😃

View solution in original post

5 Replies
Highlighted
Specialist
Specialist

Hello, Brian!

Your project is great!

In case of creating a waterfall chart (with total sums) it may be a tough task without some aggregation steps.

I'm offering you to aggregate your tables and change a chart construction methods.

If it's possible, then you may find some usefull things in the attached file.

(There is a chart on aggregated values. And we a lucky that total sums are regarded for those values which don't have an offset. Otherwise "Show Value" wouldn't make a sense)

Highlighted
Not applicable

Hey Sergey,

Thank you for your helpful post!

Just looked at your .qvw, and the waterfalls look great.

Like you, I am thinking that my table structure is making it hard to create waterfalls. Specifically, the multiple cross-table loads joined on multiple synthetic keys. Not sure what the best solution would be (concat/type of join?) -- but would definitely be open to changing the table structure and chart methods.

Looking forward to hearing your insight!

Thanks,

Brian

Highlighted
Not applicable

Also -- noticed that for the "orders" field -- you had 0 hardcoded in for one of the categories (parts/mods). When I changed it to a positive integer --- it threw the chart off a bit. Any idea on how to fix this?

Highlighted
Specialist
Specialist

Hello, Brian!

My apologize for delay with answer!

I've created a classic waterfall chart on your model. It means that for each next bar offset depends on previous bar value (there is no bars at the middle of the chart with hardcoded offset 0).

In that approach you may see that the last bar is not reaching the zero (for 1 quarter it is, but for the second it's not).

If you want to tie some bar to zero value - just comment the calculation offset in the first expression for wanted bar.

PFA.

P.S.: I've let myself to turn your table view into a camomile 😃

View solution in original post

Highlighted
Not applicable

Hey Sergey,

Thank you very much! I apologize for the double post about making the stacked columns stick together for each dimension. Will go through both answers (yours for this question, and the answer to my other post) and attempt to learn what both of you did. Thanks again, this is great!

-Brian

P.S. Your chamomile looks great