topic Why does separating terms by commas in a set analysis doesn't respect ranges? in App Development https://community.qlik.com/t5/App-Development/Why-does-separating-terms-by-commas-in-a-set-analysis-doesn-t/m-p/131331#M9252 <HTML><HEAD></HEAD><BODY><P>This set analysis:</P><PRE __default_attr="sql" __jive_macro_name="code" class="jive_macro_code _jivemacro_uid_15371248086734730 jive_text_macro" jivemacro_uid="_15371248086734730"> <P>=COUNT({&lt;FechaEval={"&gt;=20180802"},FechaEval={"&lt;=20180803"}&gt;}Medicion)"</P> </PRE><P>gives me 3 as a result but it should give me 2 according to my understanding. <STRONG>What I'm getting wrong?</STRONG></P><P></P><P>Thanks in advance</P><P></P><P>P.S. Table I loaded:</P><P></P><PRE __default_attr="sql" __jive_macro_name="code" class="jive_macro_code jive_text_macro _jivemacro_uid_15371247968227383" jivemacro_uid="_15371247968227383"> <P>T:</P> <P>LOAD * INLINE [FechaEval,Medicion</P> <P>20180801,1</P> <P>20180802,1</P> <P>20180803,1</P> <P>20180804,1</P> <P>20180805,1];</P> </PRE></BODY></HTML> Sun, 16 Sep 2018 19:08:27 GMT julioarriaga 2018-09-16T19:08:27Z Why does separating terms by commas in a set analysis doesn't respect ranges? https://community.qlik.com/t5/App-Development/Why-does-separating-terms-by-commas-in-a-set-analysis-doesn-t/m-p/131331#M9252 <HTML><HEAD></HEAD><BODY><P>This set analysis:</P><PRE __default_attr="sql" __jive_macro_name="code" class="jive_macro_code _jivemacro_uid_15371248086734730 jive_text_macro" jivemacro_uid="_15371248086734730"> <P>=COUNT({&lt;FechaEval={"&gt;=20180802"},FechaEval={"&lt;=20180803"}&gt;}Medicion)"</P> </PRE><P>gives me 3 as a result but it should give me 2 according to my understanding. <STRONG>What I'm getting wrong?</STRONG></P><P></P><P>Thanks in advance</P><P></P><P>P.S. Table I loaded:</P><P></P><PRE __default_attr="sql" __jive_macro_name="code" class="jive_macro_code jive_text_macro _jivemacro_uid_15371247968227383" jivemacro_uid="_15371247968227383"> <P>T:</P> <P>LOAD * INLINE [FechaEval,Medicion</P> <P>20180801,1</P> <P>20180802,1</P> <P>20180803,1</P> <P>20180804,1</P> <P>20180805,1];</P> </PRE></BODY></HTML> Sun, 16 Sep 2018 19:08:27 GMT https://community.qlik.com/t5/App-Development/Why-does-separating-terms-by-commas-in-a-set-analysis-doesn-t/m-p/131331#M9252 julioarriaga 2018-09-16T19:08:27Z Re: Why does separating terms by commas in a set analysis doesn't respect ranges? https://community.qlik.com/t5/App-Development/Why-does-separating-terms-by-commas-in-a-set-analysis-doesn-t/m-p/131332#M9253 <HTML><HEAD></HEAD><BODY><P>You can't repeat the same field - it will only make the last one go into effect. For your specific case you should write:</P><P></P><P>=Count( {&lt;FechaEval={"<STRONG>&gt;=</STRONG>20180802<STRONG>&lt;=</STRONG>20180303"}&gt;} Medicion )</P></BODY></HTML> Sun, 16 Sep 2018 20:09:09 GMT https://community.qlik.com/t5/App-Development/Why-does-separating-terms-by-commas-in-a-set-analysis-doesn-t/m-p/131332#M9253 petter 2018-09-16T20:09:09Z