topic How do I include information from my Section Access Excel sheet? in QlikView

How do I include information from my Section Access Excel sheet?

Thu, 26 Nov 2009 23:09:28 GMT

Hi,

I would like to include information from the Section Access Excel sheet in the actual QlikView application. For instance, I would like to show the full name (not the user name) and department of the logged on user in the application, but I haven't found a way to do this.

Any ideas are welcome.

Thanks,

Magnus

How do I include information from my Section Access Excel sheet?

prieper — Thu, 26 Nov 2009 23:27:07 GMT

The tables loaded in section-access are not visible. A Possible way might be load load the table a second time in the normal application (might still be in the hidden part) and to load just username and add information. The username is contained in the variable QVUSER() - if working with extra username or in OSUSER(), corresponding to the NT-name.

HTH
Peter