So I have below table for example:
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?
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.
in this column; to control the unique selection of columnA:
if(GetSelectedCount(ColA)<>1,'Please select only one ColA', sum(YourColumn) * sum(colB))
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.
Not a problem; with ColA, I meant the field that is in column A: let's name it fieldA:
and the expression will work
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.
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))
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 .