topic Re: single field check with multiple field in QlikView

single field check with multiple field

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

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.

Re: single field check with multiple field

Anil_Babu_Samineni — Thu, 01 Dec 2016 02:16:19 GMT

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

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

Re: single field check with multiple field

Anonymous — Thu, 01 Dec 2016 02:54:24 GMT

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.

Re: single field check with multiple field

Anil_Babu_Samineni — Thu, 01 Dec 2016 02:58:50 GMT

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

Re: single field check with multiple field

Anonymous — Thu, 01 Dec 2016 03:13:07 GMT

HI, I juz attach an qvw on the original post