Support on Qlik Expression

[Singaravelu_R]

Hi Team,

Please find below data which I have in table visual,

Policy No	Policy From Date	Policy To Date	Premium	Customer Name
2156778	01-01-2024	31-12-2024	500	XYZ private Limitated
2156778	01-01-2024	31-12-2024	800	TATA Limited
2156778	01-01-2024	31-12-2024	900	TATA Limited
2156778	01-01-2024	31-12-2024	1600	XYZ private Limitated

I dont want to change anything in backend and want desired results as per below. Please provide some advice to how to achieve below desired results.

Desired Results
Policy No	Policy From Date	Policy To Date	Premium	Customer Name
2156778	01-01-2024	31-12-2024	3800	XYZ private Limitated (any one of Customer Name)

[TauseefKhan]

Hi @Singaravelu_R,

Create a new measure for the Premium column in your table visualization:

Sum(Aggr(Sum(Premium), [Policy No], [Policy From Date], [Policy To Date]))

Create a new dimension for the Customer Name column: FirstSortedValue([Customer Name], [Premium])

This will sum up the premiums for each policy and display one of the customer names associated with that policy.

[Dana_Baldwin]

Hi @Singaravelu_R 

Just for future reference, it looks like this post is regarding Qlik Sense, but this forum is for Qlik Enterprise Manager, a data integration product. If Qlik Sense, please post here to reach the right audience: Qlik Sense | Qlik Community

Thanks!

[anat]

expression :

=sum(aggr(sum(Premium),[Policy From Date],[Policy No],[Policy To Date]))