Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

Bar Chart Expression Formula Help

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

DateTypePrice
3/6/2014H40.3
3/6/2014L37.2
3/7/2014H39.8
3/7/2014L36.5
3/8/2014H40.2
3/8/2014L38.2
3/9/2014H42.2
3/9/2014L40.1
2 Replies
Not applicable

Re: Bar Chart Expression Formula Help

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
Honored Contributor III

Re: Bar Chart Expression Formula Help

Hi Fleece ,

Please see the attachment.

Community Browser