Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

The Pivot table Partial sum issue

HI All,

I have attached one QVW, as you can see the partial sum of Center Name is not correct in North-A, it should be 4 instead of 5.

As you can see the Data, Center AAA, BBB, DDD shared the same LeadID: 1,2,3

Center CCC uses its own LeadID 4,5

What I want to do is if the Center under BJ that is AAA, BBB, DDD, the Leads should be divided by 3.

So I use this expression: If(City='BJ', count(DISTINCT LeadID)/3, count(DISTINCT LeadID))

However, the sum partial is not correct, could you help me out?

Thanks.

1 Solution

Accepted Solutions
PrashantSangle

Hi,

modify your expression with sum(aggr(yourExpression,dimension))

try like

sum(AGGR(If(City='BJ', count(DISTINCT LeadID)/3, count(DISTINCT LeadID)),Region,RegionDash,CenterName))

Regards

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

View solution in original post

1 Reply
PrashantSangle

Hi,

modify your expression with sum(aggr(yourExpression,dimension))

try like

sum(AGGR(If(City='BJ', count(DISTINCT LeadID)/3, count(DISTINCT LeadID)),Region,RegionDash,CenterName))

Regards

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂