Discussion Board for collaboration on QlikView Scripting.
does anyone know how to decrypt a encrypted field by the value of ((+34)-1345)/245 at script level
N = ((Encrypted N +34)-1345)/245
Your Response will highly appreciated .
The calculation above is how you encrypted it?
no Encrypted N could be any value
Would you be able to share a sample with your expected output here?
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 ???
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)?
Sure thing, May be this:
((N+34) - 1345)/245 as Decrypt
Try this script for a sample (You might need a round() function for Rounding it to an integer)
Round(((N+34) - 1345)/245) as Decrypt
Thank you Sunny T
if the value N with braces [2345678067
which comes from the source so what should i do then ??