topic Pivot table issue in QlikView

Pivot table issue

Sat, 20 Sep 2014 06:44:18 GMT

Dear All,

Greetings.

There is a year and month wise data

Year	Month	Material	qty
2013	jan	`A	1
2013	feb	B	7
2013	mar	B	8
2013	jan	A	9
2013	feb	A	10
2013	mar	A	11
2014	jan	B	12
2014	feb	B	13
2014	mar	A	18
2014	jan	B	21
2014	feb	A	22
2014	mar	A	23

The user wants it in following format:

	Year	2013			2014			Avg Qty
Material	Month	feb	jan	mar	feb	jan	mar	Avg Qty
A		10	10	11	22	-	41	15.67
B		7	-	8	13	33	-	10.17

Is this extra column of 'Avg Qty' can be added without any year and month segregation? If yes, then how?

Pls Suggest.

Attaching herewith qvw for your reference.

Re: Pivot table issue

ecolomer — Sat, 20 Sep 2014 08:47:54 GMT

This is not you need bud ...

Re: Pivot table issue

Sat, 20 Sep 2014 09:58:32 GMT

Thanks Enrique Colomer for your reply.

But the requirement is to add three more columns like 'Avg Qty', 'Stock in Hand', 'Avg Consumption' which shall show their total value regardless of Year And Month.

	Year	2013			2014			Avg Qty	Stock in Hand	Avg Consumption
Material	Month	jan	feb	mar	jan	feb	mar	value	value	value
A		10	10	11	-	22	41	value	value	value
B		-	7	8	33	13	-	value	value	value

Re: Pivot table issue

PrashantSangle — Sat, 20 Sep 2014 10:08:29 GMT

Hi,

There is some limitation of Qlikview.

One of that is you can not add Expression after Dimension.

So If possible Find Some alternative Solution.

Regards

Re: Re: Pivot table issue

Anonymous — Sun, 21 Sep 2014 09:51:23 GMT

take a look at this

Re: Pivot table issue

preminqlik — Sun, 21 Sep 2014 11:22:46 GMT

find attachment , hope this helps you

Re: Pivot table issue

Sun, 21 Sep 2014 11:53:44 GMT

Hope this will help you