topic Re: Arithmetic with a variable in QlikView https://community.qlik.com/t5/QlikView/Arithmetic-with-a-variable/m-p/370396#M1172098 <HTML><HEAD></HEAD><BODY><P>Try this</P><P>&nbsp;&nbsp;&nbsp;&nbsp; $(=$(vMaxYear)-1)</P></BODY></HTML> Thu, 26 Jul 2012 19:47:29 GMT CELAMBARASAN 2012-07-26T19:47:29Z Arithmetic with a variable https://community.qlik.com/t5/QlikView/Arithmetic-with-a-variable/m-p/370395#M1172096 <HTML><HEAD></HEAD><BODY><P>I'm sure this is rock-stupid, but I can't find the correct syntax anywhere.</P><P></P><P>I have a variable, vMaxYear. My expression </P><P></P><P>=</P><P><SPAN style="color: #0000ff; font-size: 8pt;">aggr</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">count</SPAN><SPAN style="font-size: 8pt;">({&lt;</SPAN><SPAN style="color: #800000; font-size: 8pt;">Year</SPAN><SPAN style="font-size: 8pt;">={</SPAN><SPAN style="color: #800000; font-size: 8pt;">"$(vMaxYear)"</SPAN><SPAN style="font-size: 8pt;">}&gt;} </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">distinct</SPAN><SPAN style="font-size: 8pt;"> </SPAN><SPAN style="color: #800000; font-size: 8pt;">dlogin</SPAN><SPAN style="font-size: 8pt;">),</SPAN><SPAN style="color: #800000; font-size: 8pt;">COC_Company</SPAN><SPAN style="font-size: 8pt;">) </SPAN></P><P></P><P></P><P>works perfectly well to give me a count of "dlogin" by Company when the year = max year.</P><P></P><P>Now, I want to find out what happened in the <EM>previous year</EM>. I have tried "$(vMaxYear)-1", "$(vMaxYear-1)", "=$(vMaxYear)-1", and other</P><P>variations on the theme. None work. I have searched through the documentation, and can't find anything on the correct syntax.</P><P></P><P>Could anyone help?</P></BODY></HTML> Thu, 26 Jul 2012 19:40:29 GMT https://community.qlik.com/t5/QlikView/Arithmetic-with-a-variable/m-p/370395#M1172096 2012-07-26T19:40:29Z Re: Arithmetic with a variable https://community.qlik.com/t5/QlikView/Arithmetic-with-a-variable/m-p/370396#M1172098 <HTML><HEAD></HEAD><BODY><P>Try this</P><P>&nbsp;&nbsp;&nbsp;&nbsp; $(=$(vMaxYear)-1)</P></BODY></HTML> Thu, 26 Jul 2012 19:47:29 GMT https://community.qlik.com/t5/QlikView/Arithmetic-with-a-variable/m-p/370396#M1172098 CELAMBARASAN 2012-07-26T19:47:29Z Re: Arithmetic with a variable https://community.qlik.com/t5/QlikView/Arithmetic-with-a-variable/m-p/370397#M1172100 <HTML><HEAD></HEAD><BODY><P>Perfect. Thanks so much!</P></BODY></HTML> Thu, 26 Jul 2012 19:51:03 GMT https://community.qlik.com/t5/QlikView/Arithmetic-with-a-variable/m-p/370397#M1172100 2012-07-26T19:51:03Z