Expression to show selected values of a ListBox in a Alternate State?

[jblomqvist]

Hi all,

Is there an expression to show all the selected value of a ListBox in a Alternate State?

Something like:

=GetCurrentSelections(SalesPerson) but for the object in StateA.

How can I specify to get values from the SalesPerson field in StateA?

[tresesco]

Yes, in updated version of QV (probably QV 11.2 SR8+) you can use alternate state in GetCurrentSelections().

Edit: corrected: SR8 : https://community.qlik.com/blogs/technicalbulletin/2014/09/08/qlikview-1120-service-release-8-is-now...

[Kushal_Chawda]

try below expression

= Sum({stateA< SalesPerson=$::SalesPerson >} Value)

[jblomqvist]

Hi Tresesco,

Any idea how? I have the SR8 version but not sure how to do it.

It's not for an aggregation, I simply want a list of values selected in an object in StateA.

[tresesco]

List in a textbox? It would be as simple as writing : =GetFieldSelections(SalesPerson, ',', ,'StateA')

[jblomqvist]

Yes that's what I thought it should be but it doesn't work, I just get a - as a output.

[tresesco]

Unfortunately mine is less than SR8 and can't test or check your sample qvw.

[sasiparupudi1]

can you please post a sample?

[jblomqvist]

Hi Sasidhar,

Please see the attached. The concept I am trying to achieve is in the Text Box next to StateA SalesPerson list box. It uses tresesco's expression above. The brackets are fine but maybe the commas are an issue. Thanks

[stigchel · Accepted solution]

You must use something for max values shown e.g. 20:

=GetFieldSelections(SalesPerson, ',',20 ,'StateA')