topic Re: Line Chart in QlikView

Line Chart

Tue, 13 Sep 2011 03:53:34 GMT

Hello Everyone,

I want to make a multiple line chart. I have the data structured in the following way for 5 channels for 8 months:

Channel_1_Month_1_Sales
Channel_2_Month_1_Sales
Channel_3_Month_1_Sales

Channel_1_Month_2_Sales
Channel_2_Month_2_Sales
Channel_3_Month_2_Sales

Channel_1_Month_3_Sales
Channel_2_Month_3_Sales
Channel_3_Month_3_Sales

.
.
.
.

I would like to plot this in the form of a line chart so that the user can see the trend monthwise for each channel...screenshot attached (done in excel)

Any ideas?

Thanks

Re: Line Chart

its_anandrjs — Tue, 13 Sep 2011 04:35:33 GMT

Hi,

Yes it is possible put Channel in X-axis and months in Y-axis and set the chart as type line chart and it will created as you discribe.

HTH

Regards

Anand

Re: Line Chart

its_anandrjs — Tue, 13 Sep 2011 04:45:36 GMT

Hi,

See the attached sample file.

HTH

Regards

Anand

Line Chart

Wed, 14 Sep 2011 04:18:51 GMT

Hi Anand,

Thank you for your response.

What i was looking for is different. I have the data in the structure i have mentioned, i do not have separate variables for channels and months.

Any thoughts?

Thanks

Re: Line Chart

its_anandrjs — Wed, 14 Sep 2011 05:07:15 GMT

Hi,

See the attached sample file.

Ok i understood you want to create with this type of data

Channel_1_Month_1_Sales
Channel_2_Month_1_Sales
Channel_3_Month_1_Sales

Channel_1_Month_2_Sales
Channel_2_Month_2_Sales
Channel_3_Month_2_Sales

Channel_1_Month_3_Sales
Channel_2_Month_3_Sales
Channel_3_Month_3_Sales

but there is no value to show so i do one thing add a Value column and create a chart by this code

Temp:

LOAD * INLINE

[

Data ,Value

Channel_1_Month_1_Sales,100

Channel_2_Month_1_Sales,400

Channel_3_Month_1_Sales,700

Channel_1_Month_2_Sales,200

Channel_2_Month_2_Sales,500

Channel_3_Month_2_Sales,800

Channel_1_Month_3_Sales,300

Channel_2_Month_3_Sales,600

Channel_3_Month_3_Sales,900

];

Load

Left(Data,9) as Channels,

Mid(Data,11,7) as Months

Resident Temp;

Drop table Temp;

By the Left and Mid we need to fetch the fields and create two fields.

Let me know about this

HTH

Regards

Anand

Re: Line Chart

its_anandrjs — Wed, 14 Sep 2011 05:12:37 GMT

Hi,

See the next updated file.

Regards

Anand

Re: Line Chart

rohit214 — Wed, 14 Sep 2011 05:39:48 GMT

pls check the attached one

thanks rohit