Alternate State use in Chart title

[#1]

Hi folks,

I have the attached qvw in which I am using alternate states to find out which customers bought item A and didn't buy item D everything works fine in the chart my qustion depends on the title. I want to have a dynamic title which will contains the results of the selected values in both listboxes e.g. "Customer which bought A and didn't bought D" as you can see the problem is how to get the second value "D".

Any ideas?

Kind Regards,

Helen

[daveamz]

Hi Eleni,

Check the Help Manual for getfieldselections()

Note!

It is not possible to use chart field functions in conjunction with Alternate States as these functions do not have a set_expression parameter to set the state.

Best regards,

David

[tresesco]

Use:

Only({[Excluded Set]} Item)

PFA

[daveamz · Accepted solution]

If you'll have more than 1 value selected in "Excluded Set"

=Concat({[Excluded Set]} DISTINCT Item,',')

[CELAMBARASAN]

Hi,

I hope there will be a possibilty to get more than one selected. so you could go with Concat({[Excluded Set]} Distinct Item, ','). Because Only gives the Null is it has morethan one possible/selection in that field.

[#6]

Thank you all guys, I was stuck to this stupid thing!