Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
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

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

Community Browser