Set Expression

upaliwije — Tue, 13 Mar 2018 05:59:22 GMT

Hi Fiiends

I have the follwing pivit table in my QV doc.

My expression for the per claim cost is as follows

SUM({<LOSS_YEAR={"2013","2017"},PRL_PTY_CODE={'INP'},CLA_CODE={'SS'}>}$(vPaid))/COUNT(DISTINCT{<LOSS_YEAR={"2013","2017"},PRL_PTY_CODE={'INP'},CLA_CODE={'SS'}>} CLAIM_NO)

My requirement is to add another column to show the Per Claim Cost Increase % from 2013 to 2017 and show it in pivot table

The screen shot of new format shown below. Kindly advise how to fullfil my requirement.

topic Set Expression in QlikView

Set Expression