Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Filter option missing for field when using section Access with Omit in Qlik sense

In visualizations the fields not listed in Omit fields don't show the search/filter option(lens icon)

userID      unit       Omit

X              23       

Y             44         Gender

Z             44         Gender

Although User X, has access to data  under 'Gender' column, the filter icon is missing as noted below.

Any help to get the Search option. or this functionality missing in Qlik sense?

Thanks,

Abirami

3 Replies
Not applicable
Author

Hi,

in related to the above question, the fields i wanted to Omit are  measures and not dimensions.

if not using measures, the omit condition is not working.

Thanks,

Abirami.

Anonymous
Not applicable
Author

Hi, Abirami.

I've tested the following section access script:

//--------------------------------------------

Section Access;

SecurityTable:

Load * Inline [

ACCESS, USERID, OMIT

USER, DEV-QLIK\Administrador,

USER, DEV-QLIK\BDM,

USER, DEV-QLIK\SCS, Saldo_Carteira

USER, DEV-QLIK\VCV, Saldo_Carteira

ADMIN, INTERNAL\SA_SCHEDULER, *

];

Section Application;

//data script load

(...)

//--------------------------------------------

As a result, I got the following simple table for user BDM:

BDM user - full acess.png

Note that the field "Saldo_Carteira" is a measure (numbers) and the magnifying glass is appearing.

Logging as SCS, I faced an incomplete visualization due to the field restriction:

SCS user - incomplete visualization.png

I'm using Qlik Sense Enterprise 2.1 (Chrome and IE).

Hope that helps.

Regards

Nayam Hanashiro

Not applicable
Author

Thanks Hanashiro.

This helped me a lot.

Abirami