Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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

1 Solution

Accepted Solutions
Not applicable
Author

Thank you for your help,

the funktion CROSSTABLE solves the problem.

Stefan

View solution in original post

3 Replies
kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

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

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
Gabriel
Partner - Specialist III
Partner - Specialist III

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
Author

Thank you for your help,

the funktion CROSSTABLE solves the problem.

Stefan