topic Re: Support on Qlik Expression in App Development

Support on Qlik Expression

Singaravelu_R — Fri, 12 Jul 2024 10:05:10 GMT

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)

Re: Support on Qlik Expression

TauseefKhan — Fri, 12 Jul 2024 11:46:33 GMT

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.

Re: Support on Qlik Expression

Dana_Baldwin — Fri, 12 Jul 2024 17:06:22 GMT

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!

Re: Support on Qlik Expression

anat — Sat, 13 Jul 2024 01:27:37 GMT

expression :

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