topic Insert comparative field in QlikView https://community.qlik.com/t5/QlikView/Insert-comparative-field/m-p/488061#M691567 <HTML><HEAD></HEAD><BODY><P><SPAN lang="en"><SPAN class="hps">Hello</SPAN><SPAN>,</SPAN><BR /><BR /><SPAN class="hps">I'm having trouble</SPAN> <SPAN class="hps">creating</SPAN> <SPAN class="hps">the following situation</SPAN>:<BR /><BR /><SPAN class="hps">In the</SPAN> <SPAN class="hps">attached file</SPAN><SPAN>,</SPAN> <SPAN class="hps">if you</SPAN> <SPAN class="hps">have a table</SPAN> <SPAN class="hps">watching</SPAN> <SPAN class="hps">a table</SPAN> <SPAN class="hps">A1</SPAN> <SPAN class="hps">and</SPAN> <SPAN class="hps">A2</SPAN>, <SPAN class="hps">must take</SPAN> <SPAN class="hps">the field values</SPAN> <SPAN class="atn hps">​​"</SPAN>META" <SPAN class="hps">for table</SPAN> <SPAN class="hps">A2</SPAN> <SPAN class="hps">considering the value of</SPAN> <SPAN class="hps">last</SPAN> <SPAN class="atn hps">"</SPAN>MES" <SPAN class="hps">ie</SPAN> <SPAN class="hps">when I select</SPAN> <SPAN class="atn hps">"</SPAN>AGO" <SPAN class="atn hps">(</SPAN>August), <SPAN class="hps">the table</SPAN> <SPAN class="hps">A1</SPAN> <SPAN class="hps">should I</SPAN> <SPAN class="hps">bring</SPAN> <SPAN class="hps">values</SPAN> <SPAN class="hps">​​AGO</SPAN> <SPAN class="atn hps">(</SPAN><SPAN>August)</SPAN> <SPAN class="hps">and the field</SPAN> <SPAN class="hps">META</SPAN> <SPAN class="hps">(Goal</SPAN>) <SPAN class="hps">bring me</SPAN> <SPAN class="hps">the value of</SPAN> <SPAN class="hps">JUL</SPAN> <SPAN class="hps">(July</SPAN><SPAN>) in order to</SPAN> <SPAN class="hps">know if</SPAN> <SPAN class="hps">the value</SPAN> <SPAN class="hps">I am</SPAN> <SPAN class="hps">quoting</SPAN> <SPAN class="hps">the</SPAN> <SPAN class="hps">current month</SPAN> <SPAN class="hps">is</SPAN> <SPAN class="hps">less than or</SPAN> <SPAN class="hps">greater than the value</SPAN> <SPAN class="hps">quoted</SPAN> <SPAN class="hps">in the previous month</SPAN><SPAN>.</SPAN></SPAN></P></BODY></HTML> Thu, 05 Sep 2013 13:52:23 GMT 2013-09-05T13:52:23Z Insert comparative field https://community.qlik.com/t5/QlikView/Insert-comparative-field/m-p/488061#M691567 <HTML><HEAD></HEAD><BODY><P><SPAN lang="en"><SPAN class="hps">Hello</SPAN><SPAN>,</SPAN><BR /><BR /><SPAN class="hps">I'm having trouble</SPAN> <SPAN class="hps">creating</SPAN> <SPAN class="hps">the following situation</SPAN>:<BR /><BR /><SPAN class="hps">In the</SPAN> <SPAN class="hps">attached file</SPAN><SPAN>,</SPAN> <SPAN class="hps">if you</SPAN> <SPAN class="hps">have a table</SPAN> <SPAN class="hps">watching</SPAN> <SPAN class="hps">a table</SPAN> <SPAN class="hps">A1</SPAN> <SPAN class="hps">and</SPAN> <SPAN class="hps">A2</SPAN>, <SPAN class="hps">must take</SPAN> <SPAN class="hps">the field values</SPAN> <SPAN class="atn hps">​​"</SPAN>META" <SPAN class="hps">for table</SPAN> <SPAN class="hps">A2</SPAN> <SPAN class="hps">considering the value of</SPAN> <SPAN class="hps">last</SPAN> <SPAN class="atn hps">"</SPAN>MES" <SPAN class="hps">ie</SPAN> <SPAN class="hps">when I select</SPAN> <SPAN class="atn hps">"</SPAN>AGO" <SPAN class="atn hps">(</SPAN>August), <SPAN class="hps">the table</SPAN> <SPAN class="hps">A1</SPAN> <SPAN class="hps">should I</SPAN> <SPAN class="hps">bring</SPAN> <SPAN class="hps">values</SPAN> <SPAN class="hps">​​AGO</SPAN> <SPAN class="atn hps">(</SPAN><SPAN>August)</SPAN> <SPAN class="hps">and the field</SPAN> <SPAN class="hps">META</SPAN> <SPAN class="hps">(Goal</SPAN>) <SPAN class="hps">bring me</SPAN> <SPAN class="hps">the value of</SPAN> <SPAN class="hps">JUL</SPAN> <SPAN class="hps">(July</SPAN><SPAN>) in order to</SPAN> <SPAN class="hps">know if</SPAN> <SPAN class="hps">the value</SPAN> <SPAN class="hps">I am</SPAN> <SPAN class="hps">quoting</SPAN> <SPAN class="hps">the</SPAN> <SPAN class="hps">current month</SPAN> <SPAN class="hps">is</SPAN> <SPAN class="hps">less than or</SPAN> <SPAN class="hps">greater than the value</SPAN> <SPAN class="hps">quoted</SPAN> <SPAN class="hps">in the previous month</SPAN><SPAN>.</SPAN></SPAN></P></BODY></HTML> Thu, 05 Sep 2013 13:52:23 GMT https://community.qlik.com/t5/QlikView/Insert-comparative-field/m-p/488061#M691567 2013-09-05T13:52:23Z Re: Insert comparative field https://community.qlik.com/t5/QlikView/Insert-comparative-field/m-p/488062#M691568 <HTML><HEAD></HEAD><BODY><P>See attached qwv</P></BODY></HTML> Thu, 05 Sep 2013 17:07:32 GMT https://community.qlik.com/t5/QlikView/Insert-comparative-field/m-p/488062#M691568 Gysbert_Wassenaar 2013-09-05T17:07:32Z Re: Insert comparative field https://community.qlik.com/t5/QlikView/Insert-comparative-field/m-p/488063#M691569 <HTML><HEAD></HEAD><BODY><P><SPAN class="short_text" lang="en"><SPAN class="hps">Thank</SPAN> <SPAN class="hps">G</SPAN> <SPAN class="hps">Wassenaar! <BR /></SPAN></SPAN></P></BODY></HTML> Mon, 09 Sep 2013 19:44:05 GMT https://community.qlik.com/t5/QlikView/Insert-comparative-field/m-p/488063#M691569 2013-09-09T19:44:05Z Re: Insert comparative field https://community.qlik.com/t5/QlikView/Insert-comparative-field/m-p/488064#M691570 <HTML><HEAD></HEAD><BODY><P><SPAN lang="en"><SPAN class="hps">G</SPAN> <SPAN class="hps">Wassenaar</SPAN>, <SPAN class="hps">is</SPAN> <SPAN class="hps">possible</SPAN> <SPAN class="hps">in the same situation</SPAN> <SPAN class="hps">when the value</SPAN> <SPAN class="hps">of the previous month</SPAN> <SPAN class="hps">is</SPAN> <SPAN class="hps">0</SPAN> <SPAN class="hps">it will bring</SPAN> <SPAN class="hps">the lowest</SPAN> <SPAN class="hps">value of the</SPAN> <SPAN class="hps">first record</SPAN> <SPAN class="hps">to find</SPAN>?<BR /><BR /><SPAN class="hps">Example</SPAN>: <SPAN class="hps">August</SPAN> <SPAN class="hps">target</SPAN> <SPAN class="hps">value</SPAN> <SPAN class="hps">is</SPAN> <SPAN class="hps">July</SPAN>, <SPAN class="hps">but</SPAN> <SPAN class="hps">July is</SPAN> <SPAN class="hps">equal to</SPAN> <SPAN class="hps">0</SPAN>, <SPAN class="hps">then it</SPAN> <SPAN class="hps">bring me</SPAN> <SPAN class="hps">the value</SPAN> <SPAN class="hps">of June.</SPAN></SPAN></P></BODY></HTML> Mon, 09 Sep 2013 19:46:53 GMT https://community.qlik.com/t5/QlikView/Insert-comparative-field/m-p/488064#M691570 2013-09-09T19:46:53Z