Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
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
Thanks Hanashiro.
This helped me a lot.
Abirami