How To Aggregate the value under one

[pra_kale]

Hi,

I have a data in which CHDRNUM, GROUP_NO, Product,STATUS and Premium columns are there. I want to aggregate the total of premium under one CHDRNUM having status IF, only if Group_No is repeated and any one policy is having status IF and only for product code PPT and GST. Thouh Group_No is repeated but non of the policy is having status IF then aggregation is not allowed.

For rest product codes only policy status IF and PU Should be get considered. No Aggregation. So my final out-put should look like this.

CHDRNNUM	GROUP_NO	Product	STATUS	Premium
2345678	803402	PPT	IF	3500
987456	8456123	GST	IF	5500
32456789	8999912	PST	IF	56000
98723	8912346	CNT	IF	300
6978	8912346	CNT	PU	4500

Your help is appreciated.

Thanks in advance.

marcus_sommer‌

stalwar1‌

[pra_kale]

I have wrongly marked my answer as correct answer..Can I make the change now..

And sure I will remind you

Thanks again Sunny.

[sunny_talwar]

Look here on how to uncorrect an answer

Qlik Community Tip: Marking Replies as Correct or Helpful

[pra_kale]

Done..Thanks..