Set Analysis, charting each selection in a chart

[tinkerz1]

Hi all

Really stuck on this one, how do I set up an expession to show a list box selection per line on a chart.

For instance the list box has 6 items, I select 3, how do I get 3 lines in the chart?

Thanks

Neil.

[sunny_talwar]

Would you be able to elaborate? Bar for what description and Line for which ones?

[tinkerz1]

I would like 'B' to be a bar and C to be a line, I dont think you can do it with Charlottes method

[sunny_talwar]

Yes, in that case you will need to use different expressions.

[tinkerz1]

I have got this far now

Sum({$<[ABC]={"*OHL*"},[ABC]={"*Red*"}>}Data)

But I need to say Red and OHL in the same filed name not across field names

[sunny_talwar]

You need Red and OHL in the same field name??? Not sure what you mean here???

[sunny_talwar]

So are you looking for a line or bar which includes Red and OHL? and then another bar or line which use another combination??? Just trying to understand your requirement.

Best,

Sunny

[tinkerz1]

Yes that's correct

[sunny_talwar]

So the expression above isn't working for you???

Sum({$<[ABC]={"*OHL*"},[ABC]={"*Red*"}>}Data)

if it isn't then try one of the two:

Sum({$<[ABC]={"*OHL*", "*Red*"}>}Data) or

Sum({$<[ABC]={"*OHL*"} + {"*Red*"}>}Data)

and then the hide show condition could be:

=SubStringCount(Concat(DISTINCT [ABC], '|'), 'Red') = 1 or SubStringCount(Concat(DISTINCT [ABC], '|'), 'OHL') = 1 (this would mean that if from the ABC listbox either Red or OHL is selected show this expression which would show the sum of two, if you want to see if both are selected, then you can put and instead of or in the above condition)

HTH

Best,

Sunny

[tinkerz1]

Sorry this does not work as I have several red fileds in the list and QV wants to add them.

I just want the condition to be RED and OHL together. then I can make red a variable

Thanks,

Neil.

[sunny_talwar]

How can a single field (ABC in your case) be RED as well as OHL at the same time???

Is the field something like this??

[ABC]

xyzREDabcOHLmno