Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
Not applicable

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.

Highlighted
Contributor II
Contributor II

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

Highlighted
Not applicable

Thanks Hanashiro.

This helped me a lot.

Abirami