single field check with multiple field

[Anonymous]

HI all,

how can I check a single field with multiple field and the result return me a visible or hidden text box?

I have two data.    

TRANSACITION NUMBER	COMPANY	NAME 1	NAME 2	NAME 3
0000000001	A	AA	Charanjit	Penn
0000000002	B	Penn	Mun	Ling
0000000003	B	RR	Mun	Charanjit
0000000004	T	Penn	Mun	Ling
0000000005	O	Paul	Charanjit	OOO
0000000006	O	NN	Steph	Annie
0000000007	D	Ling	Steph	Annie
0000000008	A	Roy	TT	Charanjit

And

COMPANY	COMPANY OWNER
A	AA
B	BB
C	CC
D	DD
E	EE
F	FF
G	GG
HI	HH
I	III
J	JJJ
K	KKK
L	LLL
M	MMM
N	NNN
O	OOO
P	PPPPP
Q	QQ
R	RR
S	SS
T	TTT

So when User select the transaction, if [Name 1] is equal to [COMPANY OWNER], an image(text box) will be visible.

For example:

when User selected transaction 0000000001, the image will be visible because the [NAME1] is same as [COMPANY OWNER],

When User selected transaction 0000000006, the image will be hidden because [NAME1] is not the same as [COMPANY OWNER], because the [COMPANY OWNER} of 'O' is 'OOO'.

I tried using the following expression under image condition:

if(GetSelectedCount([TRANSACTION NUMBER]) = 0,0,
if([NAME 1] = [COMPANY OWNER],1,0)

)

but it did not work

I am unable to open .qvw files due to personal edition.  Screenshot or the expression directly here is appreciated.

[Anil_Babu_Samineni]

What if you have same values with 2/3 Matched You want to show those too

Try this way

if(GetPossibleCount([TRANSACTION NUMBER]) = 0,0,
if([NAME 1] = [COMPANY OWNER], 'qmem://<bundled>/BuiltIn/smiley3.png', 'qmem://<bundled>/BuiltIn/smiley3_y.png'))

And Then change it to Image and see

OR

if(GetPossibleCount([TRANSACTION NUMBER]) = 0,0,
if([NAME 1] = [COMPANY OWNER], 'qmem://<bundled>/BuiltIn/smiley3.png', 'qmem://<bundled>/BuiltIn/smiley3_y.png'), Chr(10))

[Anonymous]

Hi,

I tried the first expression, it only shows the second image, which is the "else" image even when the if condition is meet.

The second expression, I got an syntax error.

[Anil_Babu_Samineni]

Where this syntax error appears. Can you share the screen shot

Or try this

if(GetPossibleCount([TRANSACTION NUMBER]) = 0 and
if([NAME 1] = [COMPANY OWNER], 'qmem://<bundled>/BuiltIn/smiley3.png', 'qmem://<bundled>/BuiltIn/smiley3_y.png'), 1, 0)

Better offer if you would share the qvw

[Anonymous]

HI, I juz attach an qvw on the original post