Discussion Board for collaboration on QlikView Layout & Visualizations.
I am trying to create a line chart out of the attached data. Really struggling due to the orientation of my excel file.
This should be easy just drawing a blank. Ideas?
CrossTable (FiscalYear, Value)
LOAD * Inline [
Project, FY2015, FY2016, FY2017
Proj1, 10, 40, 30
Proj2, 20, 20, 10,
Proj3, 20, 30, 40
Right(FiscalYear, 4) as Year
DROP Table Table;
How would I do this with and excel file?
(ooxml, embedded labels, table is Sheet1);
What are your settings for you chart?
Year and Project
I'm new so for the sake of simplicity, can you tell me why the Right function is being used here?
Right function indicates -- Year like 4 ( Why 4 Is here - YYYY, if you take 3 /2 /1 That is not good to see for users...)
That is the reason he mentioned RIGHT
No settings are there. Just he created Line chart with Calendar object ...