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

Water Fall chart Direction

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?

temnp.png

Thank you All

3 Replies
Anonymous
Not applicable
Author

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

Marc.

Not applicable
Author

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

Not applicable
Author

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