topic Disable lock/unlock function for user-login in QlikView

Disable lock/unlock function for user-login

pepe2209 — Thu, 04 Sep 2014 11:38:17 GMT

Hello,

is it possible to disable the lock/unlock settings for someone who is logged in as user via Section Access?

I ask this because i have the following problem:

I have company data divided over multiple countries. In my line-charts it is possible to show benchmark lines next to the selection lines. So if i've selected a german company, I can still add a benchmark line for entire England. Using the funtion:

sum({ 1<$(vCountry)=$::$(vCountry)>} Results) and vCountry=England in this case. So all selections are ignored exept for the possible values in the field 'England'.

This works perfect but now i want to limit user access to a country. If i use section access and limit the data to Germany, then I'm no longer able to show the benchmark England because the data is blocked.

So i thought i might work around this by applying user access WITHOUT data restrictions. but instead add actions upon opening and make a selection in the field country depending on user and then lock this field. This could work if the user is not able to unlock the field afterwards.

This or another suggestion to my problem is very appreciated!

regards,

Peter

Re: Disable lock/unlock function for user-login

Anonymous — Thu, 04 Sep 2014 11:43:16 GMT

Is there a reason why the Germans should not see the English data ? You say they already need some access for the benchmark line.

I am an advocate of open data, unless there is a valid reason to keep it secret / confidential.

Re: Disable lock/unlock function for user-login

pepe2209 — Thu, 04 Sep 2014 11:48:51 GMT

Yes i want the indivual english company data to be secret towards a german user. but i do want to show the entire english benchmark based upon the sum (or whatever function) of the english companies.

Re: Disable lock/unlock function for user-login

sudeepkm — Thu, 04 Sep 2014 11:57:22 GMT

I do not think there is an option to prevent unlock and lock in QlikView document for an end user. but better to wait for expert's opinion.

the lock unlock appears in list box, table box and current selection box. I'm sure you will not have a list box for country as the data is restricted to one Country but the current selection will have the field country visible. can you some how have a text object over layered on the current selection box Country field. not a good idea but worth trying.

Re: Disable lock/unlock function for user-login

pepe2209 — Thu, 04 Sep 2014 14:14:07 GMT

You would still be able to clear selections and select another non german company.

but your suggestion did lead to another idea:

I load the section acces with USERID from an excel file.

I also load USERID as user and country from the same file.

And now upon opening the country linked to the user is selected (via action select in field user -> QVUser(). ) and the selection is locked.

Also i've added a giant textbox hovering over the entire application which is conditionally shown if count(distinct(user))>1. So when the user unlocks and deletes the selection the textbox appears blocking the application. alongside the textbox a button appears which will reselect the user: QVUser() which is linked to the country. therefore you will never be able to hide the textbox without having to select your country.

security wise it's not perfect, but it's something.