# QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Rules, plus terms and conditions, can be found here.
Not applicable

## Decrypt a encrypted field

Hi all..

does anyone know how to  decrypt a encrypted field by the value of ((+34)-1345)/245 at script level

Example:

N = ((Encrypted N +34)-1345)/245

Your Response will highly appreciated .

Thanks

Regards

RHS

7 Replies
MVP

## Re: Decrypt a encrypted field

The calculation above is how you encrypted it?

Not applicable

## Re: Decrypt a encrypted field

no Encrypted N could be any value

MVP

## Re: Decrypt a encrypted field

Would you be able to share a sample with your expected output here?

Not applicable

## Re: Decrypt a encrypted field

suppose N = 2345678067

so i need when ((2345678067 +34)-1345)/245

now the result is  9574191

so my question, is this possible at script level ???

## Re: Decrypt a encrypted field

So actually you mean:

Encrypted N = ((N +34)-1345)/245

By performing the reverse operation? Although for many values you may not be able to reverse the process as calculations in R are bound to loose some information. Do you plan to calculate with a pair of values (quotient/remainder)?

MVP

## Re: Decrypt a encrypted field

Sure thing, May be this:

((N+34) - 1345)/245 as Decrypt

From Source;

Try this script for a sample (You might need a round() function for Rounding it to an integer)

Table:

Round(((N+34) - 1345)/245) as Decrypt

Inline [

N

2345678067

];

Not applicable

## Re: Decrypt a encrypted field

Thank you Sunny T

if the value  N with braces  [2345678067

which comes from the source  so what should i do then ??