topic Re: Make Matched Value the Current Selection in App Development

Make Matched Value the Current Selection

Brip51 — Mon, 24 Jun 2019 16:03:44 GMT

Hi,

I have an app I am working on. I have an input variable box that allows a user to input a string. I have an ID value in my data that is always 10 characters. My goal is to match and select an ID based on what the user inputs. I take the input and substring it to 10 characters (Left(vInput,10)). I can then match it to my ID. After I do that I need to make that matched ID the currently selected ID. That is where I am stuck.

For example -

User pastes the value FDPZ135679xxx into the input variable box.

I take that and say -

If(MixMatch(ID(Left(('$(vInput)',10)=1,ID))

Then I can display the ID, but I need to make that matched ID the current selection.

Is there a way to do that?

Any help would be appreciated.

Brian

Re: Make Matched Value the Current Selection

Vegar — Mon, 24 Jun 2019 18:50:42 GMT

You could look into the Qlik Sense Dashboard Bundle Navigation buttons. Besides navigation you can use then to make selections in your data model.

Re: Make Matched Value the Current Selection

Brip51 — Mon, 24 Jun 2019 20:39:24 GMT

Hi Vegar,

Thanks for the response.

I took a look at this,but I did not see how this would work for me. Maybe I am not understanding how this could work ?

Re: Make Matched Value the Current Selection

Vegar — Mon, 24 Jun 2019 21:09:05 GMT

My thought was that after you pasted the variable into your input box then
you could trigger the selection by pressing a button that is configured to
selecting values according to your criteria.

Re: Make Matched Value the Current Selection

Brip51 — Tue, 25 Jun 2019 14:51:16 GMT

Ah.... Yes that is what I thought. It makes sense, but I can display the matched value and they could just click on that to select so one would be the same as the other as far as users are concerned.

What I am trying to do after all the logic is done is display a table IF any ID is selected

IF the user enters an a value and it matches an ID

It is a strange user requirement and I really haven't figured out a way to do it.