topic Re: Creating totals from list box selection in QlikView

Creating totals from list box selection

Fri, 23 Aug 2013 13:58:19 GMT

Hi,

I'm new to qlikview and designing, having assumed the responsibility after a colleague left the company. I have a question regarding creating totals for a multibox selection.

I created a pivot table chart with dimensions of Employee Name, Month and Date and I'm able to get totals by employee for the selected date range but how to I get totals for an multibox selection? So If I choose Manager, it will show all the employee data for those assigned to that manager plus a total, or some sort of footer section with totals for that selection of manager.

Thank you for the help in advance.

Brian

Re: Creating totals from list box selection

Oleg_Troyansky — Fri, 23 Aug 2013 21:42:04 GMT

Brian,

I think you are confusing Selections with the Chart Dimensions. If the chart has dimensions Employee Name, Month and Date, then you can request subtotals ("Partial Sums" in the Presentation Tab), for those three levels.

So, maybe the missing piece is that you need to request a "Partial Sum" for the Employee dimension, and that will generate the overall total for the table.

When a Manager is selected, than the overall total for the table means also a total for the Manager.

hope it helps,

Oleg Troyansky

Re: Creating totals from list box selection

Tue, 27 Aug 2013 14:40:42 GMT

Thanks for the response, however the 'Show Partial Sums' checkbox is inactive for all dimensions and expressions in the Presentation Tab? Is this a setting that can be changed somewhere?

Re: Creating totals from list box selection

Gysbert_Wassenaar — Tue, 27 Aug 2013 17:23:41 GMT

Is the Indent Mode enabled on the Style tab? That will disable the partial sums option. And make sure your expression is sum(SomeField), not just SomeField. Otherwise you won't get a total.