Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
You could look into the Qlik Sense Dashboard Bundle Navigation buttons. Besides navigation you can use then to make selections in your data model.
Read more about it here: https://help.qlik.com/en-US/sense/April2019/Subsystems/Hub/Content/Sense_Hub/Visualizations/Dashboar...
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 ?
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
OR
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.