Please advice! Extract dependent value from column

[#1]

Hello,

I have an access database linked in Qlikview with various tables and those tables have relationships(via primary key etc). For my case, consider Columns A B C and D. The user selects inputs from A, B and C ; these selections give the respective value from column D. I am having trouble extracting the value from column D. I thought of using a macro to extract the value in question; for which i need the exact cell number(row and column number combination). Any suggestions so as to retrieve the value that D reflects? or alternatively the cell number of the value in Column D ? Thank you, All your efforts are highly appreciated.  Please advice?

Regards,

Nik

[sunny_talwar]

Not sure what you mean by extracting here. Would you be able to share a sample and expected output?

Best,

Sunny

[#3]

A	B	C
1	2	3

D

1 2 3 4 5 5 6 7 8 9

Thanks for responding,

Find above an attempt to explain my case,

I have 4 columns A B C and D ,

when the user selects 1 2 3 from A B and C respectively

the value (marked in yellow from Column D is selected) ,

I need to extract that particular value. (have that value to be displayed in a text box or stored in a variable)

Best,

Nik

[sunny_talwar]

A, B, C, D are all part of a same table? and its hard to understand the table you have built, but is it something like this?

A	B	C	D
0	0	0	1
0	0	0	2
0	0	0	3
1	2	3	4
0	0	0	5
0	0	0	6
0	0	0	7
0	0	0	8
0	0	0	9
0	0	0	10

Where 0 can be replaced with other values?

[ramoncova06]

you can use this in your textbox, the assumption is that a,b,c have to be selected, otherwise you can switch the 'and' to 'or'

=if(GetSelectedCount(a)>0 and GetSelectedCount(b)>0 and GetSelectedCount(c) >0, concat(d,','))

[#6]

My apologies for a poorly constructed table. What you have is accurate, where the 0s can be replaced my any random values.

Thanks,

[#7]

The statement GetSelectedCount(a)>0 signifies that a value from A has been selected? Is that accurate?

Also, what if i have multiple values from A B and C selected which give me 2 rows in D.

Appreicate your help, Thanks.

[sunny_talwar]

There are couple of ways you can extract a value. One of them is rightly pointed out by Ramon Covarrubias‌ here. Another way if you know what your A, B, C values are, then you can use something like this:

Only({<A = {1}, B = {2}, C = {3}>} D)

HTH

Best,

Sunny

[#9]

Thank you for your responses Sunny and Ramon, I will try your suggestion and write back if i need help. Thank you again.

Best,

Nik

[ramoncova06]

The statement GetSelectedCount(a)>0 signifies that a value from A has been selected? Is that accurate? [RC] Yes

Also, what if i have multiple values from A B and C selected which give me 2 rows in D [RC] both will show separated by a ","