Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

p_noindl
New 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

Re: Total of expression in straight table vs. pivot table

For Pivot table use the expression as

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

2 Replies

Re: Total of expression in straight table vs. pivot table

For Pivot table use the expression as

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

p_noindl
New Contributor III

Re: Total of expression in straight table vs. pivot table

Hi,

many thanks!

Community Browser