Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

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

Re: How to get all the filtered item name into Text & image at Qlik Sense?

The getfieldselections function is returning a list of the values selected from the myState field, using # as the value separator and I've limited it to return 53 values. This is as per the syntax in the help (help.qlik.com).

The subfield function is then effectively breaking the string returned by getfieldselections into separate strings or fields, using the # as the separator. The -1 is to tell it to return the last string that it finds as the '-' tells it to search from the right rather than the left..

Highlighted
Valued Contributor

Re: How to get all the filtered item name into Text & image at Qlik Sense?

Thanks!

subfield(getfieldselections(myState,'#', 53), '#' , -1) does not work.

For example, if I firstly click Washington state, text part will always show 'Washington'; if i firstly click Arizona (if i keep clicking state with name order), the text part will be correct.

So, this method nearly works.

I think we need to search from the RIGHT rather than LEFT.

Could you please give any suggestion?