Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

mikefromoke
Contributor

Want to show filtered values in a caption...

Hello,

i want to show the filtered values in a caption, f.e. using a textbox.

Example:

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?

thx

mike

=>

Solution is function "=GetFieldSelections()"

I found it in the Communitiy...

1 Solution

Accepted Solutions
Not applicable

Re: Want to show filtered values in a caption...

Use the GetFieldselections('FieldName') in your text object expression.

6 Replies
Not applicable

Re: Want to show filtered values in a caption...

Use the GetFieldselections('FieldName') in your text object expression.

Re: Want to show filtered values in a caption...

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)

Not applicable

Re: Want to show filtered values in a caption...

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?

mikefromoke
Contributor

Re: Want to show filtered values in a caption...

Thank you

regards

mikefromoke
Contributor

Re: Want to show filtered values in a caption...

Thank you,

regards

mikefromoke
Contributor

Re: Want to show filtered values in a caption...

thank you,

regards

Community Browser