topic Re: How to remove duplicate data in Field in QlikView

How to remove duplicate data in Field

Anonymous — Tue, 16 Jan 2018 13:41:58 GMT

Hi Experts,

I have a meeting type code is below...

1X1

GRP

3X1

2X1

CCL

Lunch

Dinner

In that data lot of duplicates is there

How to remove the duplicate in a Meeting type code.

Thanks

Re: How to remove duplicate data in Field

Anil_Babu_Samineni — Tue, 16 Jan 2018 13:44:17 GMT

I didn't see any duplicate from sample data. But, Qlikview can automatic skip the Duplicates.

Re: How to remove duplicate data in Field

surendraj — Tue, 16 Jan 2018 13:45:10 GMT

Use Distinct..

Re: How to remove duplicate data in Field

Anonymous — Tue, 16 Jan 2018 18:30:12 GMT

You can use the LOAD DISTINCT statement on the script to avoid loading duplicate records.

The DISTINCT statement can also be used with Set Analysis to avoid considering duplicates of a field.

Re: How to remove duplicate data in Field

Anonymous — Thu, 18 Jan 2018 05:14:27 GMT

Hii..

my source like below ..

Based on the client no of meetings and unique meeting id count needed.

Meeting Id	Event Date	Event Type	Meeting Type Code	Client Name	Product Line
161967P	1/24/2017	Conference	DINNER	Anbang Asset Mgmt (Hong Kong) Co Ltd	Economics
1335933H	3/30/2017	IMG - Investor Reverse Inquiry	CCL	Aesir Capital Mgmt LP	US Shares
1305486H	1/12/2017	Analyst Marketing Day	GRP	AXA Inv Mgrs - Europe	European Shares
Meeting Id	Event Date	Event Type	Meeting Type Code	Client Name	Product Line
161967P	1/24/2017	Conference	DINNER	Anbang Asset Mgmt (Hong Kong) Co Ltd	Economics
1335933H	3/30/2017	IMG - Investor Reverse Inquiry	CCL	Aesir Capital Mgmt LP	US Shares
1335933H	3/30/2017	IMG - Investor Reverse Inquiry	CCL	Aesir Capital Mgmt LP	US Shares
1307755H	2/15/2017	Field Trip	GRP	Amansa Capital	Asian Shares
1320065H	3/16/2017	Analyst Marketing Day	1X1	T Rowe Price - Investment Advisor	Latin American Shares
1310503H	3/2/2017	Non Deal Management	GRP	Bank J Safra Sarasin	PanEuro Shares
1320452H	3/9/2017	Field Trip	GRP	Lombard Odier Darier Hentsch & Cie - Private Bank	PanEuro Shares
1320452H	3/9/2017	Field Trip	GRP	BDK Capital SAS	PanEuro Shares

How to get No of meetings and Rank based on the attendee the meeting id in meeting id have a duplicate id

(Check Bold data)

Re: How to remove duplicate data in Field

surendraj — Thu, 18 Jan 2018 08:55:59 GMT

Use

Load Distinct * from

[Table name];

Re: How to remove duplicate data in Field

Anonymous — Thu, 18 Jan 2018 09:16:53 GMT

hi Expets...

How to get No of meetings and Rank based on the attendee the meeting id in meeting id have a duplicate id

I am trying below expression in no of meeting logic but i am not getting the data

Aggr(count({<[Event Type]={'Non Deal Management','Conference','Field Visit','Field Trip','Other GCA','IMG - Investor Reverse Inquiry'}>} distinct [Meeting Id]),[Client name])

Anybody correct the above expression

Thanks

Re: How to remove duplicate data in Field

Anil_Babu_Samineni — Thu, 18 Jan 2018 09:28:12 GMT

Your question is different than this. Where are u trying this?

Re: How to remove duplicate data in Field

Anonymous — Thu, 18 Jan 2018 09:33:26 GMT

Meeting Id	Event Date	Event Type	Meeting Type Code	Client Name	Product Line
161967P	1/24/2017	Conference	DINNER	Anbang Asset Mgmt (Hong Kong) Co Ltd	Economics
1335933H	3/30/2017	IMG - Investor Reverse Inquiry	CCL	Aesir Capital Mgmt LP	US Shares
1305486H	1/12/2017	Analyst Marketing Day	GRP	AXA Inv Mgrs - Europe	European Shares
Meeting Id	Event Date	Event Type	Meeting Type Code	Client Name	Product Line
161967P	1/24/2017	Conference	DINNER	Anbang Asset Mgmt (Hong Kong) Co Ltd	Economics
1335933H	3/30/2017	IMG - Investor Reverse Inquiry	CCL	Aesir Capital Mgmt LP	US Shares
1335933H	3/30/2017	IMG - Investor Reverse Inquiry	CCL	Aesir Capital Mgmt LP	US Shares
1307755H	2/15/2017	Field Trip	GRP	Amansa Capital	Asian Shares
1320065H	3/16/2017	Analyst Marketing Day	1X1	T Rowe Price - Investment Advisor	Latin American Shares
1310503H	3/2/2017	Non Deal Management	GRP	Bank J Safra Sarasin	PanEuro Shares
1320452H	3/9/2017	Field Trip	GRP	Lombard Odier Darier Hentsch & Cie - Private Bank	PanEuro Shares
1320452H	3/9/2017	Field Trip	GRP	BDK Capital SAS	PanEuro Shares

My suorce file above

I am trying below expression in no of meeting logic but i am not getting the data

Aggr(count({<[Event Type]={'Non Deal Management','Conference','Field Visit','Field Trip','Other GCA','IMG - Investor Reverse Inquiry'}>} distinct [Meeting Id]),[Client name])

Thanks

Re: How to remove duplicate data in Field

Anil_Babu_Samineni — Thu, 18 Jan 2018 09:37:52 GMT

That is okay. Which object you tried fir?

Can u remove aggr() and then try for a while

Re: How to remove duplicate data in Field

Anonymous — Thu, 18 Jan 2018 09:42:46 GMT

Hi Anil...

I am trying Calculated Dimension but i need a count of meetings.

Re: How to remove duplicate data in Field

Anil_Babu_Samineni — Thu, 18 Jan 2018 09:49:46 GMT

Why dont u tried from expression?

Anyway, try this

If(Aggr(count({<[Event Type]={'Non Deal Management','Conference','Field Visit','Field Trip','Other GCA','IMG - Investor Reverse Inquiry'}>} distinct [Meeting Id]),[Client name]), [Client name])

Re: How to remove duplicate data in Field

Anonymous — Thu, 18 Jan 2018 10:01:38 GMT

expression it showing wrong...

Re: How to remove duplicate data in Field

Anil_Babu_Samineni — Thu, 18 Jan 2018 14:29:56 GMT

Will you able to provide sample application?

Re: How to remove duplicate data in Field

MarcoWedel — Sat, 20 Jan 2018 21:33:59 GMT

what is your expected result?