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

[PhilipMertin]

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?

[marcus_sommer · Accepted solution]

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

- Marcus

[MarcoWedel]

https://community.qlik.com/t5/Qlik-Design-Blog/Symbol-Tables-and-Bit-Stuffed-Pointers/ba-p/1475369#:....

[PhilipMertin]

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