Bar Chart Expression Formula Help

[#1]

I have the below data I am trying to make a bar chart with.  I am using the Date as the Dimension.  Type H=High price for the day.  Type L = Low price for the day.  How do I write an expression for the top of the bar chart since it is dependent on what the Type column is?  I have watched the following video but my data structure is a bit different.  Thanks.

QlikView | CandleStick Chart or Box Plot Chart - YouTube

Date	Type	Price
3/6/2014	H	40.3
3/6/2014	L	37.2
3/7/2014	H	39.8
3/7/2014	L	36.5
3/8/2014	H	40.2
3/8/2014	L	38.2
3/9/2014	H	42.2
3/9/2014	L	40.1

[#2]

In Barchart,

Take 2 dimensions

1. Date

2. Type

Expression : =Sum(Price)

Note: It would be better to post your expected result aswell to help better

[amit_saini]

Hi Fleece ,

Please see the attachment.