Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
sunny_talwar

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
Author

How would I do this with and excel file?

sunny_talwar

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
Author

What are your settings for you chart?

sunny_talwar

Two dimensions

Year and Project

One expression

=Sum(Value)

Not applicable
Author

Hi Sunny,

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

Thanks,

Anil_Babu_Samineni

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

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Anil_Babu_Samineni

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

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)