Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

nagarjuna123
New Contributor II

Re: How to remove duplicate data in Field

Hi Anil...

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

Re: How to remove duplicate data in Field

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])

Highlighted
nagarjuna123
New Contributor II

Re: How to remove duplicate data in Field

expression it showing wrong...

Re: How to remove duplicate data in Field

Will you able to provide sample application?

Re: How to remove duplicate data in Field

what is your expected result?

Community Browser