Discussion Board for collaboration related to QlikView App Development.
in my QlikView document I would like to save into a variable all the possible value of a field.
Is it there a function like "getFieldSelections()" but for the possible values (I mean all those showed in white) instead of the selected ones?
Thanks a lot,
You can do something like concat(DISTINCT YOUR_FIELD,',')
In this way I can concatenate all the values of a field inside an object like a straight table, isn't it?
My need is to save in any moment all the selectable values of a field, depending on the selections activated.
if you a save a table execute Excel with a command EXECUTE and save your data in Execel or in a file TXT.
Elaborating a bit Daniel Rozental's solution, you can create a variable in the Settings menu, Variable Overview, with the following expression:
=Concat(DISTINCT Field, ';')
Using the semicolon so the variable can have the values formatted properly
Hope that helps.
Miguel Angel Baeyens
Comex Grupo Ibérica
I was just answering that the solution proposed by Daniel is good.I tried exactly what you proposed in you post.