Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
I didn't see any duplicate from sample data. But, Qlikview can automatic skip the Duplicates.
Use Distinct..
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.
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)
Use
Load Distinct * from
[Table name];
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
Your question is different than this. Where are u trying this?
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
That is okay. Which object you tried fir?
Can u remove aggr() and then try for a while