Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

ce_gutierrez
New Contributor III

Forecast Tracking

Dear Friends How are you,

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.

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.

Can anybody help me?

Best Regards

forecast.PNG

1 Reply
MVP & Luminary
MVP & Luminary

Re: Forecast Tracking

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 =if( [Sales Period] = [Forecast Period], '<b>')


talk is cheap, supply exceeds demand