topic Re: Error in set modifier ad hoc element list in QlikView https://community.qlik.com/t5/QlikView/Error-in-set-modifier-ad-hoc-element-list/m-p/9617#M1470 <HTML><HEAD></HEAD><BODY><P>on toggle selection it should reflect either 'Business User' or '*'</P></BODY></HTML> Mon, 26 Mar 2018 10:01:16 GMT navaneeth79 2018-03-26T10:01:16Z Error in set modifier ad hoc element list https://community.qlik.com/t5/QlikView/Error-in-set-modifier-ad-hoc-element-list/m-p/9615#M1468 <HTML><HEAD></HEAD><BODY><P>I am getting error "Error in set modifier ad hoc element list" while using the below expression</P><P></P><P>num(count({1&lt;Last7DaysFlag={'1'},UserType = {$(vL.UserType)},Session_Start_Count={"&gt;0"}&gt;}DISTINCT Authenticated_User),'#,##0')</P><P><SPAN class="mce_paste_marker"></SPAN></P></BODY></HTML> Mon, 26 Mar 2018 09:46:05 GMT https://community.qlik.com/t5/QlikView/Error-in-set-modifier-ad-hoc-element-list/m-p/9615#M1468 navaneeth79 2018-03-26T09:46:05Z Re: Error in set modifier ad hoc element list https://community.qlik.com/t5/QlikView/Error-in-set-modifier-ad-hoc-element-list/m-p/9616#M1469 <HTML><HEAD></HEAD><BODY><P>What output do you get when expand the variable as&nbsp; <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">$(vL.UserType) in textbox?</SPAN></P></BODY></HTML> Mon, 26 Mar 2018 09:52:38 GMT https://community.qlik.com/t5/QlikView/Error-in-set-modifier-ad-hoc-element-list/m-p/9616#M1469 tresB 2018-03-26T09:52:38Z Re: Error in set modifier ad hoc element list https://community.qlik.com/t5/QlikView/Error-in-set-modifier-ad-hoc-element-list/m-p/9617#M1470 <HTML><HEAD></HEAD><BODY><P>on toggle selection it should reflect either 'Business User' or '*'</P></BODY></HTML> Mon, 26 Mar 2018 10:01:16 GMT https://community.qlik.com/t5/QlikView/Error-in-set-modifier-ad-hoc-element-list/m-p/9617#M1470 navaneeth79 2018-03-26T10:01:16Z Re: Error in set modifier ad hoc element list https://community.qlik.com/t5/QlikView/Error-in-set-modifier-ad-hoc-element-list/m-p/9618#M1471 <HTML><HEAD></HEAD><BODY><P>Have you checked in a <STRONG>textbox</STRONG>, if that is working that way?</P></BODY></HTML> Mon, 26 Mar 2018 10:03:42 GMT https://community.qlik.com/t5/QlikView/Error-in-set-modifier-ad-hoc-element-list/m-p/9618#M1471 tresB 2018-03-26T10:03:42Z Re: Error in set modifier ad hoc element list https://community.qlik.com/t5/QlikView/Error-in-set-modifier-ad-hoc-element-list/m-p/9619#M1472 <HTML><HEAD></HEAD><BODY><P>What happen if you use a "search" in set analysis on that Field?</P><P> UserType = {"$(vL.UserType)"}</P></BODY></HTML> Mon, 26 Mar 2018 10:06:40 GMT https://community.qlik.com/t5/QlikView/Error-in-set-modifier-ad-hoc-element-list/m-p/9619#M1472 stabben23 2018-03-26T10:06:40Z Re: Error in set modifier ad hoc element list https://community.qlik.com/t5/QlikView/Error-in-set-modifier-ad-hoc-element-list/m-p/9620#M1473 <HTML><HEAD></HEAD><BODY><P>when I use " ", its showing only one value the other not getting reflected</P></BODY></HTML> Mon, 26 Mar 2018 10:13:36 GMT https://community.qlik.com/t5/QlikView/Error-in-set-modifier-ad-hoc-element-list/m-p/9620#M1473 navaneeth79 2018-03-26T10:13:36Z Re: Error in set modifier ad hoc element list https://community.qlik.com/t5/QlikView/Error-in-set-modifier-ad-hoc-element-list/m-p/9621#M1474 <HTML><HEAD></HEAD><BODY><P>yes I used text box</P></BODY></HTML> Mon, 26 Mar 2018 10:13:45 GMT https://community.qlik.com/t5/QlikView/Error-in-set-modifier-ad-hoc-element-list/m-p/9621#M1474 navaneeth79 2018-03-26T10:13:45Z Re: Error in set modifier ad hoc element list https://community.qlik.com/t5/QlikView/Error-in-set-modifier-ad-hoc-element-list/m-p/9622#M1475 <HTML><HEAD></HEAD><BODY><P>Ok, maybe you should use UserType = {"*"} if you want both?</P></BODY></HTML> Mon, 26 Mar 2018 10:18:56 GMT https://community.qlik.com/t5/QlikView/Error-in-set-modifier-ad-hoc-element-list/m-p/9622#M1475 stabben23 2018-03-26T10:18:56Z Re: Error in set modifier ad hoc element list https://community.qlik.com/t5/QlikView/Error-in-set-modifier-ad-hoc-element-list/m-p/9623#M1476 <HTML><HEAD></HEAD><BODY><P>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.</P></BODY></HTML> Mon, 26 Mar 2018 10:20:49 GMT https://community.qlik.com/t5/QlikView/Error-in-set-modifier-ad-hoc-element-list/m-p/9623#M1476 navaneeth79 2018-03-26T10:20:49Z Re: Error in set modifier ad hoc element list https://community.qlik.com/t5/QlikView/Error-in-set-modifier-ad-hoc-element-list/m-p/9624#M1477 <HTML><HEAD></HEAD><BODY><P>Do you have a sample to share so that we can look into it?</P></BODY></HTML> Mon, 26 Mar 2018 10:26:56 GMT https://community.qlik.com/t5/QlikView/Error-in-set-modifier-ad-hoc-element-list/m-p/9624#M1477 tresB 2018-03-26T10:26:56Z Re: Error in set modifier ad hoc element list https://community.qlik.com/t5/QlikView/Error-in-set-modifier-ad-hoc-element-list/m-p/9625#M1478 <HTML><HEAD></HEAD><BODY><P>I cant share the screen shot.</P><P>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.</P></BODY></HTML> Tue, 27 Mar 2018 11:37:02 GMT https://community.qlik.com/t5/QlikView/Error-in-set-modifier-ad-hoc-element-list/m-p/9625#M1478 navaneeth79 2018-03-27T11:37:02Z Re: Error in set modifier ad hoc element list https://community.qlik.com/t5/QlikView/Error-in-set-modifier-ad-hoc-element-list/m-p/9626#M1479 <HTML><HEAD></HEAD><BODY><P>we should get $(vL.UserType) = 'Business User' but we are getting $(vL.UserType) = Business User after reloading the script</P></BODY></HTML> Tue, 27 Mar 2018 11:38:09 GMT https://community.qlik.com/t5/QlikView/Error-in-set-modifier-ad-hoc-element-list/m-p/9626#M1479 navaneeth79 2018-03-27T11:38:09Z Re: Error in set modifier ad hoc element list https://community.qlik.com/t5/QlikView/Error-in-set-modifier-ad-hoc-element-list/m-p/9627#M1480 <HTML><HEAD></HEAD><BODY><P>Why not remove the single quote in variable $(vL.UserType) With replace() or keepchar()?</P></BODY></HTML> Tue, 27 Mar 2018 11:59:40 GMT https://community.qlik.com/t5/QlikView/Error-in-set-modifier-ad-hoc-element-list/m-p/9627#M1480 stabben23 2018-03-27T11:59:40Z Re: Error in set modifier ad hoc element list https://community.qlik.com/t5/QlikView/Error-in-set-modifier-ad-hoc-element-list/m-p/9628#M1481 <HTML><HEAD></HEAD><BODY><P>not working</P></BODY></HTML> Tue, 27 Mar 2018 12:12:20 GMT https://community.qlik.com/t5/QlikView/Error-in-set-modifier-ad-hoc-element-list/m-p/9628#M1481 navaneeth79 2018-03-27T12:12:20Z