Date Filters on an Output

This page is currently under construction, or it refers to features which are under development and not yet available for use.

This page is under construction. Its contents are only visible to developers!

This page is currently under construction, or it refers to features which are under development and not yet available for use.

This page is under construction. Its contents are only visible to developers!

This tool creates a new filter based on a range of dates from a Date variable. Page controls allow for specifying the start and end date for the range. Dates outside the range are excluded by the filter. The created filter is then automatically applied to any tables and charts that were selected on the page before running the script.

Usage

Start by selecting the table and charts you wish to apply the filter to. When you then select this feature from the Anything > Filter > Control menu, you are presented with a list of Date variables in the corresponding data file, and you should select the one that you wish to have a filter created from.

The tool will add two date controls to the current page for each selected variable, one for the start date to use for the filter (labeled "From") and the other for the end date (labeled "To"). A filter variable will be added to the data set, which automatically updates when either date control is updated with a new date. This filter variable will then be applied to the tables and charts that were selected at the beginning.

Note, you must have an output selected first on your current page to use the script. If you attempt to use this feature on a blank page, the date controls will not be created.

How to apply this QScript

Start typing the name of the QScript into the Search features and data box in the top right of the Q window.
Click on the QScript when it appears in the QScripts and Rules section of the search results.

OR

Select Automate > Browse Online Library.
Select this QScript from the list.

Customizing the QScript

This QScript is written in JavaScript and can be customized by copying and modifying the JavaScript.

Customizing QScripts in Q4.11 and more recent versions

Start typing the name of the QScript into the Search features and data box in the top right of the Q window.
Hover your mouse over the QScript when it appears in the QScripts and Rules section of the search results.
Press Edit a Copy (bottom-left corner of the preview).
Modify the JavaScript (see QScripts for more detail on this).
Either:
- Run the QScript, by pressing the blue triangle button.
- Save the QScript and run it at a later time, using Automate > Run QScript (Macro) from File.

Customizing QScripts in older versions

Copy the JavaScript shown on this page.
Create a new text file, giving it a file extension of .QScript. See here for more information about how to do this.
Modify the JavaScript (see QScripts for more detail on this).
Run the file using Automate > Run QScript (Macro) from File.

JavaScript

includeWeb("QScript Functions for Filters");
includeWeb("QScript Functions to Generate Outputs");

createControlsAndFilter("Date")