Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Not applicable

Depurate excel table

Hi everyone,

I loaded an excel table into QV with Customer information (Contact name, Compañy, Telephone, email, etc). For example,I have rows with the same email. how can i show  in a straight table only the records that has not duplicate information?

thank a lot,

angel

2 Replies
Not applicable

Depurate excel table

Could you post a sample data and application.

- Sridhar

Depurate excel table

Hi,

     You can use the "Distinct" keyword before your field name.

Regards,

Kaushik Solanki

Community Browser