Error in set modifier ad hoc element list

[navaneeth79]

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')

[tresesco]

What output do you get when expand the variable as  $(vL.UserType) in textbox?

[navaneeth79]

on toggle selection it should reflect either 'Business User' or '*'

[tresesco]

Have you checked in a textbox, if that is working that way?

[stabben23]

What happen if you use a "search" in set analysis on that Field?

UserType = {"$(vL.UserType)"}

[navaneeth79]

when I use " ", its showing only one value the other not getting reflected

[navaneeth79]

yes I used text box

[stabben23]

Ok, maybe you should use UserType = {"*"} if you want both?

[navaneeth79]

I have a toggle button, when I click on exclude I should get count of only business users and when I click include I should get over all value.

[tresesco]

Do you have a sample to share so that we can look into it?