How to get count in no of meetings based on metting id(Meeting Id have Duplicate)

[Anonymous]

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

[Anil_Babu_Samineni]

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

[Anonymous]

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

[Anil_Babu_Samineni]

Try to provide output which related to Input which u gave? Not sure, How come #48 is shows?

[Anonymous]

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