Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

cancel
Showing results for 
Search instead for 
Did you mean: 
pmanu4112
Contributor III
Contributor III

Line chart help and data modelling help

Hello experts i have a modelling question or creating a chart question to help me visualize my better in a better way.

This is how the table looks now.

Header 1Header 2Header 3Header 4
CampusJanuary customersFebruary customersMarch customers
East81234
South436

End product:

I want to create a line chart by month, by campus to show a trending line for the months. That means i want to have two lines that are connected, one will show the East zone and the other one will show a south zone.

Thank you experts for all the help.

1 Solution

Accepted Solutions
Digvijay_Singh

Like this may be -

Capture.PNG

View solution in original post

4 Replies
sergio0592
Specialist III
Specialist III

You can use CrossTable prefix with :

New_table:

Crosstable (Month, Expression) LOAD Campus, [January customers],[February customers],[March customers]

resident Table1;

DROP Table Table1;

The Crosstable Load

Digvijay_Singh

Like this may be -

Capture.PNG

pmanu4112
Contributor III
Contributor III
Author

yes Thats the way i want it to look like.

Digvijay_Singh

Have you got what you needed in the file attached?