topic Re: SET ANALYSIS in QlikView https://community.qlik.com/t5/QlikView/SET-ANALYSIS/m-p/708361#M255160 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-size: 8pt; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #0000ff;">Count(If(Aggr</SPAN><SPAN style="font-size: 8pt; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">(</SPAN><SPAN style="font-size: 8pt; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #0000ff;">Sum</SPAN><SPAN style="font-size: 8pt; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">({&lt;</SPAN><SPAN style="font-size: 8pt; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #800000;">[BUDGET VERSION]</SPAN><SPAN style="font-size: 8pt; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">={</SPAN><STRONG style="font-size: 11px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><EM style="font-weight: inherit; font-size: 8pt; font-family: inherit; color: #808080;">$(vMaxBudgetVersion)</EM></STRONG><SPAN style="font-size: 8pt; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">}</SPAN><SPAN style="font-size: 8pt; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">&gt;}ActualCurrentBook</SPAN><SPAN style="font-size: 8pt; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">),PROJECT)&gt;0,<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 11px;">PROJECT))</SPAN></SPAN></P></BODY></HTML> Mon, 13 Oct 2014 01:42:04 GMT anbu1984 2014-10-13T01:42:04Z SET ANALYSIS https://community.qlik.com/t5/QlikView/SET-ANALYSIS/m-p/708356#M255155 <HTML><HEAD></HEAD><BODY><P>HI,</P><P></P><P>I WANT TO COUNT PROJECTS THAT-</P><P></P><P></P><P><SPAN style="font-size: 8pt;"><SPAN style="color: #0000ff; font-size: 8pt;">Aggr</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">Sum</SPAN><SPAN style="font-size: 8pt;">({&lt;</SPAN><SPAN style="color: #800000; font-size: 8pt;">[BUDGET VERSION]</SPAN><SPAN style="font-size: 8pt;">={</SPAN><STRONG><EM style=": ; color: #808080; font-size: 8pt;">$(vMaxBudgetVersion)</EM></STRONG><SPAN style="font-size: 8pt;">}</SPAN><SPAN style="font-size: 8pt;">&gt;}ActualCurrentBook</SPAN><SPAN style="font-size: 8pt;">),PROJECT)&gt;0</SPAN></SPAN></P><P><SPAN style="font-size: 8pt;">AND</SPAN></P><P><SPAN style="font-size: 8pt;">Aggr(Sum({&lt;<SPAN style="color: #800000; font-size: 8pt;">[BUDGET VERSION]</SPAN><SPAN style="font-size: 8pt;">={</SPAN><STRONG><EM style=": ; color: #808080; font-size: 8pt;">$(vMaxBudgetVersion)</EM></STRONG><SPAN style="font-size: 8pt;">}&gt;}BudgetCurrentBook</SPAN><SPAN style="font-size: 8pt;">),PROJECT)&gt;0)<BR /></SPAN></SPAN></P><P></P><P><SPAN style="color: #0000ff; font-size: 8pt;">HOW SHOULD I WRITE THE EXPRESSION?</SPAN></P><P></P></BODY></HTML> Sun, 12 Oct 2014 12:30:35 GMT https://community.qlik.com/t5/QlikView/SET-ANALYSIS/m-p/708356#M255155 adiarnon 2014-10-12T12:30:35Z Re: SET ANALYSIS https://community.qlik.com/t5/QlikView/SET-ANALYSIS/m-p/708357#M255156 <HTML><HEAD></HEAD><BODY><P><BR />?</P></BODY></HTML> Sun, 12 Oct 2014 13:14:49 GMT https://community.qlik.com/t5/QlikView/SET-ANALYSIS/m-p/708357#M255156 adiarnon 2014-10-12T13:14:49Z Re: SET ANALYSIS https://community.qlik.com/t5/QlikView/SET-ANALYSIS/m-p/708358#M255157 <HTML><HEAD></HEAD><BODY><P>Hi Adi,</P><P></P><P>can you please let me know the condition you want to implement?</P><P></P><P>Regards</P><P>KC</P></BODY></HTML> Sun, 12 Oct 2014 13:22:19 GMT https://community.qlik.com/t5/QlikView/SET-ANALYSIS/m-p/708358#M255157 jyothish8807 2014-10-12T13:22:19Z Re: SET ANALYSIS https://community.qlik.com/t5/QlikView/SET-ANALYSIS/m-p/708359#M255158 <HTML><HEAD></HEAD><BODY><P>I want to count the number of projects that</P><P></P><P>Sum({&lt;[BUDGET VERSION]={$(vMaxBudgetVersion)}&gt;}ActualCurrentBook)&gt;0</P><P><STRONG>and</STRONG></P><P>Sum({&lt;<SPAN style="color: #800000; font-size: 8pt;">[BUDGET VERSION]</SPAN><SPAN style="font-size: 8pt;">={</SPAN><STRONG><EM style="color: #808080; font-size: 8pt;">$(vMaxBudgetVersion)</EM></STRONG><SPAN style="font-size: 8pt;">}&gt;}BudgetCurrentBook</SPAN><SPAN style="font-size: 8pt;">)&gt;0</SPAN></P><P> </P><P> </P><P> </P><P> </P></BODY></HTML> Sun, 12 Oct 2014 13:34:16 GMT https://community.qlik.com/t5/QlikView/SET-ANALYSIS/m-p/708359#M255158 adiarnon 2014-10-12T13:34:16Z Re: SET ANALYSIS https://community.qlik.com/t5/QlikView/SET-ANALYSIS/m-p/708360#M255159 <HTML><HEAD></HEAD><BODY><P>Hi Adi,</P><P></P><P>Is this you want?</P><P></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">Count({&lt;[BUDGET VERSION]={'$(=vMaxBudgetVersion)'}&gt;}Project)</SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;"><BR /></SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">Regards</SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">KC<BR /></SPAN></P></BODY></HTML> Sun, 12 Oct 2014 13:43:43 GMT https://community.qlik.com/t5/QlikView/SET-ANALYSIS/m-p/708360#M255159 jyothish8807 2014-10-12T13:43:43Z Re: SET ANALYSIS https://community.qlik.com/t5/QlikView/SET-ANALYSIS/m-p/708361#M255160 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-size: 8pt; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #0000ff;">Count(If(Aggr</SPAN><SPAN style="font-size: 8pt; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">(</SPAN><SPAN style="font-size: 8pt; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #0000ff;">Sum</SPAN><SPAN style="font-size: 8pt; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">({&lt;</SPAN><SPAN style="font-size: 8pt; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #800000;">[BUDGET VERSION]</SPAN><SPAN style="font-size: 8pt; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">={</SPAN><STRONG style="font-size: 11px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><EM style="font-weight: inherit; font-size: 8pt; font-family: inherit; color: #808080;">$(vMaxBudgetVersion)</EM></STRONG><SPAN style="font-size: 8pt; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">}</SPAN><SPAN style="font-size: 8pt; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">&gt;}ActualCurrentBook</SPAN><SPAN style="font-size: 8pt; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">),PROJECT)&gt;0,<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 11px;">PROJECT))</SPAN></SPAN></P></BODY></HTML> Mon, 13 Oct 2014 01:42:04 GMT https://community.qlik.com/t5/QlikView/SET-ANALYSIS/m-p/708361#M255160 anbu1984 2014-10-13T01:42:04Z