Discussion Board for collaboration on QlikView Layout & Visualizations.
I can't seem to get totals into my pivot chart.
I'm looking for this result:
In my example I've added 3 days, but it should be possible to show every day of the year.
For the column Tot Act. Hr I'm trying to add a calculated dimension - but I'm not getting the calculation right.
Can anyone help me out?
Go to Solution.
You need to use the aggr function in the calculated dimension. See attached qvw.