QuickView Code Samples

Here is an example of a Report page that uses a Dimension Quickview.

  report-page { 
    title "Report Page 1" 
    cplan "/cplans/basic_101.cplan" 
    
    quickview-set { 
      cplan "/cplans/basic_101.cplan" 
      dimension-quickview "Beverage Type" label = "Bev Type" 
    } 
    dimension "Corporate Supplier" 
    dimension "Corporate Product Group" 
    text column = "Cases" 
    text column = "Cost" 
  } 

Here is the result of the code in DiveTab.

Here is an example of a Report page that uses a List QuickView.

  report-page { 
    title "Report Page 2" 
    cplan "/cplans/basic_101.cplan" 
    
    quickview-set { 
      cplan "/cplans/basic_101.cplan" 
      list-quickview "Corporate Supplier" label = "Supplier" { 
        values "DIAGEO" "CONSTELLATION" 
      } 
    } 
    dimension "Corporate Supplier" 
    dimension "Corporate Product Group" 
    
    text column = "Cases" 
    text column = "Cost" 
  }

Here is the result of the code in DiveTab.

Here is an example of a Report page that uses a Parameterized List QuickView.

  report-page { 
    title "Report Page 3" 
    cplan "/cplans/quickview.cplan" 
    
    quickview-set { 
      cplan "/cplans/quickview.cplan" 
      list-quickview "Metric" label = "Unit" single-selection = true all-values = false { 
        default-values "Cases" 
        values "Cases" "Cost" "9 Liter Cases" "BATF Cases" "Discount" "Net Sales" 
      } 
    } 
    dimension "Premise" 
    dimension "Resp Team" 
    
    text column = "Metric Value" 
  } 

Here is the code used by the cPlan.

cplan { 
  cbase-input "/cbases/NY.cbase" 
  take-parameter "Metric" { 
    default "Cost" 
  } 
  calc "Metric Value" `calc(param("Metric"))` label = "$(Metric)" 
} 

Here is the result of the code in DiveTab.

Though the default value is set to Cases, other values can be chosen using the Set QuickView dialog.

Here is a view of the Set QuickView dialog, with new value Cost selected.

Here is the result of the change in DiveTab.

Here is an example of a Report page that uses a Anchor Date QuickView.

  report-page { 
    title "Report Page - Anchor Date QuickView" 
    cplan "/cplans/quickview_time-series.cplan" 
    
    quickview-set { 
      cplan "/cplans/quickview_time-series.cplan" 
      dimension-quickview "Current Year" label = "Year" single-selection = true all-values = false { 
        dimension "Year" 
        default-values "2012" 
        default-last-value 
      } 
    } 
    
    dimension "Product Name" 
    text column = "Cases YTD" { 
      value-format "#,###.00" 
    } 
  }

Here is the code used by the cPlan.

cplan { 
  cbase-input "/cbases/NY.cbase" { 
    add "Year" `year(value("Posting Period"))` format = "#" 
  } 
  take-parameter "Current Year" { 
    default "2017" 
  } 
  
  time-series { 
    date `value("Posting Period")` 
    anchor ```if(param("Current Year") = "2017", date("2017/12/31"), 
              if(param("Current Year") = "2013", date("2013/12/31"), 
              if(param("Current Year") = "2012", date("2012/12/31"), 
                                                 date("2011/12/31"))))``` 
    
    summary "Cost" 
    summary "Cases" 
        
    ranges { 
      year-to-date 
      month-to-date 
      current-year 
      all-quarters 
      rolling-months 3 
      rolling-months 6 
      recent-weeks 24 
      recent-months 12 label-format = "MMM" 
      all-months label-format = "MMM" 
    } 
  } 
} 

Here is the result of the code in DiveTab.