Check if user input (variable input) is present in field and change sheet according to input

[Chrvs]

Hi

I am new to Qlik Sense and I haven't figured the terminology out yet, so bare with me.

I am trying to work out a sort of login mechanism and I hope someone can tell me whether it is possible or not.

First of all, I loaded a single column (field?) Excel table with different ID's into Qlik Sense. Now when I start the Qlik Sense app I wish to have a sheet with an input box (variable input) for user input and a button beneath with the text "Login" on it. When the user has written an ID in the input box and presses the "Login"-button I want the app to check whether the ID written in the input box is present in the field of the loaded table.

In case the ID written in the box matches an ID from the field of the loaded table I want the app to jump to sheet 2 and in case there are no match I want it to jump to sheet 3.

Is this possible and in case it  is can anyone give me a hint in how to go about it?

Thanks

[Or · Accepted solution]

I'm kind of confused by this whole concept... wouldn't it be easier to either teach the users to switch sheets, or just link them directly to the sheet you want opened? What you're suggesting won't act as any form of security, after all, just navigation. Users not in the table will be able to open sheet 2 and see all the data.

[Chrvs]

I wasn't aware that you would be able to see all sheets no matter what. Thanks for the answer 🙂

[Or]

Glad to help. If you'd like to set up security, have a look at using Section Access instead.

[Chrvs]

I will look into that, thanks 🙂