Qlik Community

Ask a Question

New to QlikView

If you’re new to QlikView, start with this Discussion Board and get up-to-speed quickly.

Announcements
Welcome to our newly redesigned Qlik Community! Read our blog to learn about all the new updates: READ BLOG and REPORTED ISSUES
cancel
Showing results for 
Search instead for 
Did you mean: 
Creator II
Creator II

Conditional Format Pivot Table Lines, Sub Totals and Totals

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

Di

1 Solution

Accepted Solutions

May be like this:

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

View solution in original post

4 Replies

May be like this:

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

View solution in original post

Creator II
Creator II

Thank you!

Worked a charm!

Nice

Contributor
Contributor

How to add Average along with Total TotalAvg.png