topic Re: current selection issue in QlikView

current selection issue

Anonymous — Sun, 25 May 2014 11:16:20 GMT

Hello All

I have a request to scramble a spastic field in the model - i found a code where u keep moving 2 digits around and multiple them and i got a scrambled field

The problem is that i cant do it in the script and in the Current selection i can see the original field

any way to scramble the current field also in the current selection ???

thanks

Re: current selection issue

swuehl — Sun, 25 May 2014 12:42:48 GMT

Would be helpful if you could describe your issue in more detail, how your data looks right now, how you want it to look, what code you have used so far, where this used code fails to work etc.

Re: current selection issue

rwunderlich — Sun, 25 May 2014 14:01:48 GMT

An easy way to scramble a field in the script is with the Hash function.

Hash128(myfield) as myfield

If you want to maintain the same length for the scrambled field:

left(hash256(myfield),lenmyfield)) as myfield

That assumes the string being translated is no longer than 32 characters -- which is the length of the string returned by Hash256.

-Rob

Re: current selection issue

Anonymous — Mon, 26 May 2014 09:19:21 GMT

Thanks Rob

But i need to scramble the field post reload, I need to check if the OSuser has privilege to see the information if not i need to scramble the field.

I thought of doing it with a macro that checks which OSuser has opened the model and if he has the privilege to see the info , something like this

If (user has privilege) then

ActiveDocument.ScrambleField "MM",false
Else
ActiveDocument.ScrambleField "MM",true
End If

The thing is I keep on getting a scrambled field not sure I wrote the VB command correctly does false mean don’t scramble and true means scramble ( I’m new in the VB script )

Many thanks

Re: current selection issue

rwunderlich — Mon, 26 May 2014 15:21:45 GMT

The API doc says the second parm should always be false. If don't want to scramble for a particular user, don't invoke the ScrambleField at all for that user.

-Rob

Re: current selection issue

SunilChauhan — Mon, 26 May 2014 15:26:12 GMT

i thing whaterver formula you are using

you should use in variable

i mean define variable in script and use that variable with $(Variable) @ front end

hope tha might helps