topic Comparative Analysis in QlikView https://community.qlik.com/t5/QlikView/Comparative-Analysis/m-p/250039#M499551 <HTML><HEAD></HEAD><BODY><P> Thanks Erich!, this <SPAN class="short_text" id="result_box" lang="en"><SPAN class="hps" title="Haz clic para obtener otras posibles traducciones"><SPAN class="short_text" id="result_box" lang="en"><SPAN class="hps" title="Haz clic para obtener otras posibles traducciones">is</SPAN> <SPAN class="hps" title="Haz clic para obtener otras posibles traducciones">needed to know</SPAN></SPAN>.</SPAN></SPAN></P><P><SPAN class="short_text" lang="en"><SPAN class="hps" title="Haz clic para obtener otras posibles traducciones"> </SPAN></SPAN></P></BODY></HTML> Fri, 01 Jul 2011 17:14:33 GMT 2011-07-01T17:14:33Z Comparative Analysis https://community.qlik.com/t5/QlikView/Comparative-Analysis/m-p/250037#M499549 <HTML><HEAD></HEAD><BODY><P>Sorry, I'm new user QV.</P><P>On this instrucción </P><P>sum({$ &lt;DATE = {$(#=only(DATE)-1)}&gt;} CASH)</P><P></P><P><SPAN class="short_text" id="result_box" lang="en"><SPAN class="hps" title="Haz clic para obtener otras posibles traducciones">how I can</SPAN> <SPAN class="hps" title="Haz clic para obtener otras posibles traducciones">add a condition (for example the state of one <SPAN class="short_text" id="result_box" lang="en"><SPAN class="hps" title="Haz clic para obtener otras posibles traducciones">registration)</SPAN></SPAN>?</SPAN></SPAN></P><P><SPAN class="short_text" id="result_box" lang="en"><SPAN class="hps" title="Haz clic para obtener otras posibles traducciones">which would be the</SPAN> <SPAN class="hps" title="Haz clic para obtener otras posibles traducciones">syntax?</SPAN></SPAN></P></BODY></HTML> Fri, 01 Jul 2011 16:36:08 GMT https://community.qlik.com/t5/QlikView/Comparative-Analysis/m-p/250037#M499549 2011-07-01T16:36:08Z Comparative Analysis https://community.qlik.com/t5/QlikView/Comparative-Analysis/m-p/250038#M499550 <HTML><HEAD></HEAD><BODY><P> You may include as many fields as you want: </P><P></P><P></P><P></P>sum( { &lt; STATE = {'TEST'}, SOURCE = {'SYSTEM'}, DATE = {$(#=only(DATE)-1)}&gt; } CASH)<P></P><P></P><P></P><P></P><P></P></BODY></HTML> Fri, 01 Jul 2011 17:04:14 GMT https://community.qlik.com/t5/QlikView/Comparative-Analysis/m-p/250038#M499550 erichshiino 2011-07-01T17:04:14Z Comparative Analysis https://community.qlik.com/t5/QlikView/Comparative-Analysis/m-p/250039#M499551 <HTML><HEAD></HEAD><BODY><P> Thanks Erich!, this <SPAN class="short_text" id="result_box" lang="en"><SPAN class="hps" title="Haz clic para obtener otras posibles traducciones"><SPAN class="short_text" id="result_box" lang="en"><SPAN class="hps" title="Haz clic para obtener otras posibles traducciones">is</SPAN> <SPAN class="hps" title="Haz clic para obtener otras posibles traducciones">needed to know</SPAN></SPAN>.</SPAN></SPAN></P><P><SPAN class="short_text" lang="en"><SPAN class="hps" title="Haz clic para obtener otras posibles traducciones"> </SPAN></SPAN></P></BODY></HTML> Fri, 01 Jul 2011 17:14:33 GMT https://community.qlik.com/t5/QlikView/Comparative-Analysis/m-p/250039#M499551 2011-07-01T17:14:33Z