topic How to write OR condition in set analysis in QlikView https://community.qlik.com/t5/QlikView/How-to-write-OR-condition-in-set-analysis/m-p/350264#M129791 <HTML><HEAD></HEAD><BODY><P>=count({$&lt;Qty_no={23},Value={9,10},YEAR={2012}&gt;} Sales)</P></BODY></HTML> Mon, 14 May 2012 14:48:38 GMT danielrozental 2012-05-14T14:48:38Z How to write OR condition in set analysis https://community.qlik.com/t5/QlikView/How-to-write-OR-condition-in-set-analysis/m-p/350261#M129788 <HTML><HEAD></HEAD><BODY><P>HI all,</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; How to write&nbsp; OR condition in set analysis.???</P></BODY></HTML> Mon, 14 May 2012 14:25:28 GMT https://community.qlik.com/t5/QlikView/How-to-write-OR-condition-in-set-analysis/m-p/350261#M129788 2012-05-14T14:25:28Z How to write OR condition in set analysis https://community.qlik.com/t5/QlikView/How-to-write-OR-condition-in-set-analysis/m-p/350262#M129789 <HTML><HEAD></HEAD><BODY><P>You can't do an OR with different field conditions, what you could do is use more than one expression.</P><P></P><P>Why don't you post your expression so we can help you?</P></BODY></HTML> Mon, 14 May 2012 14:32:00 GMT https://community.qlik.com/t5/QlikView/How-to-write-OR-condition-in-set-analysis/m-p/350262#M129789 danielrozental 2012-05-14T14:32:00Z How to write OR condition in set analysis https://community.qlik.com/t5/QlikView/How-to-write-OR-condition-in-set-analysis/m-p/350263#M129790 <HTML><HEAD></HEAD><BODY><P>Thank you for reply.I want to write the equation as follows</P><P></P><P>=count({$&lt;Qty_no={'23'},Value={"9"} or {"10"},YEAR={'2012"}&gt;} Sales)</P></BODY></HTML> Mon, 14 May 2012 14:41:20 GMT https://community.qlik.com/t5/QlikView/How-to-write-OR-condition-in-set-analysis/m-p/350263#M129790 2012-05-14T14:41:20Z How to write OR condition in set analysis https://community.qlik.com/t5/QlikView/How-to-write-OR-condition-in-set-analysis/m-p/350264#M129791 <HTML><HEAD></HEAD><BODY><P>=count({$&lt;Qty_no={23},Value={9,10},YEAR={2012}&gt;} Sales)</P></BODY></HTML> Mon, 14 May 2012 14:48:38 GMT https://community.qlik.com/t5/QlikView/How-to-write-OR-condition-in-set-analysis/m-p/350264#M129791 danielrozental 2012-05-14T14:48:38Z How to write OR condition in set analysis https://community.qlik.com/t5/QlikView/How-to-write-OR-condition-in-set-analysis/m-p/350265#M129792 <HTML><HEAD></HEAD><BODY><P> Thank you very much .one more question regarding the set analysis.How to include and exclude a set of values of different fields in set analysis.</P><P></P><P>=count({$&lt;Qty_no={23},value{9,10},Year={2012}&gt;} Sales)/count(Value{3,4,5},year={2012}</P><P></P><P>I included the values 3,4 and 5 in denominator and also want to exclude another set of values of&nbsp; another field meanvalue ={1.2,2,3} from the denominator how can I exclude?</P></BODY></HTML> Mon, 14 May 2012 15:37:16 GMT https://community.qlik.com/t5/QlikView/How-to-write-OR-condition-in-set-analysis/m-p/350265#M129792 2012-05-14T15:37:16Z How to write OR condition in set analysis https://community.qlik.com/t5/QlikView/How-to-write-OR-condition-in-set-analysis/m-p/350266#M129793 <HTML><HEAD></HEAD><BODY><P>=count({$&lt;Qty_no={23},value{9,10},Year={2012}&gt;} Sales)/count({&lt;Value={3,4,5},year={2012},meanvalue-={1.2,2,3}</P></BODY></HTML> Mon, 14 May 2012 15:46:37 GMT https://community.qlik.com/t5/QlikView/How-to-write-OR-condition-in-set-analysis/m-p/350266#M129793 danielrozental 2012-05-14T15:46:37Z How to write OR condition in set analysis https://community.qlik.com/t5/QlikView/How-to-write-OR-condition-in-set-analysis/m-p/350267#M129794 <HTML><HEAD></HEAD><BODY><P> Thank you Daniel</P></BODY></HTML> Mon, 14 May 2012 21:23:30 GMT https://community.qlik.com/t5/QlikView/How-to-write-OR-condition-in-set-analysis/m-p/350267#M129794 2012-05-14T21:23:30Z