topic Re: restriction in QlikView

restriction

master_student — Wed, 14 Jun 2017 09:22:31 GMT

Hello Guys,

I would like to add a condition in y table so that a user x see only category training, i did that but it didn't work

If(OSUser()='INTRA\x.user' , If(OpEx_Category ='TRAINING',OpEx_Category), OpEx_Category)

any idea

Thanks

Re: restriction

Anil_Babu_Samineni — Wed, 14 Jun 2017 09:24:38 GMT

You have to do this in Section Access

data level security using section access

Re: restriction

Anonymous — Wed, 14 Jun 2017 09:27:10 GMT

Can you add a Screenshot ?

Re: restriction

master_student — Wed, 14 Jun 2017 09:29:56 GMT

is there any solution without using section access

Re: restriction

kamal_sanguri — Wed, 14 Jun 2017 10:02:06 GMT

The calculated dimension seems OK and I don't see any reason why it is not working.

Use a text box to check what this function [OSUser()] gives you.. copy it as it and then use it.. may be there is some difference. You also need to ensure that the case is same (Qlikview is case sensitive).

Re: restriction

Anil_Babu_Samineni — Wed, 14 Jun 2017 10:06:36 GMT

Can you try this once

If(Match(OSUSER(),'INTRA\x.user') = 'INTRA\x.user' , If(OpEx_Category ='TRAINING',OpEx_Category), OpEx_Category)

Re: restriction

Kushal_Chawda — Wed, 14 Jun 2017 11:10:09 GMT

this?

if(OSUser()='INTRA\x.user' and OpEx_Category ='TRAINING',OpEx_Category)