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
Not applicable

How to get no of meeting Based on Client name and unique Meeting Id

Hii..

my source like below ..

    

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

Thanks