topic Re: How to show multiple possible values in listbox at front end? in QlikView

How to show multiple possible values in listbox at front end?

nikhilgarg — Wed, 25 Nov 2020 16:16:04 GMT

Hello All,

I have an issue. In my listbox i have multiple associated values of ntname. I want to compare OSuser() with multiple NTNames and where it matches it should return the corresponding Name. Can some one help me in this?

Re: How to show multiple possible values in listbox at front end?

Anil_Babu_Samineni — Tue, 12 Dec 2017 12:12:11 GMT

May be write list box as expression? Not sure, How ntname written??

If(OSUSER() = ntname, Name)

Re: How to show multiple possible values in listbox at front end?

nikhilgarg — Tue, 12 Dec 2017 12:19:53 GMT

Hey,

i have multiple NTNames. My scenario is security is implemented on basis of region. One region allocated to more than one person due to which when someone login, multiple ntnames shown. In case of multiple NTname, how would i compare with OSUser?

Re: How to show multiple possible values in listbox at front end?

YoussefBelloum — Tue, 12 Dec 2017 12:24:27 GMT

maybe this:

=if(wildmatch(OSUSER(),'*user1*','*user2*','*user3*','*user4*','*user5*','*user6*','*userx*')>0,Name)

Re: How to show multiple possible values in listbox at front end?

Anil_Babu_Samineni — Tue, 12 Dec 2017 12:26:14 GMT

What you mean?

My scenario is security is implemented on basis of region. One region allocated to more than one person due to which when someone login, multiple ntnames shown

Re: How to show multiple possible values in listbox at front end?

nikhilgarg — Tue, 12 Dec 2017 12:42:11 GMT

There are multiple ntnames, so hardcosing each and every name would be difficult