topic Re: Restrict selection box in QlikView

Restrict selection box

Thu, 28 Jul 2016 16:25:52 GMT

Hi all,

Is possible to restrict a selection box based on the logged in user?

For example we have a selection box with multiple values (i.e. Site 1, Site 2 etc), however if a certain user opens the document I only want them to be able to select "Site 1".

Thanks in advance for any advice.

Anthony

Re: Restrict selection box

sunny_talwar — Thu, 28 Jul 2016 16:35:50 GMT

Have you thought about section access? If you don't want to do this, you may be able to use an if statement to do this:

If(WildMatch(OSUser(), '*User1'), If(Match([Site ID], 'Site 1'), [Site ID]), [Site ID])

Re: Restrict selection box

Thu, 28 Jul 2016 16:45:12 GMT

Hi,

Thanks for the quick response. Where would I apply such a If statement?

Re: Restrict selection box

sunny_talwar — Thu, 28 Jul 2016 16:53:47 GMT

As a list box expression

Re: Restrict selection box

Fri, 26 Aug 2016 07:13:49 GMT

Thanks for the advice, it worked perfectly.