topic Re: Creating a Pivot Table in QlikView

Creating a Pivot Table

rido1421 — Fri, 26 Feb 2016 06:56:34 GMT

Hi There

I am trying to create a pivot table and using the totals from the expression I would like to do a calculation

what would be the simplest way to do this.

Total is the Partial sums of the dimension "Factory" , Total Prediction is the total/1*12 , for Docs (2000/1*12=24000)

how can I do this in Qlikview ?

Supplier	Shop 1	Shop 2	Shop 3	Shop 5	Total	Total Prediction
Docs			2000		2000	24000
Ottos		1000			1000	12000
Peoples				3000	3000	36000
Peters Paper		4000			4000	48000
Vans	1000				1000	12000
Williams Plastics				5000	5000	60000

Your assistance is appreciated.

Re: Creating a Pivot Table

tresB — Fri, 26 Feb 2016 07:11:58 GMT

May be like attached qvw.

Re: Creating a Pivot Table

Anonymous — Fri, 26 Feb 2016 07:13:56 GMT

Check this qvw file..

I hope this is what you want.

Thank you

Re: Creating a Pivot Table

rido1421 — Fri, 26 Feb 2016 07:27:19 GMT

Hi Treseco

This is exactly what im trying to do, but how do you manage to prevent the totals from appearing under each column ?

Re: Creating a Pivot Table

tresB — Fri, 26 Feb 2016 07:42:48 GMT

If you pull a dimension across to top it's corresponding partial sum would appear as a column rather than a row (under all columns). The trick for the second total column lies in the additional blank dimension (check the dimension tab) that is pulled across. Hope this helps.

Re: Creating a Pivot Table

susovan — Fri, 26 Feb 2016 07:52:35 GMT

I have done the partial Total sum of factory dimension and also add the Total prediction.

But the problem is that individual Total predication column add for the each shop due to the pivoting.

Please check this attachment for the .qvd files.

Re: Creating a Pivot Table

rido1421 — Fri, 26 Feb 2016 08:51:57 GMT

Thank you that was really helpful!