Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Line Chart

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?

Thanks

~Norman Rea

8 Replies

Re: Line Chart

Script:

Table:

CrossTable (FiscalYear, Value)

LOAD * Inline [

Project, FY2015, FY2016, FY2017

Proj1, 10, 40, 30

Proj2, 20, 20, 10,

Proj3, 20, 30, 40

];

FinalTable:

LOAD *,

  Right(FiscalYear, 4) as Year

Resident Table;

DROP Table Table;


Capture.PNG

Not applicable

Re: Line Chart

How would I do this with and excel file?

Re: Line Chart

This:

Table:

CrossTable (FiscalYear, Value)

LOAD Project,

    FY2015,

    FY2016,

    FY2017

FROM

Community_219531.xlsx

(ooxml, embedded labels, table is Sheet1);

FinalTable:

LOAD *,

  Right(FiscalYear, 4) as Year

Resident Table;

DROP Table Table;

Not applicable

Re: Line Chart

What are your settings for you chart?

Re: Line Chart

Two dimensions

Year and Project

One expression

=Sum(Value)

Not applicable

Re: Line Chart

Hi Sunny,

I'm new so for the sake of simplicity, can you tell me why the Right function is being used here?

Thanks,

Re: Line Chart

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

Life is so rich, and we need to respect to the life !!!

Re: Line Chart

No settings are there. Just he created Line chart with Calendar object ...

Life is so rich, and we need to respect to the life !!!
Community Browser