3 Replies Latest reply: Mar 8, 2016 11:32 PM by vikas mahajan RSS

    Actual-V-Budget

    gidon david

      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