Help with Line chart

Wed, 09 Mar 2011 09:39:32 GMT

Hi,

I am very new in QV. Please help me like a newby to create the following desired chart result which is very easy in Excel but i have no idea how to do it in QV.

The main data sheet is as below:

User Status	Uptill_Dec	Uptill_Jan11	Uptill_Feb11
In Production	1	1	1
In Production	1	0	1
In Production	1	0	0
Not in Production	1	1	1
In Production	1	1	0
In Production	1	0	0
In Production	1	1	0
In Production	0	1	1
Not in Production	0	1	1
In Production	1	1	1
In Production	1	1	0
Not in Production	1	1	1

first I have to calculate percentage like below:

User status	Uptill_Dec	Uptill_Jan11	Uptill_Feb11
In Production	83.33%	75%	58.33%
Not in Production	16.67%	25%	41.67%

Then have to represent it in line chart as attached.

Thanks & KRs/

Asad

topic Help with Line chart in QlikView

Help with Line chart