Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator III
Creator III

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 ?

   

SupplierShop 1Shop 2Shop 3Shop 5TotalTotal Prediction
Docs2000200024000
Ottos1000100012000
Peoples3000300036000
Peters Paper4000400048000
Vans1000100012000
Williams Plastics5000500060000

Your assistance is appreciated.

1 Solution

Accepted Solutions
Highlighted
MVP
MVP

May be like attached qvw.

View solution in original post

6 Replies
Highlighted
MVP
MVP

May be like attached qvw.

View solution in original post

Highlighted
Creator III
Creator III

Check this qvw file..

I hope this is what you want.

Thank you

Highlighted
Creator III
Creator III

Hi Treseco

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

Highlighted
MVP
MVP

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.

Highlighted
Partner
Partner

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.

Highlighted
Creator III
Creator III

Thank you that was really helpful!