Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Fieldvaluelist() returns the values from the system-tables and they are stored distinct.
- Marcus
Fieldvaluelist() returns the values from the system-tables and they are stored distinct.
- Marcus
Thanks very much for this. I loved reading it and understand it so much better now!