topic Possible value - if statement in QlikView https://community.qlik.com/t5/QlikView/Possible-value-if-statement/m-p/1261029#M397729 <HTML><HEAD></HEAD><BODY><P>I need to write an if statement to get a possible value. When a salesman is selected I need to return a 1 if specific region is possible and 0 if not possible.</P><P></P><P>For example...if salesman John Smith is selected return a one (1)&nbsp; if it is possible that he had sales in the "East" region and a zero (0) if it is not possible that John Smith had sales in the "East" region.</P><P></P><P>Thanks,</P><P></P><P>Zag</P></BODY></HTML> Wed, 22 Mar 2017 13:37:11 GMT zagzebski 2017-03-22T13:37:11Z Possible value - if statement https://community.qlik.com/t5/QlikView/Possible-value-if-statement/m-p/1261029#M397729 <HTML><HEAD></HEAD><BODY><P>I need to write an if statement to get a possible value. When a salesman is selected I need to return a 1 if specific region is possible and 0 if not possible.</P><P></P><P>For example...if salesman John Smith is selected return a one (1)&nbsp; if it is possible that he had sales in the "East" region and a zero (0) if it is not possible that John Smith had sales in the "East" region.</P><P></P><P>Thanks,</P><P></P><P>Zag</P></BODY></HTML> Wed, 22 Mar 2017 13:37:11 GMT https://community.qlik.com/t5/QlikView/Possible-value-if-statement/m-p/1261029#M397729 zagzebski 2017-03-22T13:37:11Z Re: Possible value - if statement https://community.qlik.com/t5/QlikView/Possible-value-if-statement/m-p/1261030#M397730 <HTML><HEAD></HEAD><BODY><P>if(sum({&lt;Region={'East'}&gt;}Sales)&gt;0,1,0) </P></BODY></HTML> Wed, 22 Mar 2017 13:40:49 GMT https://community.qlik.com/t5/QlikView/Possible-value-if-statement/m-p/1261030#M397730 vinieme12 2017-03-22T13:40:49Z