How to save possible values of a field in a variable?

[#1]

Hi all,

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,

Alessandro.

[danielrozental]

You can do something like concat(DISTINCT YOUR_FIELD,',')

[#3]

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.

[#4]

if you a save a table execute Excel with a command EXECUTE and save your data in Execel or in a file TXT.

[Miguel_Angel_Baeyens]

Hello Alessandro,

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

BI Consultant

Comex Grupo Ibérica

[#6]

Hello Miguel,

I was just answering that the solution proposed by Daniel is good.
I tried exactly what you proposed in you post.

Great! 😉

Thanks a lot,

Alessandro