Conditional 'In' with multiple values

[#1]

So i want to make a condition for a line on a graph.  I have created inline dimensions for the names (geographies) and want to say that if that particular value is selected (alone or in conjunction with other values) the line will be shown.

Lets say I have:

bronx, albany, hartford as the Geographies

I select bronx, bronx shows.

I select bronx and albany, both show

I select all three, then all three sown

how do i accomplish this??

Thank you

[Peter_Cammaert]

Is it ok that if nothing is relly selected (nothing in green, all in white), then all lines are shown?

Then add "geographies" as a second dimension to your line graph. The legend that now appears will tell you which line corresponds to which geography. Only selected geographies will draw lines.

Peter

[#3]

yes it is okay if nothing is selected, then all lines are displayed.

So the conditions i want are on the lines, which are expressions.  How could this work as a dimension??

[swuehl]

If you can't use your Geographie values as a second dimension, i.e. it's an unlinked data island, you can still use conditional expressions. There is an ad-hoc report demo in 'what's new in QV11' demo app showing this approach.

[#5]

Okay this was very helpful - thank you. 

So i am going to use a 'substringcount(concat))' and i would like to add in other fields and values into the condition - how could i put in an 'if' statements coupled with the substringcount(concat)??

[swuehl]

The expression should evaluate to false (0) if you want to hide the expression / line or true (-1 (or any other value different from zero). Use AND / OR to build more complex boolean logic

Something like

=SubstringCount(Concat(Geographie,'|'), 'bronx') AND (Sum(OtherField) > 100 OR GetSelectedCount(TriggerField) )

[#7]

so i am using this string:

= SubStringCount(Concat(%_NewEnglandTerrNo, '|'), 1)

and it equates to true no matter what...am i missing something??

[swuehl]

What does

=concat(%_NewEnglandTerrNo, '|')

return in a text box, when you are selecting a value other than 1 (try 2)  in that field?

[#9]

concat(%_NewEnglandTerrNo, '|') returns 1|2|3|4|5|6|7

so how do i say that if '1' is in the string at all, return it??  wildmatch does not seem to be working:

= if(wildmatch(Concat(%_NewEnglandTerrNo, '|') ,'*1*'),1,0)

[#10]

my issue is that concat(%_NewEnglandTerrNo, '|') returns 1|2|3|4|5|6|7 no matter my selections.

i want it sch that if i select 2,3,4, then i would get 2|3|4

any ideas??