Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Experts...
How to get No of meetings and Rank below the my source file
Based on the client we need count of no of meeting?
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 |
What is this mean?
How to get No of meetings and Rank below the my source file
Note - Please close Qlik Community Tip: Marking Replies as Correct or Helpful
Hi Anil...
I am expacted o/p like This
Event type | Conference | Conference | Conference | Conference | Field Trip | |||
Client Name | #Of Meetings | Rank | Meeting Type | 1X1 | 2X1 | 3X1 | Group Meeting | Group Meeting |
Balyasny Asset Mgmt | 48 | 1 | 0 | 0 | 2 | 0 | 0 | |
Balyasny Asset Mgmt | 48 | 1 | 0 | 0 | 1 | 0 | 0 | |
Balyasny Asset Mgmt | 48 | 1 | 1 | 0 | 0 | 0 | 0 | |
Balyasny Asset Mgmt | 48 | 1 | 2 | 0 | 0 | 0 | 0 | |
Balyasny Asset Mgmt | 48 | 1 | 0 | 2 | 0 | 0 | 0 |
Try to provide output which related to Input which u gave? Not sure, How come #48 is shows?
Hi..
i put in the client name in fiter above o/p.
I tried below logic
Aggr(Count({<[Event Date]={">=$(=Date(vStartDate,'MM/DD/YYYY'))<=$(=Date(vEndDate,'MM/DD/YYYY'))"}, [Event Type]={'Non Deal Management','Conference','Field Visit','Field Trip','Other GCA','IMG - Investor Reverse Inquiry'}>} distinct [Meeting Id]),[Client Name])
I am getting miss match count and when check tthe data is comming correctly. count is getting worng