topic Re: Not equal to in Set analysis in QlikView https://community.qlik.com/t5/QlikView/Not-equal-to-in-Set-analysis/m-p/914194#M468888 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13.3333330154419px;">you can use -= to exclude a value <BR /></SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13.3333330154419px;">Count(<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13.3333330154419px;">{&lt;flag -={1}&gt;} </SPAN>DISTINCT Places)</SPAN></P></BODY></HTML> Thu, 06 Aug 2015 15:53:10 GMT ramoncova06 2015-08-06T15:53:10Z Not equal to in Set analysis https://community.qlik.com/t5/QlikView/Not-equal-to-in-Set-analysis/m-p/914193#M468887 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>I'm writing a set analysis expression, </P><P>Count(DISTINCT( Places))</P><P>Here i wanna omit the places which has flag "1" .</P><P>"Cross" and "Hill" has the flag "1" during the script execution with a condition.</P><P></P><P>Finally, i'm trying to get <SPAN style="font-size: 13.3333330154419px;">Count(DISTINCT( Places)) where flag for Cross and Flag is not equal to "1" (or equal to "0")</SPAN></P></BODY></HTML> Thu, 06 Aug 2015 15:45:14 GMT https://community.qlik.com/t5/QlikView/Not-equal-to-in-Set-analysis/m-p/914193#M468887 markgraham123 2015-08-06T15:45:14Z Re: Not equal to in Set analysis https://community.qlik.com/t5/QlikView/Not-equal-to-in-Set-analysis/m-p/914194#M468888 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13.3333330154419px;">you can use -= to exclude a value <BR /></SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13.3333330154419px;">Count(<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13.3333330154419px;">{&lt;flag -={1}&gt;} </SPAN>DISTINCT Places)</SPAN></P></BODY></HTML> Thu, 06 Aug 2015 15:53:10 GMT https://community.qlik.com/t5/QlikView/Not-equal-to-in-Set-analysis/m-p/914194#M468888 ramoncova06 2015-08-06T15:53:10Z Re: Not equal to in Set analysis https://community.qlik.com/t5/QlikView/Not-equal-to-in-Set-analysis/m-p/914195#M468889 <HTML><HEAD></HEAD><BODY><P>Thanq Ramon.</P></BODY></HTML> Thu, 06 Aug 2015 16:34:50 GMT https://community.qlik.com/t5/QlikView/Not-equal-to-in-Set-analysis/m-p/914195#M468889 markgraham123 2015-08-06T16:34:50Z