Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
qlikconsultant
Creator III
Creator III

For me the expressions works another user gets an error message

Hi,

I have the following code in a text box.

= only({$<Username = {$(=SubField(OSUser(), '\', 2))} >} USEDEFAULTValue)

For me it works  i get the data.

If another user opens the app. 

They get the error message: "Error: Error in set ad hocelement list: ',' or ')' expected."

Any ideas?

1 Solution

Accepted Solutions
Vegar
MVP
MVP

My best guess is that you have a username without any whitespaces or special characters such as ' ' and '-', but the users with the problem does. 

Try adjusting your expression to either this (case sensitive): 
= only({$<Username = {'$(=SubField(OSUser(), '\', 2))'} >} USEDEFAULTValue) 

or this (case insensitive)
= only({$<Username = {"$(=SubField(OSUser(), '\', 2))"} >} USEDEFAULTValue) 

View solution in original post

1 Reply
Vegar
MVP
MVP

My best guess is that you have a username without any whitespaces or special characters such as ' ' and '-', but the users with the problem does. 

Try adjusting your expression to either this (case sensitive): 
= only({$<Username = {'$(=SubField(OSUser(), '\', 2))'} >} USEDEFAULTValue) 

or this (case insensitive)
= only({$<Username = {"$(=SubField(OSUser(), '\', 2))"} >} USEDEFAULTValue)