20 Replies Latest reply: Aug 25, 2014 8:42 AM by Jonathan Dienst RSS

    How to create a candlestick chart???

      I am a starter to use qlikview, plz give a suggestion to me in order to make a candlestick chart.

       

      I have such excel file

      TIMELAST
      09:14:29.52855122951
      09:15:29.61429322961
      09:15:29.63911922968
      09:15:29.64110122951
      09:15:29.87834622975
      09:15:29.88207822978
      09:15:29.88409822979
      09:15:30.00722022965
      09:15:30.02421622980
      09:15:30.02697822979
      09:15:30.10520922980
      09:15:30.23606622967
      09:15:30.32218722978
      09:15:30.37222722980
      09:15:30.51226022983
      09:15:30.74206622970
      09:15:30.74407222963
      09:15:30.95900122970
      09:15:31.11022622968
      09:15:31.12811822967
      09:15:31.53021522967
      09:15:32.20026322964
      09:15:32.41614522956
      09:15:32.76826522970
      09:15:33.35635122959
      09:15:33.42338522960
      09:15:33.74231722954
      09:15:34.53332022954
      09:15:34.82932022955

       

      I wanna return it into like this in period of one min.

      123.png

       

      I don't know how to write the expression in order ti generate this chart.