topic Re: Bar Chart Expression Formula Help in QlikView

Bar Chart Expression Formula Help

Sun, 06 Apr 2014 18:13:08 GMT

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

Re: Bar Chart Expression Formula Help

Mon, 07 Apr 2014 06:14:16 GMT

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

Re: Bar Chart Expression Formula Help

amit_saini — Mon, 07 Apr 2014 06:47:49 GMT

Hi Fleece ,

Please see the attachment.