topic set analysis in QlikView https://community.qlik.com/t5/QlikView/set-analysis/m-p/211328#M65640 <HTML><HEAD></HEAD><BODY><P>hi</P><P></P><P>I'm sorry for the language. i m french</P><P>this is good: Count (DISTINCT {$&lt;GERS={"=sum({1&lt;MOIS={6}&gt;}[Total Net])&gt;0"} &gt;} GERS)</P><P></P><P>but when i want to select a range the result is not good:</P><P>Count (DISTINCT {$&lt;GERS={"=sum({1&lt;MOIS={"&lt;9&gt;5"}&gt;}[Total Net])&gt;0"} &gt;} GERS).</P><P>the formula with out "" is good but the results are 0</P><P>Count (DISTINCT {$&lt;GERS={"=sum({1&lt;MOIS={&lt;9&gt;5}&gt;}[Total Net])&gt;0"} &gt;} GERS).</P><P>Have you got a solution?<BR /><BR />best regards</P><P></P><P></P><P></P></BODY></HTML> Thu, 08 Oct 2009 23:03:31 GMT 2009-10-08T23:03:31Z set analysis https://community.qlik.com/t5/QlikView/set-analysis/m-p/211328#M65640 <HTML><HEAD></HEAD><BODY><P>hi</P><P></P><P>I'm sorry for the language. i m french</P><P>this is good: Count (DISTINCT {$&lt;GERS={"=sum({1&lt;MOIS={6}&gt;}[Total Net])&gt;0"} &gt;} GERS)</P><P></P><P>but when i want to select a range the result is not good:</P><P>Count (DISTINCT {$&lt;GERS={"=sum({1&lt;MOIS={"&lt;9&gt;5"}&gt;}[Total Net])&gt;0"} &gt;} GERS).</P><P>the formula with out "" is good but the results are 0</P><P>Count (DISTINCT {$&lt;GERS={"=sum({1&lt;MOIS={&lt;9&gt;5}&gt;}[Total Net])&gt;0"} &gt;} GERS).</P><P>Have you got a solution?<BR /><BR />best regards</P><P></P><P></P><P></P></BODY></HTML> Thu, 08 Oct 2009 23:03:31 GMT https://community.qlik.com/t5/QlikView/set-analysis/m-p/211328#M65640 2009-10-08T23:03:31Z