topic how to include a not condition in set analysis in QlikView https://community.qlik.com/t5/QlikView/how-to-include-a-not-condition-in-set-analysis/m-p/373568#M576092 <HTML><HEAD></HEAD><BODY><P>i need to count a dimension, and i need to exclude null values, How do i implement using set analysis or is there any other way to implement it.</P></BODY></HTML> Mon, 30 Apr 2012 07:12:07 GMT 2012-04-30T07:12:07Z how to include a not condition in set analysis https://community.qlik.com/t5/QlikView/how-to-include-a-not-condition-in-set-analysis/m-p/373568#M576092 <HTML><HEAD></HEAD><BODY><P>i need to count a dimension, and i need to exclude null values, How do i implement using set analysis or is there any other way to implement it.</P></BODY></HTML> Mon, 30 Apr 2012 07:12:07 GMT https://community.qlik.com/t5/QlikView/how-to-include-a-not-condition-in-set-analysis/m-p/373568#M576092 2012-04-30T07:12:07Z how to include a not condition in set analysis https://community.qlik.com/t5/QlikView/how-to-include-a-not-condition-in-set-analysis/m-p/373569#M576093 <HTML><HEAD></HEAD><BODY><P>sum({&lt;fielname<STRONG>-=</STRONG>{'value'}&gt;} sales)</P><P></P><P>- = is used in set analysis for not condition </P><P></P><P></P><P></P><P>hope this helps </P></BODY></HTML> Mon, 30 Apr 2012 07:16:36 GMT https://community.qlik.com/t5/QlikView/how-to-include-a-not-condition-in-set-analysis/m-p/373569#M576093 SunilChauhan 2012-04-30T07:16:36Z how to include a not condition in set analysis https://community.qlik.com/t5/QlikView/how-to-include-a-not-condition-in-set-analysis/m-p/373570#M576094 <HTML><HEAD></HEAD><BODY><P>i did a numeric count of the dimension ,&nbsp; I am able to get correct answers.</P></BODY></HTML> Mon, 30 Apr 2012 09:36:00 GMT https://community.qlik.com/t5/QlikView/how-to-include-a-not-condition-in-set-analysis/m-p/373570#M576094 2012-04-30T09:36:00Z