security..

[#1]

i used section access to conditionally show the data to a particular user..i enabled the Initial Data Reduction Based on Section Access on the opening page of Document properties.. Also Prohibit Binary Load option is also enabled..

but now i want to create 3 groups say for eg, GROUP1, GROUP2,GROUP3..

Now each GROUP users should have access only to a particular sheet..

how to attain this..

[amars]

Hi,

On PostReduce Data u can run a macro & declare a variable to hold the value for the Group

set GroupValues = ActiveDocument.fields("Group").GetPossibleValues
SelectedGroup = GroupValues.Item(0).text
set varGroup = ActiveDocument.GetVariable("VariableForGroup")
varGroup.SetContent SelectedGroup,true

Now the Variable VariableForGroup has a value for the selected Group & based on the variable value in the conditional tag put a formula to make the sheet visible on or off.

Regards

Amar

[MichaelRobertshaw]

Why does every solution have to use a macro?????? No!!!

If your reduction is based on a Group then you already have your answer: Conditional Show properties of the Sheet can be "MixMatch([GROUP], 'Group1', 'Group 3') > 0" to allow Group1 or Group3 to see the sheet.

[#4]

First i used macro to achive the issue.. Then i realised and instead of going to macros i used expression in the sheet properties and achieved the same..

But now when i uncheck the options -

1.Save document(under security in doc properties)

2.Allow user reload(under security in doc properties)

so that when a particular person with USER access logs in , he cannot save or reload the file..

But when the above options are unchecked and when opening the file in user mode- access is denied

It works fine in the admin login access..

What may be the problem..

[amars]

It's not a problem, If a user with USER access is given access to reload then he will be able to see all the data, so it is designed in such a way not to allow all user's to reload the file & see all data after reload. It's not a problem but it is designed in such a way.

With Regards

Amar

[#6]

ok..fine..

but i logged in ADMIN mode,do some changes and save the file ..

Now when logged in USER mode, access is denied..

What may be the problem..

How can i resolve this..

[#7]

I am having the same issue...Did you get an answer to this issue?

[#8]

did you made any changes in the document security settings or the section access script?

Try reloading the document and save and close it. Then try to login in USER mode.

[#9]

The issue occurs when a ADMIN user makes changes to the document (without reloading it) and saves it. Qlikview then locks out all USER out of the document...giving "Access is denied".

Yes, a reload fixes this problem....but it will happen again when a ADMIN user makes changes to the document and saves it.

[Anonymous]

If for example the admin has access to data A and the user to data B, and the admin opens the document, it will be limited to data A.

Now, if he makes changes and saves the document without reloading, it will only contain data A and when the user logs in he gets denied since the document can't be reduced to show data B. However, since the admin can reload the document, he/she needs to do this after making the changes in order to pull all the data back in. If the admin is supposed to see everything you might want to look over the section access script.