topic Re: Eliminate hard coding in QlikView

Eliminate hard coding

Anonymous — Sun, 30 Aug 2015 16:23:58 GMT

Hi gurus

I have user I'd,name in my section access field.

I have text object in dashboard. It will display user name.

I written in text object like bellow.

If qv user =1,janson,

If qv user=2,Michele,admin.

Issue:if any user added in section access excel sheet.

If statement can't display the login user name in dashboard.

How to proceed on this situation.

Thanks in advance.

Re: Eliminate hard coding

marcus_sommer — Sun, 30 Aug 2015 16:37:19 GMT

To display the username you didn't need any if-loop you could simply use:

= osuser() // NT-User from access point

= qvuser() // section access user - might be different if you didn't use the NT-User for the section access

- Marcus

Re: Eliminate hard coding

Anonymous — Sun, 30 Aug 2015 16:46:15 GMT

Osuser and qv user will display user IDs .am I right?

I want to display corresponding name of the user

Thanks for your time

Re: Eliminate hard coding

jagan — Sun, 30 Aug 2015 16:47:07 GMT

Hi,

You can simply try

OsUser() Or QVUser() functions for this, no need of if().

Regards,

Jagan.

Re: Eliminate hard coding

jagan — Sun, 30 Aug 2015 16:49:45 GMT

Hi,

Load one table with user master table details like below

UserID, Name

1, janson

2, Michele

Now in expression use like below

=Only({<UserID={'$(=OSUser())'}>} Name)

=Only({<UserID={'$(=QVUser())'}>} Name)

Hope this helps you.

Regards,

Jagan.

Re: Eliminate hard coding

jagan — Wed, 02 Sep 2015 05:32:30 GMT

Hi Babu,

If you got the Answer close this thread by giving Correct Answer to the helpful post.

Regards,

Jagan.