topic Re: Generating Line Chart from Excel and like Excel in QlikView

Generating Line Chart from Excel and like Excel

Mon, 11 Mar 2013 08:23:15 GMT

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.

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.

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

Re: Generating Line Chart from Excel and like Excel

kaushiknsolanki — Mon, 11 Mar 2013 08:41:06 GMT

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

Re: Generating Line Chart from Excel and like Excel

Gabriel — Wed, 13 Mar 2013 10:09:22 GMT

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

Re: Generating Line Chart from Excel and like Excel

Fri, 15 Mar 2013 12:07:42 GMT

Thank you for your help,

the funktion CROSSTABLE solves the problem.

Stefan