topic Re: GetFieldSelection Isssue in QlikView https://community.qlik.com/t5/QlikView/GetFieldSelection-Isssue/m-p/1413673#M427270 <HTML><HEAD></HEAD><BODY><P>Which space after the comma you are talking about</P></BODY></HTML> Fri, 15 Dec 2017 15:49:43 GMT azmeerrehan 2017-12-15T15:49:43Z GetFieldSelection Isssue https://community.qlik.com/t5/QlikView/GetFieldSelection-Isssue/m-p/1413661#M427258 <HTML><HEAD></HEAD><BODY><P>I have the below statement</P><P></P><P>If(GetFieldSelections(MYField)='A' and GetFieldSelections(<SPAN style="font-size: 13.3333px;">MYField</SPAN>)='B', 1,0).</P><P>So If I am making a selection A and B in MYField this statement is returning 0 means False.&nbsp; It works fine with or but my requirement is and </P><P>What am I doing wrong here </P></BODY></HTML> Fri, 15 Dec 2017 15:18:12 GMT https://community.qlik.com/t5/QlikView/GetFieldSelection-Isssue/m-p/1413661#M427258 azmeerrehan 2017-12-15T15:18:12Z Re: GetFieldSelection Isssue https://community.qlik.com/t5/QlikView/GetFieldSelection-Isssue/m-p/1413662#M427259 <HTML><HEAD></HEAD><BODY><P>Maybe there is just some misunderstanding between the requirement und you ... For your descriped use-case OR will be correct. Otherwise you need to explain it a bit more.</P><P></P><P>- Marcus</P></BODY></HTML> Fri, 15 Dec 2017 15:23:03 GMT https://community.qlik.com/t5/QlikView/GetFieldSelection-Isssue/m-p/1413662#M427259 marcus_sommer 2017-12-15T15:23:03Z Re: GetFieldSelection Isssue https://community.qlik.com/t5/QlikView/GetFieldSelection-Isssue/m-p/1413663#M427260 <HTML><HEAD></HEAD><BODY><P>May be try like? I did not try let me know if it works?</P><P></P><P>IF(GetFieldSelections(Match(MyField, 'A', 'B')), 1, 0)</P></BODY></HTML> Fri, 15 Dec 2017 15:24:17 GMT https://community.qlik.com/t5/QlikView/GetFieldSelection-Isssue/m-p/1413663#M427260 vishsaggi 2017-12-15T15:24:17Z Re: GetFieldSelection Isssue https://community.qlik.com/t5/QlikView/GetFieldSelection-Isssue/m-p/1413664#M427261 <HTML><HEAD></HEAD><BODY><P>Hi Rehan</P><P></P><P>If you are select both A and B then GetFieldSelctions(MyField) will return A, B so your test should be</P><P>If(<SPAN style="font-size: 13.3333px;">GetFieldSelctions(MyField)='A, B',1,0)</SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;">Adrain</SPAN></P></BODY></HTML> Fri, 15 Dec 2017 15:27:28 GMT https://community.qlik.com/t5/QlikView/GetFieldSelection-Isssue/m-p/1413664#M427261 atoz1158 2017-12-15T15:27:28Z Re: GetFieldSelection Isssue https://community.qlik.com/t5/QlikView/GetFieldSelection-Isssue/m-p/1413665#M427262 <HTML><HEAD></HEAD><BODY><P>Try below expression</P><P></P><P><SPAN style="font-size: 8pt;">=</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">if</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">Concat</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #800000; font-size: 8pt;">MyField</SPAN><SPAN style="font-size: 8pt;">,'|')='A|B',1,0) </SPAN></P></BODY></HTML> Fri, 15 Dec 2017 15:32:27 GMT https://community.qlik.com/t5/QlikView/GetFieldSelection-Isssue/m-p/1413665#M427262 krishnacbe 2017-12-15T15:32:27Z Re: GetFieldSelection Isssue https://community.qlik.com/t5/QlikView/GetFieldSelection-Isssue/m-p/1413666#M427263 <HTML><HEAD></HEAD><BODY><P>Doesnt work</P></BODY></HTML> Fri, 15 Dec 2017 15:32:31 GMT https://community.qlik.com/t5/QlikView/GetFieldSelection-Isssue/m-p/1413666#M427263 azmeerrehan 2017-12-15T15:32:31Z Re: GetFieldSelection Isssue https://community.qlik.com/t5/QlikView/GetFieldSelection-Isssue/m-p/1413667#M427264 <HTML><HEAD></HEAD><BODY><P>Doesnt work</P></BODY></HTML> Fri, 15 Dec 2017 15:32:42 GMT https://community.qlik.com/t5/QlikView/GetFieldSelection-Isssue/m-p/1413667#M427264 azmeerrehan 2017-12-15T15:32:42Z Re: GetFieldSelection Isssue https://community.qlik.com/t5/QlikView/GetFieldSelection-Isssue/m-p/1413668#M427265 <HTML><HEAD></HEAD><BODY><P>I can see that ur sample app it works, but its working on mine .</P><P></P><P></P><P>If(Concat([My Field],'|')='Golden Harvest West|Golden Harvest East',1,0)</P></BODY></HTML> Fri, 15 Dec 2017 15:44:29 GMT https://community.qlik.com/t5/QlikView/GetFieldSelection-Isssue/m-p/1413668#M427265 azmeerrehan 2017-12-15T15:44:29Z Re: GetFieldSelection Isssue https://community.qlik.com/t5/QlikView/GetFieldSelection-Isssue/m-p/1413669#M427266 <HTML><HEAD></HEAD><BODY><P>Sorry its not working on mine </P></BODY></HTML> Fri, 15 Dec 2017 15:44:56 GMT https://community.qlik.com/t5/QlikView/GetFieldSelection-Isssue/m-p/1413669#M427266 azmeerrehan 2017-12-15T15:44:56Z Re: GetFieldSelection Isssue https://community.qlik.com/t5/QlikView/GetFieldSelection-Isssue/m-p/1413670#M427267 <HTML><HEAD></HEAD><BODY><P>Hi Rehan</P><P></P><P>It works for me, please note that the values of A &amp; B must be in Alphabetical order and there must be a space after the comma.</P><P></P><P>Try just putting the following in a text box and seeing what comes back</P><P>=<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13.3333px;">GetFieldSelctions(MyField)</SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13.3333px;">Adrian</SPAN></P></BODY></HTML> Fri, 15 Dec 2017 15:45:19 GMT https://community.qlik.com/t5/QlikView/GetFieldSelection-Isssue/m-p/1413670#M427267 atoz1158 2017-12-15T15:45:19Z Re: GetFieldSelection Isssue https://community.qlik.com/t5/QlikView/GetFieldSelection-Isssue/m-p/1413671#M427268 <HTML><HEAD></HEAD><BODY><P>I can see the two values seperated by the comma</P></BODY></HTML> Fri, 15 Dec 2017 15:49:15 GMT https://community.qlik.com/t5/QlikView/GetFieldSelection-Isssue/m-p/1413671#M427268 azmeerrehan 2017-12-15T15:49:15Z Re: GetFieldSelection Isssue https://community.qlik.com/t5/QlikView/GetFieldSelection-Isssue/m-p/1413672#M427269 <HTML><HEAD></HEAD><BODY><P>Can you share a sample you are working on to check at our end please...?</P></BODY></HTML> Fri, 15 Dec 2017 15:49:31 GMT https://community.qlik.com/t5/QlikView/GetFieldSelection-Isssue/m-p/1413672#M427269 vishsaggi 2017-12-15T15:49:31Z Re: GetFieldSelection Isssue https://community.qlik.com/t5/QlikView/GetFieldSelection-Isssue/m-p/1413673#M427270 <HTML><HEAD></HEAD><BODY><P>Which space after the comma you are talking about</P></BODY></HTML> Fri, 15 Dec 2017 15:49:43 GMT https://community.qlik.com/t5/QlikView/GetFieldSelection-Isssue/m-p/1413673#M427270 azmeerrehan 2017-12-15T15:49:43Z Re: GetFieldSelection Isssue https://community.qlik.com/t5/QlikView/GetFieldSelection-Isssue/m-p/1413674#M427271 <HTML><HEAD></HEAD><BODY><ADDRESS>just try this&nbsp; <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">If(is null(GetFieldSelections(MYField)='A' ,B',1,0))</SPAN></ADDRESS></BODY></HTML> Fri, 15 Dec 2017 15:49:57 GMT https://community.qlik.com/t5/QlikView/GetFieldSelection-Isssue/m-p/1413674#M427271 Anonymous 2017-12-15T15:49:57Z Re: GetFieldSelection Isssue https://community.qlik.com/t5/QlikView/GetFieldSelection-Isssue/m-p/1413675#M427272 <HTML><HEAD></HEAD><BODY><P>The space after the comma and before the B</P></BODY></HTML> Fri, 15 Dec 2017 15:52:58 GMT https://community.qlik.com/t5/QlikView/GetFieldSelection-Isssue/m-p/1413675#M427272 atoz1158 2017-12-15T15:52:58Z Re: GetFieldSelection Isssue https://community.qlik.com/t5/QlikView/GetFieldSelection-Isssue/m-p/1413676#M427273 <HTML><HEAD></HEAD><BODY><P>Can you please resend me the expression showing the space with some symbol</P></BODY></HTML> Fri, 15 Dec 2017 15:55:30 GMT https://community.qlik.com/t5/QlikView/GetFieldSelection-Isssue/m-p/1413676#M427273 azmeerrehan 2017-12-15T15:55:30Z Re: GetFieldSelection Isssue https://community.qlik.com/t5/QlikView/GetFieldSelection-Isssue/m-p/1413677#M427274 <HTML><HEAD></HEAD><BODY><P>Please check the attached, it is working.</P></BODY></HTML> Fri, 15 Dec 2017 15:59:00 GMT https://community.qlik.com/t5/QlikView/GetFieldSelection-Isssue/m-p/1413677#M427274 krishnacbe 2017-12-15T15:59:00Z Re: GetFieldSelection Isssue https://community.qlik.com/t5/QlikView/GetFieldSelection-Isssue/m-p/1413678#M427275 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">If(</SPAN><SPAN style="font-size: 13.3333px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">GetFieldSelctions(MyField)='A,%B',1,0)</SPAN></P><P><SPAN style="font-size: 13.3333px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Where the % is the space<BR /></SPAN></P></BODY></HTML> Fri, 15 Dec 2017 16:03:14 GMT https://community.qlik.com/t5/QlikView/GetFieldSelection-Isssue/m-p/1413678#M427275 atoz1158 2017-12-15T16:03:14Z Re: GetFieldSelection Isssue https://community.qlik.com/t5/QlikView/GetFieldSelection-Isssue/m-p/1413679#M427276 <HTML><HEAD></HEAD><BODY><P>I can see its working on ur sample, but it doesnt work on my APP for some reason</P></BODY></HTML> Fri, 15 Dec 2017 16:07:21 GMT https://community.qlik.com/t5/QlikView/GetFieldSelection-Isssue/m-p/1413679#M427276 azmeerrehan 2017-12-15T16:07:21Z