Hide object based on User Group

[venkatg6759]

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

[Oleg_Troyansky]

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

[venkatg6759]

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 ..

[Oleg_Troyansky]

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

[evan_kurowski]

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'?

[Oleg_Troyansky]

Evan - yes, I think so.