3 Replies Latest reply: Mar 15, 2013 8:07 AM by Stefan Bauer RSS

    Generating Line Chart from Excel and like Excel

      Hi,

       

      i tried to publish Excel data in QlikView in the same way as the Excel line chart. I found no way to generate fix colums for every year in Qlikview like in Excel. Excel.PNG

      The only way i found is to display the data when converting the Excel source in the following way. Then the you can define the x-axis as "YEAR" and the it works.

      Unbenannt.PNG

       

      But I don't want to change the original Excel file source. Has anybody a idea for a solution? Perhaps it's easy, but I started evaluating QlikView yesterday.

       

      Best regards,

       

      Stefan