restriction

[master_student]

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

[Anil_Babu_Samineni]

You have to do this in Section Access

data level security using section access

[Anonymous]

Can you add a Screenshot ?

[master_student]

is there any solution without using section access

[kamal_sanguri]

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

[Anil_Babu_Samineni]

Can you try this once

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

[Kushal_Chawda]

this?

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