6 Replies Latest reply: Jul 31, 2017 2:58 AM by Max Ålander RSS

    Field headers as row values

    Max Ålander

      Hi,

      I've set up a connection between Mixpanel and Qlik through the Qlik REST Connector. I've successfully managed to create the connection and autogenerated a script. This gives me the data I'm after, but in a format that is difficult to handle when trying to visualise the data.

       

      Right now the data is in the following format

      2017-05-012017-05-022017-05-032017-05-04
      500400350640

       

      but I actually want it in this format.

      DateValue
      2017-05-01500
      2017-05-02

      400

      2017-05-03350
      2017-05-04640

       

      I'm new to Qlik and I have trouble understanding how I can reformat this data into the wanted format. I've attached the autogenerated Load Script and put a comment by next to the table of interest.


      If you need more information I'm happy to explain my issues further.

      Thank you for your time! !