topic Re: Line Chart in QlikView

Line Chart

Fri, 03 Jun 2016 18:24:36 GMT

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

Re: Line Chart

sunny_talwar — Fri, 03 Jun 2016 18:29:25 GMT

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;

Re: Line Chart

Fri, 03 Jun 2016 18:31:22 GMT

How would I do this with and excel file?

Re: Line Chart

sunny_talwar — Fri, 03 Jun 2016 18:36:54 GMT

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;

Re: Line Chart

Fri, 03 Jun 2016 18:46:24 GMT

What are your settings for you chart?

Re: Line Chart

sunny_talwar — Fri, 03 Jun 2016 18:47:38 GMT

Two dimensions

Year and Project

One expression

=Sum(Value)

Re: Line Chart

Sat, 04 Jun 2016 03:26:49 GMT

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

Anil_Babu_Samineni — Sat, 04 Jun 2016 07:51:28 GMT

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

Re: Line Chart

Anil_Babu_Samineni — Sat, 04 Jun 2016 07:52:31 GMT

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