topic Re: Hi Experts need your help, in QlikView

Hi Experts need your help,

Thu, 19 Mar 2015 11:55:57 GMT

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 — Thu, 19 Mar 2015 12:01:23 GMT

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

Thanks

BKC

Anonymous — Thu, 19 Mar 2015 12:04:59 GMT

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

Thu, 19 Mar 2015 12:08:39 GMT

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

sunny_talwar — Thu, 19 Mar 2015 12:08:55 GMT

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

HTH

Best,