How to get distinct ID's only

[smanas]

 I'm trying to write a formula to get only distinct IDs. Please advise

Samle data is below

ID	Name	Language
1	John,Doe	English
2	Jenny,Mark	French
2	Jenny,Mark	French
3	Mary,Dan	English
3	Mary,Dan	English

Desired output

ID	Name	Language
1	John,Doe	English
2	Jenny,Mark	French
3	Mary,Dan	English

[Rockstar7]

Add distinct keyword to your load statement like

Load distinct

ID,

Name,

Language

From .....;

[smanas]

Hi @Rockstar7 I'm not using the scripting. Can you share how i can work with dimensions and measures? Thank you

[Rockstar7]

Can you tell me how you are loading the data?

[smanas]

@Rockstar7  From the Qlikview app

[BrunPierre]

Moreover, as far as Qlik is concerned, duplicate values ​​are never shown in Table Boxes or Charts. You would have only distinct records if you presented your sample data in a Table Box or Straight Table.