topic Decrypt a encrypted field in QlikView

Decrypt a encrypted field

Fri, 18 Dec 2015 07:00:05 GMT

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

Re: Decrypt a encrypted field

sunny_talwar — Fri, 18 Dec 2015 10:59:16 GMT

The calculation above is how you encrypted it?

Re: Decrypt a encrypted field

Fri, 18 Dec 2015 11:02:56 GMT

no Encrypted N could be any value

Re: Decrypt a encrypted field

sunny_talwar — Fri, 18 Dec 2015 11:10:45 GMT

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

Re: Decrypt a encrypted field

Fri, 18 Dec 2015 11:34:49 GMT

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

Peter_Cammaert — Fri, 18 Dec 2015 12:37:33 GMT

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

sunny_talwar — Fri, 18 Dec 2015 13:30:52 GMT

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 [

2345678067

];

Re: Decrypt a encrypted field

Mon, 21 Dec 2015 07:36:39 GMT

Thank you Sunny T

if the value N with braces [2345678067

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