Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Removing of Duplicates in a Column

Hi Community members,

I have straight table with Name,Speciality,..Names column values are repeating twice and some are repeating thrice. so how to avoid these values repeptition..

can anyone help me out please.

Regards,

Ramesh.

3 Replies
Not applicable
Author

Hi,

you could send an example of the problem?

Not applicable
Author

Hi Rebeca,

Thanks for your response, I have attached the file.Please attach it and send send me the solution.

Regards,

Ramesh

Anonymous
Not applicable
Author

Hi Rameshmca,

   add calculation domension like.......

    

          =if(Len(phys_name)>=1,phys_name)

it will be supress nulvalues in your chart,i tested in your example it'working properly.

Thanks

SHAIK