topic How may I get in Edit Module the user connected? in QlikView

How may I get in Edit Module the user connected?

Fri, 01 Oct 2010 17:37:55 GMT

HI,

How may I get in Edit Module the user connected?

I would like to set default filters depending on current user.

I have create a button and a macro

sub selectDefault

ActiveDocument.ClearAll

Myuser = QVUser ()

if Myuser = "XX" Then ….

But it doesn't work. The error message (in edit module) is

Type mismatch: 'QVUser'

How I can do it?

Thanks

Best Regards

Marilena

How may I get in Edit Module the user connected?

Fri, 01 Oct 2010 18:28:17 GMT

Hi there, you are having that error because you are trying to evaluate qlikview functions directly in the macro script, this can only be accomplish in the following manner:

sub selectDefault

ActiveDocument.ClearAll

Myuser = ActiveDocument.Evaluate("qvuser()")

end sub

Best Regards

How may I get in Edit Module the user connected?

Fri, 01 Oct 2010 23:26:32 GMT

Hi Marilena,

My suggestion is to let the users create their own personal bookmarks and not program it at all. You don't want to have to keep updating your program whenever there's a new user or a user decides he wants different filters.

Regards,

Barry

How may I get in Edit Module the user connected?

Mon, 04 Oct 2010 11:36:04 GMT

Hi,

thanks a lot both of you (Ivan and Barry)

I'll do both solutions because some of my users are managers and I have to configure everything for their users

Ciao

Marilena