Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
p_noindl
Partner - Contributor III
Partner - Contributor III

Total of expression in straight table vs. pivot table

I have a problem with totals in straight/pivot tables - anyone has an idea how to solve it. Example attached.

1 Solution

Accepted Solutions
CELAMBARASAN
Partner - Champion
Partner - Champion

For Pivot table use the expression as

=Count({<Customer={"=count(Visits) >= Sum (Target)"}>} DISTINCT Customer)

View solution in original post

2 Replies
CELAMBARASAN
Partner - Champion
Partner - Champion

For Pivot table use the expression as

=Count({<Customer={"=count(Visits) >= Sum (Target)"}>} DISTINCT Customer)

p_noindl
Partner - Contributor III
Partner - Contributor III
Author

Hi,

many thanks!