topic Re: Return multiple GetFieldSelections selections parsed in QlikView

Return multiple GetFieldSelections selections parsed

BlondeThursday — Sat, 16 Nov 2024 19:47:18 GMT

I need to check what a user has selected in one list box, and display different things based on that in a text box.

For instance, if one item in the field is selected just display that item, if all are selected display “All Items”, if certain groupings are selected use a different label.

The field Venue has five possible values: A, B, C, D, or E.

If just one or all are selected it's easy.

If the user selects A, B, and C then I want to say in the text box "A, B, and C", a bit tricker but I've gotten close using "Concat(Distinct Venue&CHR(13))".

But, if they select A, B, and D I want to say in that text box “South Region”. I do have a button to select the South Region (Select in Field (Venue), ("A"|"B"|"D")) that works but I can’t seem to be able to determine when those specific selections have been made, either with the button or via the list box.

There will never be too many combinations so I’m happy to use an If statement.

Re: Return multiple GetFieldSelections selections parsed

sunny_talwar — Wed, 30 Oct 2019 12:37:37 GMT

Not sure I understand this "but I can’t seem to be able to determine when those specific selections have been made, either with the button or via the list box." Do you have a sample where we can see the issue?

Re: Return multiple GetFieldSelections selections parsed

BlondeThursday — Wed, 30 Oct 2019 13:11:13 GMT

Thank you Sunny,

I've attached a simple example. I just want to know if three specific choices are made for the venue and display an explanation text ('South Region selected' or something like that).

Re: Return multiple GetFieldSelections selections parsed

sunny_talwar — Wed, 30 Oct 2019 13:16:33 GMT

Try this

=If(GetFieldSelections(Venue) = 'A, B, D', 'South Region')

Re: Return multiple GetFieldSelections selections parsed

BlondeThursday — Wed, 30 Oct 2019 13:22:42 GMT

Thank you Sunny,

That's almost there!

It works if the list box was used to select the three venues but not if the button is used. Why would that be?

Christine

Re: Return multiple GetFieldSelections selections parsed

sunny_talwar — Wed, 30 Oct 2019 13:27:56 GMT

Added another action to the button.... Select Possible for Venue field

Re: Return multiple GetFieldSelections selections parsed

BlondeThursday — Wed, 30 Oct 2019 13:32:13 GMT

Thank you Sunny!

Brilliantly helpful as usual.

Christine