Discussion Board for collaboration on QlikView Layout & Visualizations.
i want to show the filtered values in a caption, f.e. using a textbox.
I have a field "land" with values "A,B,C,D".
In a listbox i select the value "A". When i generate a textbox with Field "land", the value "A" is shown, so every thing is OK.
but when i select the values "A,B,C" in the listbox, the textbox shows "-" instead of "A;B;C"......
How can i show the filtered values (without using the statusbox ) ?
Anyone an idea or suggestion?
Solution is function "=GetFieldSelections()"
I found it in the Communitiy...
Go to Solution.
Use the GetFieldselections('FieldName') in your text object expression.
Another one could be:
If(GetSelectedCount(Value) > 0, Concat(DISTINCT Value, ';'))
and for GetFieldSelections() you can determine what should be field seperator. and I would use a big number for third argument if you have large number of options to select from within value:
GetFieldSelections(Value, ';', 99999)
Yes using GetFieldSelections(Land), the result should be A,B,C in textbox in case you select ABC from list box.
Do you want to display it as A;B;C instead?