topic Forecast Tracking in QlikView https://community.qlik.com/t5/QlikView/Forecast-Tracking/m-p/1010597#M342938 <HTML><HEAD></HEAD><BODY><P>Dear Friends How are you,</P><P>I have to build a table data that compares Real Sales vs Forecast. This table has a particularity as you can see in the image below.</P><P>The first column is the Sales Period and the First Field is the Forecast Period. When The Sales Period and The forecast Period are the same the value that i have to set is the Sum(RealSales) (Numbers in bold format), the other values are the Forecast. </P><P></P><P>Can anybody help me?</P><P></P><P>Best Regards</P><P></P><P><IMG alt="forecast.PNG" class="jive-image image-1" height="124" src="https://community.qlik.com/legacyfs/online/101199_forecast.PNG" style="height: 124px; width: 937.561px;" width="938" /></P></BODY></HTML> Wed, 07 Oct 2015 00:58:28 GMT Anonymous 2015-10-07T00:58:28Z Forecast Tracking https://community.qlik.com/t5/QlikView/Forecast-Tracking/m-p/1010597#M342938 <HTML><HEAD></HEAD><BODY><P>Dear Friends How are you,</P><P>I have to build a table data that compares Real Sales vs Forecast. This table has a particularity as you can see in the image below.</P><P>The first column is the Sales Period and the First Field is the Forecast Period. When The Sales Period and The forecast Period are the same the value that i have to set is the Sum(RealSales) (Numbers in bold format), the other values are the Forecast. </P><P></P><P>Can anybody help me?</P><P></P><P>Best Regards</P><P></P><P><IMG alt="forecast.PNG" class="jive-image image-1" height="124" src="https://community.qlik.com/legacyfs/online/101199_forecast.PNG" style="height: 124px; width: 937.561px;" width="938" /></P></BODY></HTML> Wed, 07 Oct 2015 00:58:28 GMT https://community.qlik.com/t5/QlikView/Forecast-Tracking/m-p/1010597#M342938 Anonymous 2015-10-07T00:58:28Z Re: Forecast Tracking https://community.qlik.com/t5/QlikView/Forecast-Tracking/m-p/1010598#M342939 <HTML><HEAD></HEAD><BODY><P>Should be doable with an expression with an if statement: =if( [Sales Period] = [Forecast Period], sum(RealSales), sum(Forecast)). Then click on the + in front of the expression, select Text format and enter an expression in the Definition field like <SPAN style="font-size: 13.3333px;"> =if( [Sales Period] = [Forecast Period], '&lt;b&gt;') </SPAN></P></BODY></HTML> Fri, 09 Oct 2015 17:30:18 GMT https://community.qlik.com/t5/QlikView/Forecast-Tracking/m-p/1010598#M342939 Gysbert_Wassenaar 2015-10-09T17:30:18Z