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]

No problem bud! Always here to help.

Best,

Sunny

[#3]

Hi,

Is there a way i can assign the extracted value to a variable using a macro or otherwise?  something using a 'set' statement ? Thanks,

sunindia‌

[sunny_talwar]

You can do this by going in your Variable Overview (Ctrl + Alt + v) and create a new variable

vVar = Only({<A = {1}, B = {2}, C = {3}>} D) or if(GetSelectedCount(a)>0 and GetSelectedCount(b)>0 and GetSelectedCount(c) >0, concat(d,','))

What is your end goal, if you don't mind me asking? Because we might be able to help you better if we know what you are trying to do.

Best,

Sunny

[#5]

Sunny,

This was the end game. I needed to access that value in a variable. To be honest it was a stupid question to ask how to set it to a variable especially after i have the definition statement. I appreciate your patience, Thanks a lot.

[sunny_talwar]

Nothing is stupid my friend. We all are learning, I actually learn more as I work on stupid things. So keep asking and keep trying.

Best,

Sunny