How to Secure/Lock my qvw file ?

[#1]

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

[#2]

Thanks everyone for helping

I will try section access

[#3]

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

[rubenmarin1]

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)

[#5]

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 ?

[rubenmarin1]

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.

[#7]

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.