topic Re: How to Secure/Lock my qvw file ? in QlikView

How to Secure/Lock my qvw file ?

Tue, 21 Apr 2015 11:18:49 GMT

Hi,

I work for a company that makes BI application for Banks.... My problem is that our customers can explore the qvw file that we use to generate the application in AJAX. They can extract it and open it using qlikview developper. I have no problem if they see the database or the script but I need to protect my variables since they contain the formulas.

Thus, is there a way to protect my qvw file or my variables...?

Thank you

Re: How to Secure/Lock my qvw file ?

Tue, 21 Apr 2015 11:23:07 GMT

Hi ,

you can use Section access.

Hope this helps u ...

Re: How to Secure/Lock my qvw file ?

ali_hijazi — Tue, 21 Apr 2015 11:23:09 GMT

you need to add section access

in script editor Insert->Section Access->Inline

then after adding the section access you can add your customers as USER not ADMIN

and then in the Document Properties->Security you can remove all permissions related to script editing etc....

refer to Reference Manual for more information

Re: How to Secure/Lock my qvw file ?

Tue, 21 Apr 2015 11:25:52 GMT

Hide your script by writing code in the Hidden script.

Re: How to Secure/Lock my qvw file ?

amit_saini — Tue, 21 Apr 2015 11:27:03 GMT

Firas,

Check :

https://community.qlik.com/message/652162#652162

Re: Creating new qvw file and implement section access.

Thanks,
AS

Re: How to Secure/Lock my qvw file ?

ali_hijazi — Tue, 21 Apr 2015 11:28:20 GMT

putting the script in hidden script will prevent user from being able to debug script and if there was an error you won't be able to see the error message

hidden script is used to put the section access script only

Re: How to Secure/Lock my qvw file ?

amit_saini — Tue, 21 Apr 2015 11:28:43 GMT

Also for hidden script, check:

https://community.qlik.com/message/585957#585957

Thanks,

Re: How to Secure/Lock my qvw file ?

rubenmarin — Tue, 21 Apr 2015 11:30:18 GMT

Hi firas, when I have variables to store formulas I usually put them in outside txt file adding to the script with include. Sometimes I inserted those directly on script.

This way after reload reload all varibles are reseted to their original values.

It's a bit tricky because of quotes and dollar signs, wich need to be converted using Chr() or an auxiliar character that needs to be translated using replace().

Re: How to Secure/Lock my qvw file ?

buzzy996 — Tue, 21 Apr 2015 11:33:19 GMT

u can try this way,

1.u can write ur scripts in text files and call those from qvw ,that makes protect ur scripts

as some one said on above

2.implement section access with hidden scripts

Re: How to Secure/Lock my qvw file ?

Tue, 21 Apr 2015 11:47:49 GMT

Hi Ruben,

Thank you for helping me. What do you mean by the variables are reseted to their original values ?

Re: How to Secure/Lock my qvw file ?

Tue, 21 Apr 2015 11:49:19 GMT

Thanks everyone for helping

I will try section access

Re: How to Secure/Lock my qvw file ?

Tue, 21 Apr 2015 11:51:10 GMT

Hi Elakkian,

Thank you for helping. Do I restrict my application under AJAX if I use section access or it is only restricted under developer.

Thank you

Re: How to Secure/Lock my qvw file ?

rubenmarin — Tue, 21 Apr 2015 11:54:14 GMT

Hi firas, not sure if I understand it right, if you are worried for users changing variables values and messing with the formulas, keeping those in a separated file makes it easier to reset, so any reload will Set the variable values to default (Using SET or LET in script to recreate the variables)

Re: How to Secure/Lock my qvw file ?

Tue, 21 Apr 2015 11:56:52 GMT

I use the variables to store my formulas and I don t need other user to see them. So if i reset them how the calculation will be proceed ?

Re: How to Secure/Lock my qvw file ?

rubenmarin — Tue, 21 Apr 2015 12:44:03 GMT

I meant reset as set to their original values, not to empty them, ie:

SET vSales = "=Sum(Sales)";

If this is loaded in script, the value of the varible will be set to =Sum(Sales) after each reload.

I use that approach when there are variables I don't what the user changes but also there are variables the user can change (dates, simulations...).

But as I said maybe I misunderstood and this is not what you are looking for.

Re: How to Secure/Lock my qvw file ?

Tue, 21 Apr 2015 18:01:55 GMT

Hi Ruben,

Thank you for taking the time to answer. I think I didn t express myself well. I have no problem with users to change variables values. In fact they can t since I only use variables to store formulas and as you said I let them change dates... My problem is that I don t want them to access to the variables and see the formulas I use.