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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
navaneeth79
Contributor II
Contributor II

Error in set modifier ad hoc element list

I am getting error "Error in set modifier ad hoc element list" while using the below expression

num(count({1<Last7DaysFlag={'1'},UserType = {$(vL.UserType)},Session_Start_Count={">0"}>}DISTINCT Authenticated_User),'#,##0')

13 Replies
navaneeth79
Contributor II
Contributor II
Author

I cant share the screen shot.

the error I am getting is the in the expression where vL.UserType getting a value without quotes(' ') after each reload so we are getting error because of that.

navaneeth79
Contributor II
Contributor II
Author

we should get $(vL.UserType) = 'Business User' but we are getting $(vL.UserType) = Business User after reloading the script

stabben23
Partner - Master
Partner - Master

Why not remove the single quote in variable $(vL.UserType) With replace() or keepchar()?

navaneeth79
Contributor II
Contributor II
Author

not working