topic Re: Who ran the report?--silly question in QlikView

Who ran the report?--silly question

rdsuperlike — Thu, 04 Feb 2016 01:14:28 GMT

I want to check on who ran the dashboard..

The function is osuser().

But i get NA\Elsa as result.

How do i get just "Elsa"?

Thanks

sunny_talwar — Thu, 04 Feb 2016 01:15:48 GMT

May be this:

=SubField(OSUser(), '\', 2)

=SubField(OSUser(), '\', -1)

jagan — Thu, 04 Feb 2016 01:41:44 GMT

Hi,

Try

SubField(OSUser(), '\', 2)

=Mid(OSUser(), Index(OSUser(), '\') + 1)

Hope this helps you.

Regards,

jagan.

avinashelite — Thu, 04 Feb 2016 06:41:41 GMT

subfield(OSUSER(),'\',2)