topic Re: Water Fall chart Direction in QlikView

Water Fall chart Direction

Wed, 22 Oct 2014 16:21:51 GMT

Hi All,

Currently I am getting a water fall chart bottom to Top as shown follows. Actually I Require Top to Bottom. I am using the expression in Bar Offset is "=sum(total [Value]) - sum([ Value])- rangesum(Above(sum([Value]),1,RowNo()-1)) " and in chart expression is sum([Value]).How can change this bars direction to top to bottom instead of bottom to top?

Thank you All

Re: Water Fall chart Direction

Anonymous — Wed, 22 Oct 2014 16:30:52 GMT

Just add the same expression you use in the chart in the calculated expression in order tab, and select descendent order.

Marc.

Re: Water Fall chart Direction

Wed, 22 Oct 2014 16:46:40 GMT

I require this w r t Dimension.Dimension Order has been changed. Actually Previously I used that calucated expression in the sorting for a dimension

Re: Water Fall chart Direction

Wed, 22 Oct 2014 17:57:12 GMT

Its working after multiplying Bar offset expression with -1

Thank you

Ramgopal

From: Bollimultha, Ramgopal

Sent: Wednesday, October 22, 2014 10:16 PM

To: 'jive-991354505-3bof-2-dpq1@qliktech-public.hosted.jivesoftware.com'

Subject: RE: - Water Fall chart Direction

I require this w r t Dimension.Dimension Order has been changed. Actually Previously I used that calucated expression in the sorting for a dimension