topic Re: How to show multiple values in text object based associative? in QlikView

How to show multiple values in text object based associative?

Wed, 25 Nov 2020 16:16:04 GMT

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

Re: How to show multiple values in text object based associative?

engishfaque — Wed, 04 May 2016 17:40:44 GMT

Dear Thiru,

Kindly find attached QlikView App.

Kind regards,

Ishfaque Ahmed

Re: How to show multiple values in text object based associative?

sunny_talwar — Wed, 04 May 2016 22:27:16 GMT

May be try this:

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

Re: How to show multiple values in text object based associative?

swuehl — Wed, 04 May 2016 22:50:00 GMT

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, ', '))

Re: How to show multiple values in text object based associative?

sunny_talwar — Wed, 04 May 2016 22:53:29 GMT

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)

Re: How to show multiple values in text object based associative?

swuehl — Wed, 04 May 2016 22:59:32 GMT

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.

Re: How to show multiple values in text object based associative?

sunny_talwar — Wed, 04 May 2016 23:05:53 GMT

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, ', '))

Re: How to show multiple values in text object based associative?

Thu, 05 May 2016 06:40:50 GMT

Hi Sunny

It is working Thank you very much

Thiru

Re: How to show multiple values in text object based associative?

oknotsen — Thu, 05 May 2016 14:38:05 GMT

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 .

Re: How to show multiple values in text object based associative?

sunny_talwar — Thu, 05 May 2016 14:38:51 GMT

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

Qlik Community Tip: Marking Replies as Correct or Helpful

Best,

Sunny

Re: How to show multiple values in text object based associative?

Anonymous — Thu, 05 May 2016 14:42:11 GMT

Hi Thiru,

You can use GetCurrentSelections. That works like Current Selection object.

Kind regards