Skip to main content
Announcements
Global Transformation Awards! Applications are now open. Submit Entry
cancel
Showing results for 
Search instead for 
Did you mean: 
stefangegg
Contributor II
Contributor II

Waterfall: Negative Values shown as '0' and wrong

Hi,

I'm facing a somehow strange error in QlikView:

I'd like to show a Waterfall chart from one year to the next, displaying the countries which are "growth accretive" or "dilutive"...

Somehow, it works with 3 charts... haha - I think I don't need to figure out which problems I will have with that workaround.


The best thing would be, to have all bars combined in one chart... Well, somehow I managed to do so with the "Pick" Function using several dimensionalities in the chart (See screenshot, second chart)

It comes to an more or less good picture, except the negativ figures on the growth: They are drawed in the wrong direction and the number shows "0" and not a negative figure. On the axis, the right value is shown somehow.


I don't need to use the "pick" function as a solution, maybe one of you has better ideas to draw this in one chart?

Maybe you also know how to edit the existing chart to come to the desired chart?


Also, I'd like to keep the flexibilty to have more or less countries between these two FiscalYear-bars:I don't want to have an expression for each and evry country in the middle... that's why I went this way until now...


I also added the .qvw to let you have an insight how I implemented everything.


Many thanks for your help!

BR

Stefan


1 Solution

Accepted Solutions
settu_periasamy
Master III
Master III

Check the Attachment

View solution in original post

3 Replies
settu_periasamy
Master III
Master III

Check the Attachment

stefangegg
Contributor II
Contributor II
Author

Thank you so much, Settu! Never thaught the solution would be that simple and I was so close to the goal 🙂

Alll in all, I'm so happy to have this community here - everybody helps that fast and the community works so good (in terms of give and take!)

BR

Stefan

settu_periasamy
Master III
Master III

No problem at all 🙂