Discussion Board for collaboration on QlikView Scripting.
as you can see on the screenshot,
is it somehow possible to make a table to look like that?
To have a sum of hours, based on week dimension, and to be shown as on screenshot?
Go to Solution.
Yes, Use a Pivot Table
Any way not to use pivot?
Compute all the partial sum in the script and show in the table (... a complex solution)
Yes, use a pivot table because to show weekdays as horizontal you required slicing/dicing feature of Pivot table.