topic Re: Crosstable Line Chart in QlikView

Crosstable Line Chart

Fri, 31 Oct 2014 14:50:12 GMT

Hello,

Looking for some guidance here, I'd like to create a line chart off of a crosstable so as to make my headers selectable: (if this isn't the best method please advise!). So below is an example of my data, i have dates corresponding to values for a number of different projects. I initially loaded this in as a table regularly (no crosstable) and set my dimension to date and had 3 expressions for my projects, however I discovered that when I clicked on a particular project in list view it didn't isolate that project on my line chart. I figured by loading it once again, but this time as a cross table it would solve my problem - but again unfortunately no luck.

Date	Project1	Project2	Project3
01/01/2014	200	300	250
01/08/2014	150	400	100
01/15/2014	165	320	155

Looking for any help.

Cheers,

Ahmad

Re: Crosstable Line Chart

MK_QSL — Fri, 31 Oct 2014 14:55:33 GMT

CrossTable(Project, Value)

Load

Date(Date#(Date,'MM/DD/YYYY')) as Date,

Project1,

Project2,

Project3

Inline

[

Date, Project1, Project2, Project3

01/01/2014, 200, 300, 250

01/08/2014, 150, 400, 100

01/15/2014, 165, 320, 155

];

Create a Line Chart

Dimension

Date

Project

Expression

SUM(Value)

Re: Crosstable Line Chart

Fri, 31 Oct 2014 14:59:24 GMT

thank you !!!!

Re: Crosstable Line Chart

MK_QSL — Fri, 31 Oct 2014 15:01:32 GMT

IF this is working for you, kindly close the thread by selecting correct/helpful answer...

Thanks