topic Re: Can't handle Negative Value in Waterfall chart in QlikView

Can't handle Negative Value in Waterfall chart

Anonymous — Thu, 23 Mar 2017 18:31:00 GMT

Hi Everyone,

I need help to develop waterfall chart with negative values, chart structure change wherever we get the negative value.It will not be able combine /merge/stacked all the value for the country with the negative value

Re: Can't handle Negative Value in Waterfall chart

vishsaggi — Thu, 23 Mar 2017 18:50:23 GMT

Try this in your Bar OffSet Amt1 expr:

= IF(sum(Amt1) > 0, Sum(offset))

Re: Can't handle Negative Value in Waterfall chart

sunny_talwar — Thu, 23 Mar 2017 19:24:03 GMT

Not sure why it works, but it seems to work

Added a bar offset on Amt3 expression

-Sum(offset)

Re: Can't handle Negative Value in Waterfall chart

Anonymous — Fri, 24 Mar 2017 03:54:30 GMT

your output is quite wrong.This is not the required output as shared by you

See the attachment of output in your application

Re: Can't handle Negative Value in Waterfall chart

Anonymous — Fri, 24 Mar 2017 03:59:11 GMT

If I do so then this chart will not be a waterfall chart anymore.See the output shared by you

Re: Can't handle Negative Value in Waterfall chart

Anonymous — Fri, 24 Mar 2017 04:01:52 GMT

Position of Amt1 for Greece should be same and Amt2 and Amt3 should be combine with Amt1 as in other bars

Re: Can't handle Negative Value in Waterfall chart

Anil_Babu_Samineni — Fri, 24 Mar 2017 04:20:51 GMT

This?

Re: Can't handle Negative Value in Waterfall chart

Anonymous — Fri, 24 Mar 2017 04:22:04 GMT

yes hope u haven't apply the fabs function ,as we can't change the value

Re: Can't handle Negative Value in Waterfall chart

Anil_Babu_Samineni — Fri, 24 Mar 2017 04:32:55 GMT

I don't think Whether we have that control in Waterfall chart. May be work around with two objects? Your customers likes work around?

May be marcowedel‌

Re: Can't handle Negative Value in Waterfall chart

Anonymous — Fri, 24 Mar 2017 04:38:38 GMT

please share what you have done

Re: Can't handle Negative Value in Waterfall chart

Anonymous — Fri, 24 Mar 2017 05:06:34 GMT

Any one have the reason for the same why it is behaving like this with negative values

Re: Can't handle Negative Value in Waterfall chart

sunny_talwar — Fri, 24 Mar 2017 08:57:12 GMT

Wait are you not seeing this when you open the app?

I have not used fabs function here... I am not sure what the issue is?

Re: Can't handle Negative Value in Waterfall chart

Anonymous — Fri, 24 Mar 2017 11:23:32 GMT

can share ur app

Re: Can't handle Negative Value in Waterfall chart

sunny_talwar — Fri, 24 Mar 2017 11:30:26 GMT

Attached here already:

Re: Can't handle Negative Value in Waterfall chart