topic Re: pivot table in QlikView

pivot table

upaliwije — Wed, 01 Jul 2015 02:41:21 GMT

Hi Dear Friends

I have created the following Pivot Table from Data model

	DEPT	Dept 1			Dept 2
MONTH	PRD	Nos	Amount	Per Unit Cost	Nos	Amount	Per Unit Cost
May	A	2,000	100,000	50	1,500	250,000	167
May	B	1,000	300,000	300	2,500	175,000	70
May	Total	3,000	400,000	133	4,000	425,000	106
Jun	A	3,000	400,000	133	1,400	350,000	250
Jun	B	4,000	250,000	63	1,700	200,000	118
Jun	Total	7,000	650,000	93	3,100	550,000	177
Difference	A	1,000	300,000		-100	100,000
	B	3,000	-50,000		-800	25,000
	Total	4,000	250,000		-900	125,000

125,000

I want to add the calculation marked in red to my pivot table. Kindly let me know where there is any way to do this

Re: pivot table

sunny_talwar — Wed, 01 Jul 2015 02:49:54 GMT

Can you share a sample qvw document?

Re: pivot table

qlikviewwizard — Wed, 01 Jul 2015 03:28:50 GMT

Hi upaliwije,

Your provided data is very confusing. Can you attach the sample qvw with sample data. So that it will help us better understanding the issue and to provide the efficient solution by our folks.

Re: pivot table

timanshu — Wed, 01 Jul 2015 10:25:34 GMT

Hi UPALI,

This can be possible in modeling. Kindly share the data if you would like to do it that way.