2 Replies Latest reply: Sep 9, 2015 9:32 AM by Mark Giles RSS

    Pivot a Line Graph

      Hi,

       

      Trying to create a Line chart that is pivoted to look like the below graph. How is this done in Qlikview?

       

      Desired output:

       

       

      Data source:

         

      Month 1Month 2Month 3Month 4Month 5Month 6
      Store1358578
      Store2466653
      Store3376744
      Store4229816
      Store5939317

       

      Thanks

       

      MVW

        • Re: Pivot a Line Graph
          liron baram

          hi

          in qlikview we'll use crosstable

          the will transform your table to

          table with those columns:

          Store,Month,Data

          store1,month1,2

          store1,month2,4

           

          and then create simple line chart with two dimensions

           

          attach is a demo model

            • Re: Pivot a Line Graph

              Hi,

               

              Thanks for that, but I'm not sure it takes me forward. Unless I am misunderstanding, your solution resolves the issue by restructering the data during the loading process. I was really looking to resolve the issue in the Graph interface. Is this possible? I can't amend my load process like yours:

               

              CrossTable(Month,Data,1)
              LOAD * INLINE [

               

              Mine is:

               

              LOAD A,
                   B,
                   C,
                   D,
                   E,
                   F,
              etc

               

              I think mine needs to stay in this format as there are many different data items in my spreadsheet (columns A-FF in Excel). I had simplified my data structure for the purposes of the messageboard.

               

              MVW