6 Replies Latest reply: Aug 30, 2012 4:53 PM by Rebecca Molstad RSS

    Budget Vs Actual

      I'm still figuring out things in qlik. so need help.

       

      I get data from oracle db and the table contains the following

       

      SELECT seq_no,
      account,
      replace(substr(description,6,length(description)),':') description,
      TYPE,
      PRINT,
      full_year_budget,
      mtd_budget,
      mtd_actual,
      mtd_variance,
      ytd_budget,
      ytd_actual,
      ytd_variance,
      ltyd_actual,
      period_name,
      '20' || substr(period_name,5,2) period_year,
      substr(period_name,1,3) period_month,
      last_day('01-' || substr(period_name,1,3) || '-'|| '20' || substr(period_name,5,2)) as_of_ddmmyyyy
      FROM <table Name>

      where print = 'Y'
      and type = 'T'
      and type <> 'H';

       

       

       

       

      uploading a sample data file, 

       

      If the user selects ONLY month then I want to show the description, (mtd)budget, actual and variance for all years where month = selected month,

      if the user selects ONLY year then I want to show description, (mtd)budget, actual and variance for all years in the table

      if the user selects A month and Year then I want to show details for that Month and Year