topic Re: Variable use in September analysis. in QlikView https://community.qlik.com/t5/QlikView/Variable-use-in-September-analysis/m-p/986613#M527561 <HTML><HEAD></HEAD><BODY><P>Maybe</P><P></P><P><SPAN class="atn hps">(</SPAN><SPAN class="atn">sum (</SPAN><SPAN class="atn">{</SPAN>1 <SPAN class="atn hps">&lt;</SPAN><SPAN class="atn">[</SPAN>Flg <SPAN class="hps">Activity Type</SPAN>] <SPAN class="hps">=</SPAN> <SPAN class="atn hps">{</SPAN><SPAN class="atn hps">'</SPAN>F'}, <SPAN class="atn hps">[</SPAN>Series] <SPAN class="hps">=</SPAN> <SPAN class="atn hps">{'$(=Maxstring([Series]))'</SPAN>} &gt;} <SPAN class="atn hps">[</SPAN>Budget <SPAN class="hps">in</SPAN> <SPAN class="hps">€</SPAN>] <SPAN class="hps">/</SPAN> <SPAN class="hps">1000000</SPAN>), <SPAN class="atn hps">'</SPAN>### <SPAN class="hps">0,0</SPAN>')</P><P></P><P>or if you already have a <EM>correctly formatted </EM>variable</P><P></P><P><SPAN class="atn hps">(</SPAN><SPAN class="atn">sum (</SPAN><SPAN class="atn">{</SPAN>1 <SPAN class="atn hps">&lt;</SPAN><SPAN class="atn">[</SPAN>Flg <SPAN class="hps">Activity Type</SPAN>] <SPAN class="hps">=</SPAN> <SPAN class="atn hps">{</SPAN><SPAN class="atn hps">'</SPAN>F'}, <SPAN class="atn hps">[</SPAN>Series] <SPAN class="hps">=</SPAN> <SPAN class="atn hps">{'$(SerieMax)'</SPAN>} &gt;} <SPAN class="atn hps">[</SPAN>Budget <SPAN class="hps">in</SPAN> <SPAN class="hps">€</SPAN>] <SPAN class="hps">/</SPAN> <SPAN class="hps">1000000</SPAN>), <SPAN class="atn hps">'</SPAN>### <SPAN class="hps">0,0</SPAN>')</P></BODY></HTML> Thu, 29 Oct 2015 07:40:12 GMT swuehl 2015-10-29T07:40:12Z Variable use in September analysis. https://community.qlik.com/t5/QlikView/Variable-use-in-September-analysis/m-p/986612#M527560 <HTML><HEAD></HEAD><BODY><P><SPAN lang="en"><SPAN class="hps">Goodmorning everyone</SPAN></SPAN></P><P><SPAN lang="en"><SPAN class="hps"></SPAN><BR /> <SPAN class="hps">I</SPAN> <SPAN class="hps">need to</SPAN> <SPAN class="hps">use in the comparison</SPAN> <SPAN class="hps">of a</SPAN> <SPAN class="hps">setanalisys</SPAN> <SPAN class="hps">a formula</SPAN>, <SPAN class="hps">a variable</SPAN> <SPAN class="hps">rather than</SPAN> <SPAN class="hps">a</SPAN> <SPAN class="hps">fixed value</SPAN>.</SPAN></P><P><SPAN lang="en"><BR /> <SPAN class="hps">I'll explain :</SPAN><BR /> <SPAN class="hps">currently</SPAN> <SPAN class="hps">I use</SPAN> <SPAN class="hps">the formula that</SPAN> <SPAN class="hps">is:</SPAN></SPAN></P><P><SPAN lang="en"><SPAN class="hps"></SPAN><BR /> <SPAN class="hps">num</SPAN> <SPAN class="hps">=</SPAN> <SPAN class="hps atn">(</SPAN><SPAN class="atn">sum (</SPAN><SPAN class="atn">{</SPAN>1 <SPAN class="hps atn">&lt;</SPAN><SPAN class="atn">[</SPAN>Flg <SPAN class="hps">Activity Type</SPAN>] <SPAN class="hps">=</SPAN> <SPAN class="hps atn">{</SPAN><SPAN class="hps atn">'</SPAN>F'}, <SPAN class="hps atn">[</SPAN>Series] <SPAN class="hps">=</SPAN> <SPAN class="hps atn">{</SPAN><SPAN class="hps atn">'</SPAN>20150930'}&gt;} <SPAN class="hps atn">[</SPAN>Budget <SPAN class="hps">in</SPAN> <SPAN class="hps">€</SPAN>] <SPAN class="hps">/</SPAN> <SPAN class="hps">1000000</SPAN>), <SPAN class="hps atn">'</SPAN>### <SPAN class="hps">0,0</SPAN>')</SPAN></P><P><SPAN lang="en"><BR /></SPAN></P><P><SPAN lang="en"> <SPAN class="hps">I</SPAN>, however, <SPAN class="hps">more serious</SPAN> <SPAN class="hps">so</SPAN> <SPAN class="hps">instead</SPAN> <SPAN class="hps">set the value</SPAN> <SPAN class="hps">20150930</SPAN> <SPAN class="hps">I would insert</SPAN> <SPAN class="hps">a variable</SPAN> <SPAN class="hps">seriemax</SPAN> <SPAN class="hps">that</SPAN> <SPAN class="hps">I</SPAN> <SPAN class="hps">set as</SPAN> <SPAN class="hps">MAX</SPAN> <SPAN class="hps atn">(</SPAN>Series)<BR /> <SPAN class="hps">I tried using</SPAN> <SPAN class="hps">the syntax</SPAN><BR /> <SPAN class="hps">num</SPAN> <SPAN class="hps">=</SPAN> <SPAN class="hps atn">(</SPAN><SPAN class="atn">sum (</SPAN><SPAN class="atn">{</SPAN>1 <SPAN class="hps atn">&lt;</SPAN><SPAN class="atn">[</SPAN>Flg <SPAN class="hps">Activity Type</SPAN>] <SPAN class="hps">=</SPAN> <SPAN class="hps atn">{</SPAN><SPAN class="hps atn">'</SPAN>F'}, <SPAN class="hps atn">[</SPAN>Series] <SPAN class="hps">=</SPAN> <SPAN class="hps atn">{</SPAN>} <SPAN class="hps">=</SPAN> <SPAN class="hps">SerieMax</SPAN>&gt;} <SPAN class="hps atn">[</SPAN>Budget <SPAN class="hps">in</SPAN> <SPAN class="hps">€</SPAN>] <SPAN class="hps">/</SPAN> <SPAN class="hps">1000000</SPAN>), <SPAN class="hps atn">'</SPAN>### <SPAN class="hps">0,0</SPAN>')<BR /> <SPAN class="hps">but</SPAN> <SPAN class="hps">the formula returns</SPAN> <SPAN class="hps">error</SPAN>.</SPAN></P><P><SPAN lang="en"><BR /> <SPAN class="hps">can you help me?</SPAN></SPAN></P><P><SPAN lang="en"><SPAN class="hps"></SPAN><BR /> <SPAN class="hps">Thank you</SPAN></SPAN></P><P><SPAN lang="en"><SPAN class="hps"></SPAN><BR /> <SPAN class="hps">Andrea</SPAN></SPAN></P></BODY></HTML> Thu, 29 Oct 2015 07:32:26 GMT https://community.qlik.com/t5/QlikView/Variable-use-in-September-analysis/m-p/986612#M527560 warrentk80 2015-10-29T07:32:26Z Re: Variable use in September analysis. https://community.qlik.com/t5/QlikView/Variable-use-in-September-analysis/m-p/986613#M527561 <HTML><HEAD></HEAD><BODY><P>Maybe</P><P></P><P><SPAN class="atn hps">(</SPAN><SPAN class="atn">sum (</SPAN><SPAN class="atn">{</SPAN>1 <SPAN class="atn hps">&lt;</SPAN><SPAN class="atn">[</SPAN>Flg <SPAN class="hps">Activity Type</SPAN>] <SPAN class="hps">=</SPAN> <SPAN class="atn hps">{</SPAN><SPAN class="atn hps">'</SPAN>F'}, <SPAN class="atn hps">[</SPAN>Series] <SPAN class="hps">=</SPAN> <SPAN class="atn hps">{'$(=Maxstring([Series]))'</SPAN>} &gt;} <SPAN class="atn hps">[</SPAN>Budget <SPAN class="hps">in</SPAN> <SPAN class="hps">€</SPAN>] <SPAN class="hps">/</SPAN> <SPAN class="hps">1000000</SPAN>), <SPAN class="atn hps">'</SPAN>### <SPAN class="hps">0,0</SPAN>')</P><P></P><P>or if you already have a <EM>correctly formatted </EM>variable</P><P></P><P><SPAN class="atn hps">(</SPAN><SPAN class="atn">sum (</SPAN><SPAN class="atn">{</SPAN>1 <SPAN class="atn hps">&lt;</SPAN><SPAN class="atn">[</SPAN>Flg <SPAN class="hps">Activity Type</SPAN>] <SPAN class="hps">=</SPAN> <SPAN class="atn hps">{</SPAN><SPAN class="atn hps">'</SPAN>F'}, <SPAN class="atn hps">[</SPAN>Series] <SPAN class="hps">=</SPAN> <SPAN class="atn hps">{'$(SerieMax)'</SPAN>} &gt;} <SPAN class="atn hps">[</SPAN>Budget <SPAN class="hps">in</SPAN> <SPAN class="hps">€</SPAN>] <SPAN class="hps">/</SPAN> <SPAN class="hps">1000000</SPAN>), <SPAN class="atn hps">'</SPAN>### <SPAN class="hps">0,0</SPAN>')</P></BODY></HTML> Thu, 29 Oct 2015 07:40:12 GMT https://community.qlik.com/t5/QlikView/Variable-use-in-September-analysis/m-p/986613#M527561 swuehl 2015-10-29T07:40:12Z