topic Prior Year missing Revenues in QlikView https://community.qlik.com/t5/QlikView/Prior-Year-missing-Revenues/m-p/583646#M477567 <HTML><HEAD></HEAD><BODY><P>All, I have 5 products with revenue last year, and this year only for of them have revenue. When comparing this years revenue vs last years revenue, I am receiving the proper grand total, however the product shows up but the revenue is blank?... any ideas?</P><P></P><P></P><P><SPAN style="font-size: 8pt;">({$&lt; </SPAN><SPAN style="color: #800000; font-size: 8pt;">Year</SPAN><SPAN style="font-size: 8pt;">= {</SPAN><STRONG><EM style=": ; color: #808080; font-size: 8pt;">$(= GetFieldSelections(Year)-1)</EM></STRONG><SPAN style="font-size: 8pt;">},</SPAN><SPAN style="color: #800000; font-size: 8pt;">[Calc.Type]</SPAN><SPAN style="font-size: 8pt;"> -= {'Forecast*'},Date={</SPAN><SPAN style="color: #800000; font-size: 8pt;">"&lt;=$(=vMaxDate)"</SPAN><SPAN style="font-size: 8pt;">}&gt;}</SPAN><SPAN style="color: #800000; font-size: 8pt;">[Amount]</SPAN><SPAN style="font-size: 8pt;">)/Factor </SPAN></P><P></P><P><SPAN style="font-size: 8pt;"><IMG alt="help.jpg" class="jive-image" src="https://community.qlik.com/legacyfs/online/57434_help.jpg" /></SPAN></P><P></P></BODY></HTML> Wed, 16 Apr 2014 12:16:47 GMT james 2014-04-16T12:16:47Z Prior Year missing Revenues https://community.qlik.com/t5/QlikView/Prior-Year-missing-Revenues/m-p/583646#M477567 <HTML><HEAD></HEAD><BODY><P>All, I have 5 products with revenue last year, and this year only for of them have revenue. When comparing this years revenue vs last years revenue, I am receiving the proper grand total, however the product shows up but the revenue is blank?... any ideas?</P><P></P><P></P><P><SPAN style="font-size: 8pt;">({$&lt; </SPAN><SPAN style="color: #800000; font-size: 8pt;">Year</SPAN><SPAN style="font-size: 8pt;">= {</SPAN><STRONG><EM style=": ; color: #808080; font-size: 8pt;">$(= GetFieldSelections(Year)-1)</EM></STRONG><SPAN style="font-size: 8pt;">},</SPAN><SPAN style="color: #800000; font-size: 8pt;">[Calc.Type]</SPAN><SPAN style="font-size: 8pt;"> -= {'Forecast*'},Date={</SPAN><SPAN style="color: #800000; font-size: 8pt;">"&lt;=$(=vMaxDate)"</SPAN><SPAN style="font-size: 8pt;">}&gt;}</SPAN><SPAN style="color: #800000; font-size: 8pt;">[Amount]</SPAN><SPAN style="font-size: 8pt;">)/Factor </SPAN></P><P></P><P><SPAN style="font-size: 8pt;"><IMG alt="help.jpg" class="jive-image" src="https://community.qlik.com/legacyfs/online/57434_help.jpg" /></SPAN></P><P></P></BODY></HTML> Wed, 16 Apr 2014 12:16:47 GMT https://community.qlik.com/t5/QlikView/Prior-Year-missing-Revenues/m-p/583646#M477567 james 2014-04-16T12:16:47Z