Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
If you'll have more than 1 value selected in "Excluded Set"
=Concat({[Excluded Set]} DISTINCT Item,',')
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
Use:
Only({[Excluded Set]} Item)
PFA
If you'll have more than 1 value selected in "Excluded Set"
=Concat({[Excluded Set]} DISTINCT Item,',')
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.
Thank you all guys, I was stuck to this stupid thing!