Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 | |
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.
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))
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.
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
HI, I juz attach an qvw on the original post