Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

qv_jagan
Contributor

Calculate Data by aggregation

Dear All,

I have a data policyno, claimno, prem, claimamt.

I want create a chart with policyno wise claimamt. claimamt should be caluculated by claimno and then sum to policyno wise base on the logic given.

Post:
****
If ClaimAmt of each claim is greater than 100000 then 100000 else ClaimAmt.

Pre:
***
If ClaimsAmt of each claim is greater that 100000 then ClaimAmt - 100000 else zero.

Please let me know how to calculate Post & Pre column.

The output should be like Output table. Only policy dimension to be used.

Please see the qvw file attached for your reference.

Thanks,

Jagan. V

Tags (2)
1 Solution

Accepted Solutions
MVP
MVP

Re: Calculate Data by aggregation

Create a straight table chart with dimension policy nr. then 3 expression:

=sum(ClaimAmt)

=sum(if(ClaimAmt>100000,100000,ClaimAmt))

=sum(if(ClaimAmt>100000,ClaimAmt-100000,0))

3 Replies
MVP
MVP

Re: Calculate Data by aggregation

Is this the correct sample file? Please recheck, I don't see your claim data.

qv_jagan
Contributor

Re: Calculate Data by aggregation

Sorry the attachment was wrong, Please check now.

MVP
MVP

Re: Calculate Data by aggregation

Create a straight table chart with dimension policy nr. then 3 expression:

=sum(ClaimAmt)

=sum(if(ClaimAmt>100000,100000,ClaimAmt))

=sum(if(ClaimAmt>100000,ClaimAmt-100000,0))

Community Browser