Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Percentages in expanded pivot table

I have a pivot table with a calculated dimension, and am trying to get percentages to the calculated dimension level.

Collapsed, the percentages are fine. Expanded, '-' populated cells show up. I've worked over aggr with this with no luck. Sample aggr:

(sum(total_claim_count) / (aggr(sum(claim_count), claim_name, claim_status))

The calculated dimension involves three 'if' statements and does not plug into the aggr.

This has used up my blood on the keyboard supply for the weekend.

Help vastly appreciated.

kencho

1 Solution

Accepted Solutions
Not applicable

Percentages in expanded pivot table

The solution is:

(sum(total_claim_count) / (aggr(nodistinct sum(claim_count), claim_name, claim_status))

nodistinct is what does the trick!

4 Replies
sathishkumar_go
Contributor III

Percentages in expanded pivot table

Hi

I understand ur problem. Better attach ur here?

-Sathish

Not applicable

Percentages in expanded pivot table

The solution is:

(sum(total_claim_count) / (aggr(nodistinct sum(claim_count), claim_name, claim_status))

nodistinct is what does the trick!

Not applicable

Percentages in expanded pivot table

Thank You. Thank You. Thank You!Smile

pablolabbe
Valued Contributor II

Percentages in expanded pivot table

Why, nodistinct does the trick ?

Community Browser