Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

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

Tags (2)
1 Solution

Accepted Solutions
Not applicable

Re: Generating Line Chart from Excel and like Excel

Thank you for your help,

the funktion CROSSTABLE solves the problem.

Stefan

3 Replies

Re: Generating Line Chart from Excel and like Excel

Hi Stefan,

     Create a new field which is a combination of Baureihe and Werk.

     Like shown below.

     Load Baureihe&' '& Werk as New_Field,

              Baureihe,

              Werk,

              Year,

              Amount

     From XYZ;

     Now create Bar Chart with two dimensions.

     1. Year

     2. New_Field

     and expression as

     Sum(Amount)

     Change style to Stake chart.

Regards,

Kaushik Solanki

Gabriel
Valued Contributor II

Re: Generating Line Chart from Excel and like Excel

Hi,

To my mind what I would do during importing of the Excel file is to use TRANSFORMATION.

With transformation you load the data into QV as you wanted.

Let me know if this helps

Regards,

gabriel

Not applicable

Re: Generating Line Chart from Excel and like Excel

Thank you for your help,

the funktion CROSSTABLE solves the problem.

Stefan

Community Browser