Actual-V-Budget

gidon500 — Mon, 07 Mar 2016 14:53:13 GMT

Hi - I have challenged task ( for me)

I have a request from my customer to create a qlik document

Actual sales V Budget .

Budget is made by , month , category , agent

every agent gets a budget by month and category .

the document should be daily .

working days are Sunday to Friday- it means that we have to divide the month budget to working days ,

and set a budget to each working day .

( all days are working exclude day no 7 - Saturday .)

enclosed is a sample excel file with 3 sheets

first is sales data .

second is budget by agent , month , category ,

third is a list of all days from Jan 1 to march 31 2016 .

I need to show a gaudy object that shows the status of Actual sales V budget , until today .

the selection will be , agent , category , period , year to date , month to date .

thanks for the help

gidon

Re: Actual-V-Budget

vikasmahajan — Tue, 08 Mar 2016 07:27:56 GMT

PFA Qvw

Vikas

gidon500 — Tue, 08 Mar 2016 17:20:47 GMT

Thanks

vikasmahajan — Wed, 09 Mar 2016 04:32:26 GMT

Thanks, I am happy to help