If JavaScript is disabled, please continue to the
sitemap
.
Infor Birst BQL Reference Guide
Home
Back
Back
Forward
Forward
Search
Copy URL
PDF
Print this page
Topic URL copied to clipboard
Show the Table of Contents
Hide the Table of Contents
Introduction to BQL
BQL Basics
BQL Quick Reference
Advanced BQL
Result Sets and Display Operations
IIF - Conditional Logic
Positional Calculations
EVAL (Macros)
Dimensional Expressions
Number, Date, and Time Pattern String Formats
Custom Measures versus Custom Report Expressions
Advanced BQL Functions
DATEDIFF Function
FIND Function
FORMAT Function
FUNCTION and FUNCTIONLOOKUP Functions
GETPROMPTFILTER and GETPROMPTVALUE
LET Function
LOOKUPROW Function
LOOKUPVALUE Function
Math Functions and Operators
Median of a Measure by Breaking Attribute: MEDIAN
NOW and NOWDATE Functions
RSUM (Running Sum) Function
SPARSE Function (Show Attributes That Have No Measures)
STAT Function
TRANSFORM Function
TREND Function
Open link in new tab
Open link in new window
Copy link to clipboard
Do you find this site useful?
Do you find this site useful?
The information was easy to find.
This page was clear and organized.
This page was easy to understand.
This page provided valuable insight.
My question was answered.
This page loads quickly.
Submit
I cannot find the information I need.
I found some information, but I need more details.
This page is difficult to understand.
This page contains link errors.
This page is outdated.
This page is difficult to use on my mobile device.
This page is slow to load.
Submit