Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

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

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

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)?

Re: Decrypt a encrypted field

Sure thing, May be this:

LOAD N,

          ((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:

LOAD N,

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

Inline [

N

2345678067

];


Capture.PNG

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 ??