topic Found an error - please help :( in QlikView https://community.qlik.com/t5/QlikView/Found-an-error-please-help/m-p/135281#M754441 <HTML><HEAD></HEAD><BODY><P style="font-size: 13.3333px;">Hi, </P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;">I would like to exclude where all the columns below are No</P><P style="font-size: 13.3333px;"><IMG alt="Capture 1 .PNG" class="jive-image image-1" src="/legacyfs/online/215110_Capture 1 .PNG" /></P><P style="font-size: 13.3333px;">Therefore, I created a new filter using below formula</P><P style="font-size: 13.3333px;">=if([V7] = 'No' and [V1-5] ='No' and [V6]='No' and [V8-9 Accepted Date]='No' and [V8-9 Next Due Date for Review] = 'No', 'Exclude','Include')</P><P style="font-size: 13.3333px;"><IMG alt="Capture 2.PNG" class="jive-image image-2" src="/legacyfs/online/215111_Capture 2.PNG" /></P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;">However, when I filter 'Include', both are selected for some reason. </P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;"><IMG alt="Capture 4.PNG" class="jive-image image-3" src="/legacyfs/online/215112_Capture 4.PNG" /></P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;">Help! <IMG src="https://community.qlik.com/legacyfs/online/emoticons/sad.png" /></P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT hykal1993 2020-11-25T16:16:04Z Found an error - please help :( https://community.qlik.com/t5/QlikView/Found-an-error-please-help/m-p/135281#M754441 <HTML><HEAD></HEAD><BODY><P style="font-size: 13.3333px;">Hi, </P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;">I would like to exclude where all the columns below are No</P><P style="font-size: 13.3333px;"><IMG alt="Capture 1 .PNG" class="jive-image image-1" src="/legacyfs/online/215110_Capture 1 .PNG" /></P><P style="font-size: 13.3333px;">Therefore, I created a new filter using below formula</P><P style="font-size: 13.3333px;">=if([V7] = 'No' and [V1-5] ='No' and [V6]='No' and [V8-9 Accepted Date]='No' and [V8-9 Next Due Date for Review] = 'No', 'Exclude','Include')</P><P style="font-size: 13.3333px;"><IMG alt="Capture 2.PNG" class="jive-image image-2" src="/legacyfs/online/215111_Capture 2.PNG" /></P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;">However, when I filter 'Include', both are selected for some reason. </P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;"><IMG alt="Capture 4.PNG" class="jive-image image-3" src="/legacyfs/online/215112_Capture 4.PNG" /></P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;">Help! <IMG src="https://community.qlik.com/legacyfs/online/emoticons/sad.png" /></P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Found-an-error-please-help/m-p/135281#M754441 hykal1993 2020-11-25T16:16:04Z Re: Found an error - please help :( https://community.qlik.com/t5/QlikView/Found-an-error-please-help/m-p/135282#M754442 <HTML><HEAD></HEAD><BODY><P>Try this in the script.</P><P></P><P>Load</P><P>*,</P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13.3333px;">=if([V7] = 'No' and [V1-5] ='No' and [V6]='No' and [V8-9 Accepted Date]='No' and [V8-9 Next Due Date for Review] = 'No', 'Exclude','Include') as Filter</SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13.3333px;">from &lt;&gt;</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;">Br,</SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13.3333px;">KC<BR /></SPAN></P></BODY></HTML> Thu, 04 Oct 2018 12:04:23 GMT https://community.qlik.com/t5/QlikView/Found-an-error-please-help/m-p/135282#M754442 jyothish8807 2018-10-04T12:04:23Z