topic Re: Conditional Format Pivot Table Lines, Sub Totals and Totals in QlikView

Conditional Format Pivot Table Lines, Sub Totals and Totals

dinicholls — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

First off, apologies if I don't explain this properly, feeling a bit sqwiffy at the mo, and its getting the better of me!

Here goes.

I have a pivot table that list details of outgoing call made per person / year / month / date. I have added averages, total no calls, time etc. I now need to add a 'Target' to the number of call made by each person, each day. I though this would be easy, but whenever I add the target of 40, to either a file, inline or just as an expression, it shows it as 40 in each day, but doesn't add it for each week, month, year etc.

Have added a jpeg of what I mean!

What am I doing wrong? Its driving me potty!

Thanks

Re: Conditional Format Pivot Table Lines, Sub Totals and Totals

sunny_talwar — Thu, 17 Nov 2016 12:11:45 GMT

May be like this:

Sum(Aggr(Sum([Lower Target]), Agent, MonthYear, WeekYear, [Contact Start]))

Re: Conditional Format Pivot Table Lines, Sub Totals and Totals

dinicholls — Thu, 17 Nov 2016 12:17:41 GMT

Thank you!

Worked a charm!

Re: Conditional Format Pivot Table Lines, Sub Totals and Totals

sunny_talwar — Thu, 17 Nov 2016 12:18:11 GMT

Nice

Re: Conditional Format Pivot Table Lines, Sub Totals and Totals

sandipahire — Sun, 11 Oct 2020 12:07:10 GMT

How to add Average along with Total