Discussion Board for collaboration on QlikView Scripting.
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.
Go to Solution.
Thank you for your help,
the funktion CROSSTABLE solves the problem.
Create a new field which is a combination of Baureihe and Werk.
Like shown below.
Load Baureihe&' '& Werk as New_Field,
Now create Bar Chart with two dimensions.
and expression as
Change style to Stake chart.
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