topic Re: Filter option missing for field when using section Access with Omit in Qlik sense in App Development

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

Thu, 04 Feb 2016 07:09:23 GMT

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

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

Fri, 05 Feb 2016 08:17:01 GMT

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.

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

Anonymous — Mon, 15 Feb 2016 01:33:55 GMT

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:

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:

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

Hope that helps.

Regards

Nayam Hanashiro

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

Mon, 15 Feb 2016 05:29:17 GMT

Thanks Hanashiro.

This helped me a lot.

Abirami