Discussion Board for collaboration on QlikView Layout & Visualizations.
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|
Your assistance is appreciated.
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.
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.