Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 |
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
Hi Fleece ,
Please see the attachment.