Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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)