Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

nagarjuna123
New Contributor II

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

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 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 
4 Replies

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

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

Life is so rich, and we need to respect to the life !!!
nagarjuna123
New Contributor II

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

Hi Anil...

I am expacted o/p like This

     

Event typeConferenceConferenceConferenceConferenceField Trip
Client Name#Of MeetingsRankMeeting Type1X12X13X1Group MeetingGroup Meeting
Balyasny Asset Mgmt481 00200
Balyasny Asset Mgmt481 00100
Balyasny Asset Mgmt481 10000
Balyasny Asset Mgmt481 20000
Balyasny Asset Mgmt481 02000

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

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

Life is so rich, and we need to respect to the life !!!
nagarjuna123
New Contributor II

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

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