Hi Experts need your help,

[#1]

I got a requirement to create a view for budgeted revenue and actual revenue, in that i have to forecast the remaining budget to achieve

and it should be divided across months so the user come to know i have achieve this actual revenue in the coming months .

I dont know it is possible in qlikview or not , i know about forecast option.

[Anonymous]

Can you share sample data as well as required required format ... in excel.

Thanks

BKC

[Anonymous]

You can have three bars (budgeted revenue,actual revenue and budget to achieve) for each month.

So you need to have Month in Dimension then three expression for (budgeted revenue,actual revenue and budget to achieve)

Thanks

BKC

[#4]

yes precisely .. will attach sample data too. i have attached both tables

[sunny_talwar]

Did you get a chance to look at the following link?? It provides a lot of potential on the topic of forecasting

Forecasting in Qlikview

HTH

Best,

S