topic Re: Help with Set Analysis!!! in QlikView https://community.qlik.com/t5/QlikView/Help-with-Set-Analysis/m-p/1128723#M890539 <HTML><HEAD></HEAD><BODY><P>Hi Saima!</P><P></P><P>It's = </P><P>PeriodID = {"&lt;=$(=Max(PeriodID))"},</P><P>Year = {$(=Max(Year))},</P><P>Quarter = ,</P><P>Half = ,</P><P>Month = ,</P><P>Period =</P><P></P><P>Works pecfect with <STRONG style="font-size: 12px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d; background-color: #f2f2f2;">Sum({&lt;Indicators = {'Economic Value Added'}, $(vSetYTD)&gt;} USD)</STRONG></P><P></P></BODY></HTML> Sat, 20 Aug 2016 13:59:06 GMT educastri83 2016-08-20T13:59:06Z Help with Set Analysis!!! https://community.qlik.com/t5/QlikView/Help-with-Set-Analysis/m-p/1128715#M890531 <HTML><HEAD></HEAD><BODY><P><SPAN lang="en">Hello community !!<BR /><BR /><BR />I have a problem I think it's easy but I can not find the solution.<BR /><BR /><BR />I'll want to create a KPI using a " <STRONG>Text Box</STRONG> " simple expression is:<BR /><BR /><BR />=<EM> Sum ( { &lt; Indicators = ' Economic Value Added ' } &gt; } USD )</EM><BR /><BR /><BR />You see I have a dimension called "<STRONG>Indicators"</STRONG> but I just want the KPI to show that the result of the indicator ' Economic Value Added '<BR /><BR /><BR />All good there, the difficulty I have is when I want to apply Set Analysis with variables as vSetQTD , vSetYTD etc .. .. </SPAN></P><P><SPAN lang="en"><BR /></SPAN></P><P><SPAN lang="en">I don't know like writing the expression. Normally I would with<BR /><BR /><EM>= Sum ( { &lt; $ ( vSetYTD ) &gt; } USD )</EM><BR /><BR /><BR />How do I get back my previous expression but only of my indicator " Economic Value Added '<BR /><BR /><BR />Thank you very much , I think it is simple but I've been mulling over time .<BR /><BR /><BR />Eduardo</SPAN></P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Help-with-Set-Analysis/m-p/1128715#M890531 educastri83 2020-11-25T16:16:04Z Re: Help with Set Analysis!!! https://community.qlik.com/t5/QlikView/Help-with-Set-Analysis/m-p/1128716#M890532 <HTML><HEAD></HEAD><BODY><P>May be like this?</P><P></P><P><STRONG>=Sum({&lt;Indicators = {'Economic Value Added'}, $(vSetYTD)&gt;} USD)</STRONG></P></BODY></HTML> Thu, 18 Aug 2016 00:44:35 GMT https://community.qlik.com/t5/QlikView/Help-with-Set-Analysis/m-p/1128716#M890532 sunny_talwar 2016-08-18T00:44:35Z Re: Help with Set Analysis!!! https://community.qlik.com/t5/QlikView/Help-with-Set-Analysis/m-p/1128717#M890533 <HTML><HEAD></HEAD><BODY><P>what is the value of the variable <EM style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">$ ( vSetYTD ) ??</EM></P></BODY></HTML> Thu, 18 Aug 2016 06:11:37 GMT https://community.qlik.com/t5/QlikView/Help-with-Set-Analysis/m-p/1128717#M890533 saimahasan 2016-08-18T06:11:37Z Re: Help with Set Analysis!!! https://community.qlik.com/t5/QlikView/Help-with-Set-Analysis/m-p/1128718#M890534 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>Add this '<STRONG>{</STRONG>' in your expression.</P><P>I think it should be work.</P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"><STRONG>=</STRONG></SPAN><EM style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG> Sum ( { &lt; Indicators =<SPAN style="color: #ff6600;"> {</SPAN>' Economic Value Added ' } &gt; } USD )</STRONG></EM></P></BODY></HTML> Thu, 18 Aug 2016 06:35:43 GMT https://community.qlik.com/t5/QlikView/Help-with-Set-Analysis/m-p/1128718#M890534 susovan 2016-08-18T06:35:43Z Re: Help with Set Analysis!!! https://community.qlik.com/t5/QlikView/Help-with-Set-Analysis/m-p/1128719#M890535 <HTML><HEAD></HEAD><BODY><P>Hi Eduardo,</P><P>I suggest you to write it like a function:</P><P></P><P>Create a variable like this:</P><P>SUM({&lt;<STRONG>$($1),Indicators = {'$2'}</STRONG>&gt;},$3)</P><P></P><P>On text box:</P><P><SPAN lang="en">=<EM> $(YourVarName(SetAnalysisYTDVarName,IndicatorFieldValue,FieldToSum)</EM></SPAN></P><P><SPAN lang="en"><EM><BR /></EM></SPAN></P><P><SPAN lang="en">With this you can write all your KPIs with only one variable.</SPAN></P><P><SPAN lang="en"><BR /></SPAN></P><P><SPAN lang="en">Regards!<BR /></SPAN></P></BODY></HTML> Thu, 18 Aug 2016 06:37:02 GMT https://community.qlik.com/t5/QlikView/Help-with-Set-Analysis/m-p/1128719#M890535 Anonymous 2016-08-18T06:37:02Z Re: Help with Set Analysis!!! https://community.qlik.com/t5/QlikView/Help-with-Set-Analysis/m-p/1128720#M890536 <HTML><HEAD></HEAD><BODY><P><STRONG>Expression could be depend on what value stored in variables $(<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">vSetQTD) , $(vSetYTD).</SPAN></STRONG></P><P><STRONG>Please let us know variables details.</STRONG></P><P></P><P><STRONG>- Regards,</STRONG></P><P><STRONG>Vishal Waghole</STRONG></P></BODY></HTML> Thu, 18 Aug 2016 07:31:44 GMT https://community.qlik.com/t5/QlikView/Help-with-Set-Analysis/m-p/1128720#M890536 VishalWaghole 2016-08-18T07:31:44Z Re: Help with Set Analysis!!! https://community.qlik.com/t5/QlikView/Help-with-Set-Analysis/m-p/1128721#M890537 <HTML><HEAD></HEAD><BODY><P>it Works!!!!! thank a lot Sunny</P></BODY></HTML> Sat, 20 Aug 2016 13:24:32 GMT https://community.qlik.com/t5/QlikView/Help-with-Set-Analysis/m-p/1128721#M890537 educastri83 2016-08-20T13:24:32Z Re: Help with Set Analysis!!! https://community.qlik.com/t5/QlikView/Help-with-Set-Analysis/m-p/1128722#M890538 <HTML><HEAD></HEAD><BODY><P>Ok!! You're Right! Thanks</P></BODY></HTML> Sat, 20 Aug 2016 13:26:40 GMT https://community.qlik.com/t5/QlikView/Help-with-Set-Analysis/m-p/1128722#M890538 educastri83 2016-08-20T13:26:40Z Re: Help with Set Analysis!!! https://community.qlik.com/t5/QlikView/Help-with-Set-Analysis/m-p/1128723#M890539 <HTML><HEAD></HEAD><BODY><P>Hi Saima!</P><P></P><P>It's = </P><P>PeriodID = {"&lt;=$(=Max(PeriodID))"},</P><P>Year = {$(=Max(Year))},</P><P>Quarter = ,</P><P>Half = ,</P><P>Month = ,</P><P>Period =</P><P></P><P>Works pecfect with <STRONG style="font-size: 12px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d; background-color: #f2f2f2;">Sum({&lt;Indicators = {'Economic Value Added'}, $(vSetYTD)&gt;} USD)</STRONG></P><P></P></BODY></HTML> Sat, 20 Aug 2016 13:59:06 GMT https://community.qlik.com/t5/QlikView/Help-with-Set-Analysis/m-p/1128723#M890539 educastri83 2016-08-20T13:59:06Z Re: Help with Set Analysis!!! https://community.qlik.com/t5/QlikView/Help-with-Set-Analysis/m-p/1128724#M890540 <HTML><HEAD></HEAD><BODY><P>Perfect!!! Manuel</P><P></P><P>It Works, much better into a new variable <IMG src="https://community.qlik.com/legacyfs/online/emoticons/cool.png" /></P><P></P><P>Thanks</P></BODY></HTML> Sat, 20 Aug 2016 14:01:08 GMT https://community.qlik.com/t5/QlikView/Help-with-Set-Analysis/m-p/1128724#M890540 educastri83 2016-08-20T14:01:08Z Re: Help with Set Analysis!!! https://community.qlik.com/t5/QlikView/Help-with-Set-Analysis/m-p/1128725#M890541 <HTML><HEAD></HEAD><BODY><P>Hi Vishal!</P><P></P><P>Variable Value = </P><P style="font-size: 13.3333px;">PeriodID = {"&lt;=$(=Max(PeriodID))"},</P><P style="font-size: 13.3333px;">Year = {$(=Max(Year))},</P><P style="font-size: 13.3333px;">Quarter = ,</P><P style="font-size: 13.3333px;">Half = ,</P><P style="font-size: 13.3333px;">Month = ,</P><P style="font-size: 13.3333px;">Period =</P></BODY></HTML> Sat, 20 Aug 2016 14:49:39 GMT https://community.qlik.com/t5/QlikView/Help-with-Set-Analysis/m-p/1128725#M890541 educastri83 2016-08-20T14:49:39Z