topic Show single record while table has duplicates in QlikView

Show single record while table has duplicates

nihhalmca — Sat, 16 Nov 2024 00:53:18 GMT

Hi All -

I want to show highest premium for each policy (single record).

For instance:

PolicyNo, CoverageDesc, Premium

1, A, 1000

2, B, 2000

3, C, 3000

Expected output is

PolicyNo, CoverageDesc, Premium

3, C, 3000

How can i achieve this result?

I tried one approach : "Agg(Max(Premium),PolicyNo,CoverageDesc)"

Result:

PolicyNo, CoverageDesc, Premium

1, A, -

2, B, -

3, C, 3000

Thanks,

Nihhal.

Re: Show single record while table has duplicates

Brett_Bleess — Wed, 29 Apr 2020 14:52:13 GMT

Have a read through the following Design Blog post, I believe that may be what you need:

https://community.qlik.com/t5/Qlik-Design-Blog/The-sortable-Aggr-function-is-finally-here/ba-p/1470262

The only other means would be to use Order by or Group by in the load to get things in order and then grab the first or last record etc. that way, there are some other posts on Community regarding that scenario you should be able to find.

Regards,
Brett