topic Re: Area Chart(or line chart) in chart table in QlikView

Area Chart(or line chart) in chart table

Fri, 11 Apr 2014 05:40:56 GMT

Hi All

Now I have a serious steps in Excel:

1. Original Table

Year	Product	Grade
2011	1	A
2011	2	A
2011	3	B
2011	4	B
2011	5	B
2011	6	C
2011	7	C
2011	8	C
2011	9	C
2010	10	A
2010	11	B
2010	12	B
2010	13	C
2010	14	C
2010	15	C
2009	16	A
2009	17	A
2009	18	A
2009	19	A
2009	20	B
2009	21	C

	2011	2010	2009
A	2	1	4
B	3	2	1
C	4	3	1
Total	9	6	6

	2011	2010	2009
A	22%	17%	67%
B	33%	33%	17%
C	44%	50%	17%
Total	100%	100%	100%

4.And Then I could insert a line chart:

And My question is How can I just load the original data from my data source and insert the final area chart directly?

Re: Area Chart(or line chart) in chart table

tresB — Fri, 11 Apr 2014 05:53:55 GMT

May be like attached sample?

Re: Area Chart(or line chart) in chart table

Fri, 11 Apr 2014 06:00:05 GMT

Thanks!

I would like to count the number of grade and get their % of total sample in one year, not sum of the product. The number of product just a mark....

Re: Area Chart(or line chart) in chart table

tresB — Fri, 11 Apr 2014 06:04:18 GMT

Change the expression accordingly. =Count(Grade)

Re: Area Chart(or line chart) in chart table

Fri, 11 Apr 2014 06:08:16 GMT

How can you get the % of the count(grade) of that year?

Re: Area Chart(or line chart) in chart table

tresB — Fri, 11 Apr 2014 06:09:42 GMT

Expression tab-> check 'Relative'

Re: Area Chart(or line chart) in chart table

Fri, 11 Apr 2014 06:12:28 GMT

Thanks so much!

Re: Area Chart(or line chart) in chart table

Fri, 11 Apr 2014 06:13:37 GMT

A further question....

How can I change the order of Y-Value?

I just try many time and could not find it....

Re: Area Chart(or line chart) in chart table

Fri, 11 Apr 2014 06:18:37 GMT

I follow your method to click the 'Relative', it seems that the % if of the whole sample not just for that specific year, so the accumulated area of the % is not 100%......

Re: Area Chart(or line chart) in chart table

tresB — Fri, 11 Apr 2014 06:20:41 GMT

Expression tab-> check 'Full Accumulation'

Re: Area Chart(or line chart) in chart table

Fri, 11 Apr 2014 06:27:20 GMT

I have tried but i doesn't work. I would like the final chart like this .....