How to show multiple values in text object based associative?

[#1]

Hi

I have scenario

I created one text box object for showing state column in filter,if any one value or two values if i select from State filter i am able to see the values in Textbox object.

Because i have used the formula getfieldselections in textbox object.

My problem is if any other filter i selected like Year or Country then in State filter it is showing multiple values but in text box it is not showing any values

For showing multiple values in state Text box object what i need to do?

Please do the needful

Thiru

[engishfaque]

Dear Thiru,

Kindly find attached QlikView App.

Kind regards,

Ishfaque Ahmed

[sunny_talwar]

May be try this:

If(GetExcludedCount(State) >= 1, Concat(DISTINCT State, ', '))

[swuehl]

I am not really sure what you want to show in this text box.

If you want to show possible values of field State, just use

=Concat(DISTINCT State,', '))

If you only want to show selected values, use

=GetFieldselections(State)

Or if you want to show the possible values, but only if there is a selection in any field made:

=If(Not Isnull(GetCurrentSelections()), Concat(DISTINCT State, ', '))

[sunny_talwar]

I am not sure, but I thought that the OP is looking to show State even if one value is excluded in State. I guess my approach would be almost similar to your last expression (except for when there is an Island table when a selection will show in GetCurrentSelections(), but won't impact state)

[swuehl]

Not really sure what the OP wants to see, but I guess he still wants to see State values when he makes a selection in State.

[sunny_talwar]

I was under the impression that GetExcludedCount(FieldName) would count even when you select something in the FieldName. I guess I was wrong.

So may be what you mentioned should work for him

=If(Not Isnull(GetCurrentSelections()), Concat(DISTINCT State, ', '))

or if it only needs to be based on State, Country or Year, then may be this

=If(RangeMax(GetSelectedCount(Country), GetSelectedCount(State), GetSelectedCount(Year)) > 0, Concat(DISTINCT State, ', '))

[#8]

Hi Sunny

It is working Thank you very much

Thiru

[oknotsen]

If your question is now answered, please flag the Correct Answer and possible Helpful answers.

If not, please make clear what part of this topic you still need help with .

[sunny_talwar]

Great, please close the thread by marking correct and any helpful answers.

Qlik Community Tip: Marking Replies as Correct or Helpful

Best,

Sunny