topic Line Graph in Chart in QlikView

Line Graph in Chart

Thu, 12 Dec 2013 16:24:34 GMT

Hi all,

I want to create a LINE graph. I have the below data.

Locality	Costs	Period
A	100	Nov-13
B	200	Oct-13
C	300	Sep-13
D	400	Aug-13
E	500	Jul-13
F	600	Jun-13

I want to see a line graph with "Period" on X-axis and "Locality" on Y-axis. "Costs" should be the LINE on the graph. In other words, I want to see the costs for all localities as LINES, for a particular period. Is that be possible. If yes, Could you please let me know how to do it ?

Thanks

Re: Line Graph in Chart

Thu, 12 Dec 2013 16:32:05 GMT

Hi Prakash

open a chart object and choose "line chart'

set Period and Locality as dimensions and sum(Costs) as expression

you'll get this

Best regards

Chris

Re: Line Graph in Chart

Thu, 12 Dec 2013 16:50:50 GMT

Thanks Christian!

Its working fine.