Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
We are aware of an issue with the Product Downloads page and looking into it.
cancel
Showing results for 
Search instead for 
Did you mean: 
su_pyae
Creator
Creator

Unique values using the script

Hi everyone, 

I am trying to get distinct values from a table.  

ID Kind Type
1 CFF ABC
1 CFF ABC
1 CFF ABC
2 EMI IRL
2 EMI IRL
3 CFF ABC
4 CCS SEV
4 CCS SEV
5 DEP -
6 FX -
6 FX -

 

I am trying to get distinct value of ID, Kind and Type like in this following table:

ID Kind Type
1 CFF ABC
2 EMI IRL
3 CFF ABC
4 CCS SEV
5 DEP -
6 FX -

 

Thank you for your help in advance!

2 Replies
anat
Master
Master

use Rowno() in script and call same in table and hide this field

su_pyae
Creator
Creator
Author

Thank you for the suggestion but I am not clear what you want me to do. 

I need to get the modified table in the script without using frontend tools since I still need to work on it for other tasks.