topic Re: Hide listbox based on Section Access in QlikView

Hide listbox based on Section Access

Mon, 26 Jan 2026 18:19:17 GMT

Hi,

I have two user groups with separate logins to my QVW.

How can I alter the apperance of certain objects based on a users access login?

Many Thanks

Re: Hide listbox based on Section Access

vgutkovsky — Mon, 19 Nov 2012 14:58:45 GMT

Brian,

The simplest way to do that would be to create an island that contains one or more flags. Add these flag values to your section access reduction fields. Then hide/show objects based on whether a flag value exists.

Regards,

Vlad

Re: Hide listbox based on Section Access

Mon, 19 Nov 2012 15:02:10 GMT

Thanks for the help, how can I create an Island with flags?

Re: Hide listbox based on Section Access

vgutkovsky — Mon, 19 Nov 2012 15:35:28 GMT

Just create a simple inline table with fields in all-caps like this:

myIsland:

LOAD * INLINE [

HIDEFLAG

];

Then in section access, you can have something like this for example:

NTNAME	ACCESS	HIDEFLAG
BOB	USER	1
DAVE	ADMIN	0

If you have a listbox you want to hide, under Layout make the conditional show condition max({1} HIDEFLAG)=0

Regards,

Vlad

Re: Hide listbox based on Section Access

Mon, 19 Nov 2012 16:38:53 GMT

Thats great, thank you

I have one question..

Can you explain this code - max({1} HIDEFLAG)=0

Is there another way of saying - =IF(HIDEFLAG=0, listbox.visible = False)

I know that isnt the correct code, but is there something similar?

Thanks

Re: Hide listbox based on Section Access

vgutkovsky — Mon, 19 Nov 2012 17:20:45 GMT

Well, almost. Section Access works like any other table in QlikView in terms of reductions--except that the reductions are permanent. So the section access code above will ensure that when BOB logs in, the HIDEFLAG value in the data model will only have a value of 1. Therefore, max({1} HIDEFLAG)=0 will return false and the listbox will be hidden.

Glad to help--please verify correct answers

Vlad

Re: Hide listbox based on Section Access

Bill_Britt — Tue, 20 Nov 2012 13:10:33 GMT

Like to give an example of this. The attach document has three users and based on the user it will either show or hide the SalesPerson List Box.

Dave is the Admin and will see the list box

Bob is a User and will not see the list box

Bill is a User and will see the list box.

This is based on the code that Vlad provided. The Condition to show or hide the list box is on the Layout Tab under the List Box properties.

Bill