2 Replies Latest reply: Apr 7, 2014 2:47 AM by Amit Saini RSS

    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