scripting/alternate state

[#1]

Hi,

I have two filters, one in default state and other is in state1. is it possible to get same value selected in both the filters in different  state based on some expression.

example :

Filter1: Source in default state

Filter 2: [Source 2] in state State1

if a user select some value in Source listbox which is in default state with some expression or trigger same value must be selected in Source 2 listbox which is in State1.

Thank in advance

-Priyanka

[#2]

Hi Sunny,

i have implemented above solution and it is working fine for single word eg if filter1 has value "Book" it is working, but if it has value "Book Name" or "Book_Name" i.e. two words its not working

do you have any idea how to resolve it

[sunny_talwar]

Change the expression from

='(' & Concat(DISTINCT Chr(32) & Source & Chr(32), '|') & ')'

to

='(' & Concat(DISTINCT Chr(34) & Source & Chr(34), '|') & ')'

[#4]

Thank you so much, it is working

Do you have some document(s) which i can refer to understand chr() function with different values

Thanks in advance

[sunny_talwar]

See if this helps?

ASCII and Binary Characters (The Characters)

How to find a number for a char: chr() and ord() functions‌http://www.roubaixinteractive.com/PlayGround/Binary_Conversion/The_Characters.asp