Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
Highlighted
Not applicable

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

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.

5 Replies
Highlighted
Honored Contributor II

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

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

Highlighted
Not applicable

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

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.

Highlighted
Not applicable

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

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

Highlighted

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

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

Highlighted
Not applicable

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

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