Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

How to remove duplicate data in Field

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

14 Replies
Anil_Babu_Samineni

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

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
surendraj
Specialist
Specialist

Use Distinct..

Anonymous
Not applicable
Author

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.

Anonymous
Not applicable
Author

Hii..

my source like below ..

   

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

Meeting IdEvent DateEvent TypeMeeting Type CodeClient NameProduct Line
161967P1/24/2017ConferenceDINNERAnbang Asset Mgmt (Hong Kong) Co LtdEconomics
1335933H3/30/2017IMG - Investor Reverse InquiryCCLAesir Capital Mgmt LPUS Shares                 
1305486H1/12/2017Analyst Marketing DayGRPAXA Inv Mgrs - EuropeEuropean Shares           
Meeting IdEvent DateEvent TypeMeeting Type CodeClient NameProduct Line
161967P1/24/2017ConferenceDINNERAnbang Asset Mgmt (Hong Kong) Co LtdEconomics
1335933H3/30/2017IMG - Investor Reverse InquiryCCLAesir Capital Mgmt LPUS Shares                 
1335933H3/30/2017IMG - Investor Reverse InquiryCCLAesir Capital Mgmt LPUS Shares                 
1307755H2/15/2017Field TripGRPAmansa CapitalAsian Shares
1320065H3/16/2017Analyst Marketing Day1X1T Rowe Price - Investment AdvisorLatin American Shares     
1310503H3/2/2017Non Deal ManagementGRPBank J Safra SarasinPanEuro Shares             
1320452H3/9/2017Field TripGRPLombard Odier Darier Hentsch & Cie - Private BankPanEuro Shares             
1320452H3/9/2017Field TripGRPBDK Capital SASPanEuro 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)

surendraj
Specialist
Specialist

Use

Load  Distinct * from

[Table name];

Anonymous
Not applicable
Author

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

Anil_Babu_Samineni

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

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Anonymous
Not applicable
Author

Meeting Id

Event DateEvent TypeMeeting Type CodeClient NameProduct Line
161967P1/24/2017ConferenceDINNERAnbang Asset Mgmt (Hong Kong) Co LtdEconomics
1335933H3/30/2017IMG - Investor Reverse InquiryCCLAesir Capital Mgmt LPUS Shares                
1305486H1/12/2017Analyst Marketing DayGRPAXA Inv Mgrs - EuropeEuropean Shares          
Meeting IdEvent DateEvent TypeMeeting Type CodeClient NameProduct Line
161967P1/24/2017ConferenceDINNERAnbang Asset Mgmt (Hong Kong) Co LtdEconomics
1335933H3/30/2017IMG - Investor Reverse InquiryCCLAesir Capital Mgmt LPUS Shares                
1335933H3/30/2017IMG - Investor Reverse InquiryCCLAesir Capital Mgmt LPUS Shares                
1307755H2/15/2017Field TripGRPAmansa CapitalAsian Shares
1320065H3/16/2017Analyst Marketing Day1X1T Rowe Price - Investment AdvisorLatin American Shares    
1310503H3/2/2017Non Deal ManagementGRPBank J Safra SarasinPanEuro Shares            
1320452H3/9/2017Field TripGRPLombard Odier Darier Hentsch & Cie - Private BankPanEuro Shares            
1320452H3/9/2017Field TripGRPBDK Capital SASPanEuro 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

Anil_Babu_Samineni

That is okay. Which object you tried fir?

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

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)