Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
robert99
Valued Contributor II

Sheet Properties Conditional


I have set up a condition as follows:-

subfield (OSUser(),'\',2) = 'hh57906'
or subfield (OSUser(),'\',2) = 'hb53567'


or subfield (OSUser(),'\',2) = 'ss56686'

Initial only user hh57906 and hb53567 had access and ss56686 was excluded. This worked as it should

I then added ss56686 but the user still can not access this file

Does anyone know why this might happen?

Thanks for any help on this.

Edit

I tried saving this file under another name That is I saved the file under a different name and gave this user right to access this file

This worked


So it seems as if something has been saved on the users computer that has set the old preferences

Message was edited by: Robert Hutchings

Message was edited by: Robert Hutchings

1 Solution

Accepted Solutions
robert99
Valued Contributor II

Re: Sheet Properties Conditional

Thanks for your suggestions

I will try the above

I have also deleted the user and added back but it still made no difference

edit This solved the problem. I just had to wait for the quarantine period to expire and remove the user completely. And then log them back on

It seems for some reason that the user settings are locked

I have not had this problem before. That is I have changed other users settings

6 Replies
Not applicable

Re: Sheet Properties Conditional

I would maybe take a look and make sure that other user doesn't have different case letters,  upper() the whole statement and give that a try

Edit: Could also change the statement to a match instead

Match(Upper(subfield(osuser(),'\',2)),'HH57906','HB53567','SS56686')

hope that helps

Joe

robert99
Valued Contributor II

Re: Sheet Properties Conditional

Thanks

But it is lower case

I will try match and see if this amkes a difference

But it also includes for another sheet

subfield (OSUser(),'\',2) <> 'hb53567'
and subfield (OSUser(),'\',2) <> 'bb53571'
//and
//subfield (OSUser(),'\',2) <> 'ss56686'

He was excluded from this sheet but changed as follows. But he is still excluded

It seems like the initial setting can not be changed

thornofcrowns
Valued Contributor II

Re: Sheet Properties Conditional

Does Joe's MATCH statement work for you?

joshabbott
Contributor III

Re: Sheet Properties Conditional

Maybe try to 'trim()' it?

trim(OSUser())

If this doesn't work, try to add a text object to your application with the text =

subfield(osuser(),'\',2)

Maybe something about that user is different then others, maybe it has a different domain group or something strange

Not applicable

Re: Sheet Properties Conditional

I was thinking that too Josh, the subfield is removing the domain out though, which is why I thought about maybe case, does seem like something different on that user though

robert99
Valued Contributor II

Re: Sheet Properties Conditional

Thanks for your suggestions

I will try the above

I have also deleted the user and added back but it still made no difference

edit This solved the problem. I just had to wait for the quarantine period to expire and remove the user completely. And then log them back on

It seems for some reason that the user settings are locked

I have not had this problem before. That is I have changed other users settings

Community Browser