6 Replies Latest reply: Feb 26, 2016 2:16 AM by kishore pandurangan

# Creating a Pivot Table

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

• ###### Re: Creating a Pivot Table

May be like attached qvw.

• ###### Re: Creating a Pivot Table

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

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

Thank you that was really helpful!

• ###### Re: Creating a Pivot Table

Check this qvw file..

I hope this is what you want.

Thank you

• ###### Re: Creating a Pivot Table

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.