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

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

Tue, 26 Jul 2011 14:21:10 GMT

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 — Tue, 26 Jul 2011 14:22:59 GMT

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

Wed, 27 Jul 2011 08:37:03 GMT

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.

Wed, 27 Jul 2011 08:43:05 GMT

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 — Wed, 27 Jul 2011 08:51:01 GMT

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.

BI Consultant

Wed, 27 Jul 2011 08:54:27 GMT

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