Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
You have to do this in Section Access
data level security using section access
Can you add a Screenshot ?
is there any solution without using section access
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).
Can you try this once
If(Match(OSUSER(),'INTRA\x.user') = 'INTRA\x.user' , If(OpEx_Category ='TRAINING',OpEx_Category), OpEx_Category)
this?
if(OSUser()='INTRA\x.user' and OpEx_Category ='TRAINING',OpEx_Category)