topic Problem with expression in QlikView https://community.qlik.com/t5/QlikView/Problem-with-expression/m-p/401604#M149432 <HTML><HEAD></HEAD><BODY><P><SPAN class="hps">Hi:</SPAN></P><P><SPAN class="hps"></SPAN></P><P><SPAN class="hps">I have</SPAN> <SPAN class="hps">problems</SPAN> <SPAN class="hps">with</SPAN> <SPAN class="hps">the following expression</SPAN>:</P><P></P><P>=<SPAN style="color: #0000ff; font-size: 8pt;">sum</SPAN><SPAN style="font-size: 8pt;">({$&lt;</SPAN><SPAN style="color: #800000; font-size: 8pt;">MesAño</SPAN><SPAN style="font-size: 8pt;">={ </SPAN><STRONG><EM style=": ; color: #808080; font-size: 8pt;">$(vMesAnoAct)</EM></STRONG><SPAN style="font-size: 8pt;"> }&gt;} </SPAN><SPAN style="color: #800000; font-size: 8pt;">Ventas</SPAN><SPAN style="font-size: 8pt;">) </SPAN></P><P></P><P><SPAN class="hps"></SPAN></P><P><SPAN class="hps">But if</SPAN> <SPAN class="hps">the date</SPAN> <SPAN class="hps">specified</SPAN> <SPAN class="hps">explicitly</SPAN>, as shown <SPAN class="hps">below</SPAN>, <SPAN class="hps">if it works:</SPAN></P><P><SPAN class="hps"></SPAN></P><P>=<SPAN style="color: #0000ff; font-size: 8pt;">sum</SPAN><SPAN style="font-size: 8pt;">({$&lt;</SPAN><SPAN style="color: #800000; font-size: 8pt;">MesAño</SPAN><SPAN style="font-size: 8pt;">={ 'Sep-2012'}&gt;} </SPAN><SPAN style="color: #800000; font-size: 8pt;">Ventas</SPAN><SPAN style="font-size: 8pt;">) </SPAN></P><P></P><P><SPAN class="hps"></SPAN></P><P><SPAN class="hps">I checked the</SPAN> <SPAN class="hps">field </SPAN><SPAN class="hps">and variable</SPAN>&nbsp; format <SPAN class="hps">and are equal</SPAN></P><P></P><P></P><P><SPAN class="hps">Thanks...</SPAN></P></BODY></HTML> Wed, 12 Sep 2012 15:21:35 GMT 2012-09-12T15:21:35Z Problem with expression https://community.qlik.com/t5/QlikView/Problem-with-expression/m-p/401604#M149432 <HTML><HEAD></HEAD><BODY><P><SPAN class="hps">Hi:</SPAN></P><P><SPAN class="hps"></SPAN></P><P><SPAN class="hps">I have</SPAN> <SPAN class="hps">problems</SPAN> <SPAN class="hps">with</SPAN> <SPAN class="hps">the following expression</SPAN>:</P><P></P><P>=<SPAN style="color: #0000ff; font-size: 8pt;">sum</SPAN><SPAN style="font-size: 8pt;">({$&lt;</SPAN><SPAN style="color: #800000; font-size: 8pt;">MesAño</SPAN><SPAN style="font-size: 8pt;">={ </SPAN><STRONG><EM style=": ; color: #808080; font-size: 8pt;">$(vMesAnoAct)</EM></STRONG><SPAN style="font-size: 8pt;"> }&gt;} </SPAN><SPAN style="color: #800000; font-size: 8pt;">Ventas</SPAN><SPAN style="font-size: 8pt;">) </SPAN></P><P></P><P><SPAN class="hps"></SPAN></P><P><SPAN class="hps">But if</SPAN> <SPAN class="hps">the date</SPAN> <SPAN class="hps">specified</SPAN> <SPAN class="hps">explicitly</SPAN>, as shown <SPAN class="hps">below</SPAN>, <SPAN class="hps">if it works:</SPAN></P><P><SPAN class="hps"></SPAN></P><P>=<SPAN style="color: #0000ff; font-size: 8pt;">sum</SPAN><SPAN style="font-size: 8pt;">({$&lt;</SPAN><SPAN style="color: #800000; font-size: 8pt;">MesAño</SPAN><SPAN style="font-size: 8pt;">={ 'Sep-2012'}&gt;} </SPAN><SPAN style="color: #800000; font-size: 8pt;">Ventas</SPAN><SPAN style="font-size: 8pt;">) </SPAN></P><P></P><P><SPAN class="hps"></SPAN></P><P><SPAN class="hps">I checked the</SPAN> <SPAN class="hps">field </SPAN><SPAN class="hps">and variable</SPAN>&nbsp; format <SPAN class="hps">and are equal</SPAN></P><P></P><P></P><P><SPAN class="hps">Thanks...</SPAN></P></BODY></HTML> Wed, 12 Sep 2012 15:21:35 GMT https://community.qlik.com/t5/QlikView/Problem-with-expression/m-p/401604#M149432 2012-09-12T15:21:35Z Re: Problem with expression https://community.qlik.com/t5/QlikView/Problem-with-expression/m-p/401605#M149433 <HTML><HEAD></HEAD><BODY><P>HI</P><P></P><P>Try like this</P><P></P><P>=<SPAN style="font-size: 8pt; color: #0000ff;">sum</SPAN><SPAN style="font-size: 8pt;">({$&lt;</SPAN><SPAN style="font-size: 8pt; color: #800000;">MesAño</SPAN><SPAN style="font-size: 8pt;">={ '</SPAN><STRONG style="font-size: 12px;"><EM style="font-size: 8pt; color: #808080;">$(vMesAnoAct)'</EM></STRONG><SPAN style="font-size: 8pt;"> }&gt;} </SPAN><SPAN style="font-size: 8pt; color: #800000;">Ventas</SPAN><SPAN style="font-size: 8pt;">)</SPAN></P><P></P><P><SPAN style="font-size: 8pt;">Hope it helps<BR /></SPAN></P></BODY></HTML> Wed, 12 Sep 2012 15:32:07 GMT https://community.qlik.com/t5/QlikView/Problem-with-expression/m-p/401605#M149433 MayilVahanan 2012-09-12T15:32:07Z Re: Problem with expression https://community.qlik.com/t5/QlikView/Problem-with-expression/m-p/401606#M149434 <HTML><HEAD></HEAD><BODY><P>Thanks</P><P></P><P>It works fine</P></BODY></HTML> Wed, 12 Sep 2012 15:47:56 GMT https://community.qlik.com/t5/QlikView/Problem-with-expression/m-p/401606#M149434 2012-09-12T15:47:56Z