Help with condotions?

[#1]

Hi,

I have a requirement where an text box should appear up on different selections in a filed. For exaple

Sales:

load * Inline

[Name,Sales

Bob,100

John,112

Sam,113,

Richard,200];

a text box should appear only up on selection of Bob and John and other should appear only when we select John and Sam etc for the different combinations.

I used =SubStringCount(concat(Name,'|'),'Bob|John')  but its working only for one combination.

Please post your ideas on this.

Thanks

[swuehl]

Maybe like

=concat(Name,'|') = 'Bob|John'

[sunny_talwar]

Try with this as your condition on Layout tab:

=SubStringCount(GetFieldSelections(Name), 'Bob') = 1 and

SubStringCount(GetFieldSelections(Name), 'John') = 1

[#4]

Thanks for the reply.

But for my original requirement when user sleet NA and EMEA, a text box should appear across the map covering both NA and EMEA. and when user select EMEA and APAC a text box should cover both regions.

I uses your function but its not working. Can you please look in to attached QVW?

[sunny_talwar · Accepted solution]

This condition should work for you:

=Concat(DISTINCT Region, '|') = 'EMEA|NAM'

[#6]

It works

Thank you