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

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
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