topic Re: set analysis issue in QlikView https://community.qlik.com/t5/QlikView/set-analysis-issue/m-p/1204880#M387389 <HTML><HEAD></HEAD><BODY><P>Try this:</P><P></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13.3333px;"><STRONG>=Count(DISTINCT {&lt;YTDFlag={'1'}, <SPAN style="color: #ff0000;">Country={"=Sum({&lt;YTDFlag={'1'},...other&nbsp; set analysis...&gt;}Sales</SPAN></STRONG></SPAN><SPAN style="font-size: 13.3333px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG><SPAN style="color: #ff0000;">))&gt;0"}</SPAN>&gt;} Country)</STRONG></SPAN></P></BODY></HTML> Wed, 19 Oct 2016 11:03:45 GMT sunny_talwar 2016-10-19T11:03:45Z set analysis issue https://community.qlik.com/t5/QlikView/set-analysis-issue/m-p/1204879#M387388 <HTML><HEAD></HEAD><BODY><P>Greetings.</P><P>I want to put in a variable how many countries I have which has sales in the period I've created with a flag.</P><P></P><P>I have the following but something's wrong.</P><P></P><TABLE jive-data-cell="{&quot;color&quot;:&quot;#575757&quot;,&quot;textAlign&quot;:&quot;left&quot;,&quot;padding&quot;:&quot;NaN&quot;,&quot;backgroundColor&quot;:&quot;transparent&quot;,&quot;fontFamily&quot;:&quot;arial,helvetica,sans-serif&quot;,&quot;verticalAlign&quot;:&quot;baseline&quot;}" jive-data-header="{&quot;color&quot;:&quot;#FFFFFF&quot;,&quot;backgroundColor&quot;:&quot;#6690BC&quot;,&quot;textAlign&quot;:&quot;center&quot;,&quot;padding&quot;:&quot;2&quot;}" style="font-size: 13.3333px;"><TBODY><TR><TD>=count(DISTINCT {&lt;YTDFlag={'1'},Country={"$(=sum({&lt;YTDFlag={'1'},...other&nbsp; set analysis...&gt;}Sales<SPAN style="font-size: 13.3333px;">))&gt;0"&gt;} Country)</SPAN></TD></TR></TBODY></TABLE><P></P><P>Thanks in advance</P></BODY></HTML> Wed, 19 Oct 2016 11:01:55 GMT https://community.qlik.com/t5/QlikView/set-analysis-issue/m-p/1204879#M387388 slribeiro 2016-10-19T11:01:55Z Re: set analysis issue https://community.qlik.com/t5/QlikView/set-analysis-issue/m-p/1204880#M387389 <HTML><HEAD></HEAD><BODY><P>Try this:</P><P></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13.3333px;"><STRONG>=Count(DISTINCT {&lt;YTDFlag={'1'}, <SPAN style="color: #ff0000;">Country={"=Sum({&lt;YTDFlag={'1'},...other&nbsp; set analysis...&gt;}Sales</SPAN></STRONG></SPAN><SPAN style="font-size: 13.3333px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG><SPAN style="color: #ff0000;">))&gt;0"}</SPAN>&gt;} Country)</STRONG></SPAN></P></BODY></HTML> Wed, 19 Oct 2016 11:03:45 GMT https://community.qlik.com/t5/QlikView/set-analysis-issue/m-p/1204880#M387389 sunny_talwar 2016-10-19T11:03:45Z