topic Re: how to prepare chart ? in QlikView

how to prepare chart ?

Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

could you please help me to prepare below chart.

SAMPLE DATA IS :

	Year 1	Year 2	Year 3	Year 4	Year 1	Year 2	Year 3	Year 4
CUMULATIVE	ORDERS	ORDERS	ORDERS	ORDERS	SALES	SALES	SALES	SALES
A	25,963	42,790	56,874	71,190	20,33,639	34,64,726	45,06,359	54,38,038
B	30,713	55,680	75,977	92,477	18,59,421	39,82,751	54,83,717	65,44,741
C	29,761	47,149	61,694	76,258	23,12,625	37,64,714	48,22,920	57,60,811
D	32,200	56,872	75,777	90,262	18,27,132	38,87,611	52,60,487	61,75,222
E	33,957	57,362	77,405	96,898	23,29,230	43,15,457	57,94,804	70,57,418
F	33,529	61,274	84,233	1,03,231	17,76,450	41,30,963	58,25,161	70,44,225

Re: how to prepare chart ?

Anil_Babu_Samineni — Mon, 26 Sep 2016 16:03:47 GMT

Would you provide the Excel?

Re: how to prepare chart ?

sunny_talwar — Mon, 26 Sep 2016 16:26:59 GMT

Sales and Orders are on the same chart? Wouldn't that be too confusing?

Re: how to prepare chart ?

sudeepkm — Mon, 26 Sep 2016 17:26:18 GMT

you might try using a trellis chart for multiple products but you have to either split axis or present Orders and Sales separately as their scale varies. Given below are snapshot of both.

with Split Axis: