topic Issues Graphing Data in QlikView

Issues Graphing Data

Mon, 23 Mar 2015 13:46:38 GMT

I am trying to create a chart that will display the data in the test csv I attached. Essentially the data is column headers with people's names and the row headers are dates. For each day there is a number associated with the person. I am trying to create a bar graph that can be selectable for different people's names so you can switch between individuals. Anyone have a hint as to how to do that?

Re: Issues Graphing Data

prieper — Mon, 23 Mar 2015 14:07:45 GMT

Think that conversion into a Crosstable might help:

Data:

CROSSTABLE (Person, Number, 1) LOAD

LOAD DATE(DATE#(Date, 'M/D/YYYY')) AS Date,

[Person 1],

[Person 2],

[Person 3]

FROM

.\Test_Date.csv

(txt, codepage is 1252, embedded labels, delimiter is ',', msq);

and then make an ordinary bar-graph with Date and Person as Dimension and SUM(Number) as expression.

HTH

Peter

Re: Issues Graphing Data

stigchel — Mon, 23 Mar 2015 14:12:03 GMT

You can use the crosstable load for the persons. You can make selections in the dimension in the chart, I've used a conditional dimension to display the dates when you select a person. See example attached.

Re: Issues Graphing Data

Mon, 23 Mar 2015 14:36:14 GMT

Thanks for the help!!