Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
tinkerz1
Creator II
Creator II

Different results from selections methods, Actions and Fields

Hi,

I have getting 2 different outputs from different selection methods.

When I use an Action and Select in field: [Issue] with search string ("ABC"|"DEF")

and from this formula in the caption:

=

subfield(GetFieldSelections([Issue],'; ',getselectedcount ([Issue])), '; ',1)&' '&GetFieldSelections([Month-Year],', ',getselectedcount ([Month-Year]))

I get ("ABC"|"DEF") Sep-15

but when select ABC DEF from the field with the mouse I get

ABC as its the first selection in subfield.

Why is the search string in the action not returning the same on both mewthods of selection?

Thanks

1 Reply
Gysbert_Wassenaar

GetFieldSelections return the search string if one was used to make the selection, not the individual values that are the result of the search string. If you need those values then use concat(distinct Issue, ',')


talk is cheap, supply exceeds demand