topic Re: Want to Hide List box when Field used in it is OMITed for few users. in QlikView

Want to Hide List box when Field used in it is OMITed for few users.

Mon, 26 Jan 2026 18:19:17 GMT

Hi Guys,

I have application where have Field AccountID. This AccountID is having OMIT in section Access for few of the users.

and in application we have used AccountID in list box.

So suppose for User A OMIT is not applicable so he should see list box in application but for User B AccountID is MOIT and then AccountID is hidden for him in application. When User B is log in he is not seeing any AccountID values but empty list box is still displaying.

What I want that for User B list box also should be hidden. So show the list Box Account ID to those users for whom AccountID is not OMIT and hide for those users for whom AccountId OMIT is applicable.

How can I do this in list box.?

Section Access is working fine.

Re: Want to Hide List box when Field used in it is OMITed for few users.

danieloberbilli — Fri, 08 May 2015 02:25:57 GMT

Not sure if you can set a condition based on the OMIT field, but as a workaround you could use exactly the same concept as hiding sheets (pfa the document from Qlik, page 11...).

Beside of the sheet access, I always add some columns for Object access (show/hide).

Re: Want to Hide List box when Field used in it is OMITed for few users.

Fri, 08 May 2015 03:31:39 GMT

Daniel,

Thank you for sharing document which is helpful in understanding Sheeting hiding based on section access.

I am trying with condition Count(DISTINCT [AccountID ])>0 adding in Layout-->Show-->Condition

but when I log in with user B, It is displaying X symbol Under General-->Field of list box with message AccountID (unavailable)

Guys, I hope there should some simple method to hide this.

Please suggest.

Re: Want to Hide List box when Field used in it is OMITed for few users.

danieloberbilli — Fri, 08 May 2015 03:40:07 GMT

If AccountID is not available (due to OMIT) then you cant use it in a condition as Qlik cannot compute your expression with an unknown field. But if you use the technique and the expression like described in SheetAccess it shouldnt be any problem (e.g. have a column called ObjectAccountID with a 0 for User B and use the expression sum(ObjectAccountID)>=1) in the listbox/object

Re: Want to Hide List box when Field used in it is OMITed for few users.

Fri, 08 May 2015 04:07:34 GMT

Daniel,

Is that possible for you to provide a sample qvw for hiding sheet. I am trying on mine but it is not working.

If you don't have I will create a sample one and share with you.

Re: Want to Hide List box when Field used in it is OMITed for few users.

danieloberbilli — Fri, 08 May 2015 04:27:56 GMT

user a --> shows listbox with AccountID

user b --> no AccountID listbox

Re: Want to Hide List box when Field used in it is OMITed for few users.

petter — Fri, 08 May 2015 05:20:37 GMT

A simple expression you could use to test whether a field exists at all is this:

=Count( {<$Field={aFieldName}>} $Field)=1

Which you could use as the expression in Show Conditional for the List Box.

Re: Want to Hide List box when Field used in it is OMITed for few users.

petter — Fri, 08 May 2015 05:22:58 GMT

$Field is one of the standard meta-fields of any QlikView application. It simply contains a list of all fields in your running application. QlikView populates these meta-fields while running the load script or any time the data model changes.

They are referred to as System Fields too.

Re: Want to Hide List box when Field used in it is OMITed for few users.

petter — Fri, 08 May 2015 05:27:54 GMT

Re: Want to Hide List box when Field used in it is OMITed for few users.

Fri, 08 May 2015 06:37:33 GMT

Hi Petter,

What you have suggested (Count( {<$Field={aFieldName}>} $Field)=1) is working perfectly when hiding a list box when field used in it is OMIT.

I am facing issue in hiding sheet. It is not working for my application. Please somebody look into it and let me know what wrong I have done here?

Please find attached Qvw and Excel.

Re: Want to Hide List box when Field used in it is OMITed for few users.

danieloberbilli — Fri, 08 May 2015 06:42:31 GMT

access denied ...could you reload it without section access, save and post it again

Re: Want to Hide List box when Field used in it is OMITed for few users.

Fri, 08 May 2015 06:48:50 GMT

Hi Daniel,

In Excel you can give NTNAME then you might be able to open.

Anyway I have attached the QVW after removing Section Access

Re: Want to Hide List box when Field used in it is OMITed for few users.

danieloberbilli — Fri, 08 May 2015 06:49:01 GMT

just an idea...but maybe you considered that already: make sure you checked Initital Data Reduction in the Document properties on tab Opening:

Re: Want to Hide List box when Field used in it is OMITed for few users.

Fri, 08 May 2015 06:53:09 GMT

It is already checked.

Actually, my application was working with Section access. On same application I tried implementing show and hide sheets.

I am afraid, I have changed some setting either at sheet or document level and that is causing issue with Hide and Show Sheet.

Re: Want to Hide List box when Field used in it is OMITed for few users.

danieloberbilli — Fri, 08 May 2015 07:11:05 GMT

in the sheet condition: insert '='

Re: Want to Hide List box when Field used in it is OMITed for few users.

Fri, 08 May 2015 07:17:18 GMT

Thanks Daniel.

Silly mistake and that's y It was displaying both the sheets.

It is working now.

Attached qvw after correction