9 Replies Latest reply: Feb 11, 2015 11:32 AM by Stephan Spiegeleire RSS

    Timeseries in Excel - how to properly import

      I have a spreadsheet in Excel with monthly data for 14 variables. I have them in two different formats in two different worksheets:

      Header 1Header 2Header 3Header 4Header 5
      Month 1Month 2Month 3etc.
      Variable 1543464
      Variable 2783994
      etc.

      and

      Header 1Header 2Header 3
      DateValues
      Variable 1Month 154
      Variable 1Month 234
      etc.etc.etc

      Variable 2

      Month 1

      78
      Variable 2Month 239
      etc.etcetc.

      What I want to get out of it is something like this (this one is from Tableau, but I hope to create something similar in Qlikview - because I like the app/stroytelling idea. Can somebody help me? I'm also attaching the excel spreadhseet itself.

      Thanks in advance!

       

      -Stephan