topic Re: Creating variable, replacing Dollar $ in QlikView

Creating variable, replacing Dollar $

zagzebski — Wed, 21 Oct 2015 00:08:51 GMT

I need to write this into a variable but having some issues. Tried to replace the $-sign with chr(36) but could not get it to work:

only({<[User NT Name]={'$(=OSUser())'}>} [User Role])

Tried this:

Set vNavMenuTotAccess = =if(only({<[User NT Name]={'& chr(36) &(=OSUser())'}>} [User Role])='TOTAL_ACCESS',1,0);

Thanks

Zag

Re: Creating variable, replacing Dollar $

petter — Wed, 21 Oct 2015 00:12:52 GMT

If you do a:

Concat( {<[User NT Name]={'$(=OSUser())'}>} [User Role] , ' / ' )

In a Text Box or an Input Box ... do you get any values at all or several?

Re: Creating variable, replacing Dollar $

jagan — Wed, 21 Oct 2015 03:17:40 GMT

Hi,

I think NTNAME and OSName() values are in different format. OSUser() will return in DomainName\UserID format. Check once both NTNAME and OSName() are in same format.

Hope this helps you.

Regards,

Jagan.

Re: Creating variable, replacing Dollar $

vincent_ardiet — Wed, 21 Oct 2015 03:29:00 GMT

Hi,

It seems that some quotes are missing, try this:

LET vNavMenuTotAccess = '=if(only({<[User NT Name]={'& chr(39) & chr(36) &'(=OSUser())'& chr(39) &'}>} [User Role])='& chr(39) &'TOTAL_ACCESS'& chr(39) &',1,0)';

regards,

Vincent

Re: Creating variable, replacing Dollar $

jonathandienst — Wed, 21 Oct 2015 05:34:10 GMT

You are mixing up Set and Let a little here. Let will evaluate the expression, whereas Set takes it literally, so Set does not interpret chr(39) as a $ sign. I assume what you are trying to do is defer the $ expansion. I break between the $ and the open parenthesis will prevent the $ expansion, as will chr(39) in a Let statement.

This should work:

Let vNavMenuTotAccess = '=if(only({<[User NT Name]={"$' & '(=OSUser())"}>} [User Role]) = ''TOTAL_ACCESS'', 1, 0)';

Note the quotes around TOTAL ACCESS are each a pair of single quotes to escape the single quote inside the Let statement.

Re: Creating variable, replacing Dollar $

jonathandienst — Wed, 21 Oct 2015 05:36:57 GMT

Or you can do it this way:

Set vNavMenuTotAccess = =if(only({<[User NT Name]={"#(=OSUser())"}>} [User Role]) = 'TOTAL_ACCESS', 1, 0);

Let vNavMenuTotAccess = Replace(vNavMenuTotAccess, '#', '$');

Its a little easier to check the quotes and parentheses if you replace the $ with another character and then place the $ in the following Let.

Re: Creating variable, replacing Dollar $

zagzebski — Wed, 21 Oct 2015 14:05:12 GMT

Awesome - thanks so much!

Re: Creating variable, replacing Dollar $

zagzebski — Wed, 21 Oct 2015 14:07:24 GMT

Thanks!