topic Re: Hide object based on User Group in QlikView

Hide object based on User Group

venkatg6759 — Fri, 11 Sep 2015 20:47:06 GMT

Hello,

I am trying to hide object based on user groups.I am able to hide based on User ID but unable to do by Group. Any suggestions?

I tried Mixmatch(OSUSER(),'DOMAIN\GROUPNAME','DOMAIN\...').

Thanks,

Venkata

Re: Hide object based on User Group

Oleg_Troyansky — Fri, 11 Sep 2015 21:09:43 GMT

One way is to create another field in Section Access, for example GROUP, and load the corresponding group value into it.

Then, you need to load the same field once again in Section Application, and associate it with one of your application fields (even if it's a dummy island field).

Once you did that, the application field would be available to your Show/Hide conditions like any other data filed.

cheers,

Oleg Troyansky

QlikView Your Business: An expert guide to Business Discovery with QlikView and Qlik Sense

Re: Hide object based on User Group

venkatg6759 — Fri, 11 Sep 2015 21:29:35 GMT

Hi Oleg,
I have Section access defined at Datamodel.qvw level and I am doing this in UI which is using binary. I tried implementing on top of binary but it didn't work .Any other ways ..

Re: Hide object based on User Group

Oleg_Troyansky — Fri, 11 Sep 2015 21:48:43 GMT

Can you implement it in the data model? You will just add the "group" field there, and then use it in the UI?

Re: Hide object based on User Group

evan_kurowski — Sat, 12 Sep 2015 18:42:48 GMT

Hello Oleg,

Thank you for the technique explanation. For this to work do you have to turn on 'Initial Data Reduction Based on Section Access'?

Re: Hide object based on User Group

Oleg_Troyansky — Sat, 12 Sep 2015 18:56:36 GMT

Evan - yes, I think so.