Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
PhilipMertin
Partner - Contributor III
Partner - Contributor III

Does fieldvaluelist in "for each .. next" return distinct values?

Does fieldvaluelist in "for each .. next" return distinct values of the referenced field?

For example: For Each vFile in fieldvaluelist('Filenames')  .... next

Qlik Help only says:

This syntax iterates through the values of a field already loaded into Qlik Sense.

It doesn't specifically say it's distinct values. So if a value occurs more than once in the field, will it run the loop once for every occurrence, or once for every distinct occurrence?

 

Labels (1)
1 Solution

Accepted Solutions
marcus_sommer

Fieldvaluelist() returns the values from the system-tables and they are stored distinct.

- Marcus

View solution in original post

3 Replies
marcus_sommer

Fieldvaluelist() returns the values from the system-tables and they are stored distinct.

- Marcus

PhilipMertin
Partner - Contributor III
Partner - Contributor III
Author

Thanks very much for this. I loved reading it and understand it so much better now!