9 Replies Latest reply: Jun 22, 2016 4:36 PM by Ivan Baumann Fonay RSS

    Working with time series

    Ivan Baumann Fonay

      Hi

       

      I'm new with QlikSense and I want to use it to analyse time series data. In particular, I have the data in two tables: One with a seriesID and the description, and another with the seriesID, the date and the value. Both tables are related by the series ID


      I can't seem to make a simple chart or a gauge. I just wanto to graph the series, it shouldn't be that difficult but I can't find the way. I do not understand what I should put as dimension and as measure in the chart. For instance, I would like to graph the value against the date, but I can't select any of them. When I choose them QlikSense wants to sum them, or count, etc.

       

      I would also like a gauge that shows me the last value of a series, but again, I can only sum or count them.

       

      Any help will be very appreciated.