Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
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
sunny_talwar

The calculation above is how you encrypted it?

Not applicable
Author

no Encrypted N could be any value

sunny_talwar

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

Not applicable
Author

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

Peter_Cammaert
Partner - Champion III
Partner - Champion III

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

sunny_talwar

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
Author

Thank you Sunny T

if the value  N with braces  [2345678067

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