topic Line chart help and data modelling help in QlikView

Line chart help and data modelling help

Anonymous — Mon, 22 May 2017 18:27:38 GMT

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 1	Header 2	Header 3	Header 4
Campus	January customers	February customers	March customers
East	8	12	34
South	4	3	6

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.

Re: Line chart help and data modelling help

sergio0592 — Mon, 22 May 2017 18:36:22 GMT

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

Re: Line chart help and data modelling help

Digvijay_Singh — Mon, 22 May 2017 19:28:45 GMT

Like this may be -

Re: Line chart help and data modelling help

Anonymous — Mon, 22 May 2017 20:11:12 GMT

yes Thats the way i want it to look like.

Re: Line chart help and data modelling help

Digvijay_Singh — Mon, 22 May 2017 20:19:22 GMT

Have you got what you needed in the file attached?