How to remove duplicate data in Field - Page 2 - Qlik Community

Anonymous · ‎2018-01-16

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

Anonymous · ‎2018-01-18

Hi Anil...

I am trying Calculated Dimension but i need a count of meetings.

Anil_Babu_Samineni · ‎2018-01-18

Why dont u tried from expression?

Anyway, try this

If(Aggr(count({<[Event Type]={'Non Deal Management','Conference','Field Visit','Field Trip','Other GCA','IMG - Investor Reverse Inquiry'}>} distinct [Meeting Id]),[Client name]), [Client name])

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful

Anonymous · ‎2018-01-18

expression it showing wrong...

Anil_Babu_Samineni · ‎2018-01-18

Will you able to provide sample application?

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful

MarcoWedel · ‎2018-01-20

what is your expected result?