topic Re: Remove duplicate numbers based on condition in QlikView

Remove duplicate numbers based on condition

nihhalmca — Sat, 16 Nov 2024 00:55:34 GMT

Hi All -

I need to show only unique policy numbers (distinct) in straight table only selecting by filter or button (straight table already has data with duplicate records).

Condition : Should show only distinct policy numbers which has highest renewal premium and expired premium.

Attached sample data here.

Thanks, Nihhal.

Re: Remove duplicate numbers based on condition

kaushiknsolanki — Wed, 01 Apr 2020 19:49:55 GMT

What is the expected output from this sample data?

Re: Remove duplicate numbers based on condition

nihhalmca — Wed, 01 Apr 2020 20:53:04 GMT

Hi Kaushik - Updated sample data file with expected output.

Re: Remove duplicate numbers based on condition

christophebrault — Wed, 08 Apr 2020 06:36:04 GMT

Hi,

What is the expected output for BB301 ? Because Expired and Renewal are the same in two lines

Re: Remove duplicate numbers based on condition

nihhalmca — Wed, 08 Apr 2020 10:19:08 GMT

Hi Chris - Thanks for your response. Unfortunately your chart is not matching with expected output (attached file) even not consider BB301. I updated excel and attached.