Get field value from corresponding record but different value

[Anonymous]

Hi,

So I have below table for example:

A	B
Tim	8
John	9
Mark	4

In my Dashboard in Qlik Sense I have a climber selection tool in which the user has the option to select a name (only one selection is possible). So if for Example the user chooses 'Tim", I want to return '8'. How can I write the code to put this in a variable?

Thanks!

[arulsettu]

how do you want to show this '8'   in texbox ?

[Anonymous]

For example, yes. In practice I have a column that I want to multiply with the value in column B, based on the selection that is made.

[OmarBenSalem]

in this column; to control the unique selection of columnA:

if(GetSelectedCount(ColA)<>1,'Please select only one ColA', sum(YourColumn) * sum(colB))

[Anonymous]

Thanks for you response! However, the selection is not made in column A but in another object which is similar to a list box (with only one selection), but this is not available in Qlik Sense.

[OmarBenSalem]

Not a problem; with ColA, I meant the field that is in column A: let's name it fieldA:

and the expression will work

[Anonymous]

Ah I see, Yes that would be an option, except I am using a selection tool as  in the attachment, so the user will actually only be allowed to make one selection.

[OmarBenSalem]

Yes I get it, It's just to control what's shown when there is no selection for example..

the expression is :

if(GetSelectedCount(Customer)<>1,'Please select only one customer', sum(Sales) * sum(Cost))

[Anonymous]

This only works if I use a field option instead of a variable, but I will do for know. Thanks for you help!

[darrell_tobin]

Hi Stijn,

In this case the easiest thing is to create table in excel with values, load it into your app then you can select the fields .