Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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.
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
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