Worksheets

Learn about IQ Interface worksheets.

Create worksheets from the existing database.

Create a worksheet by importing a data file.

Create an aggregate worksheet to group data from another worksheet by unique values and perform calculations on those data groups.

Create individual Tableau analytics worksheets, configure static and dynamic parameters to pass to Tableau.

Link Tableau analytics to an existing IQ Interface worksheet.

Refresh worksheets and add the Refresh Automatically toggle to a worksheet.

Sort columns in ascending or descending order, define a default view for a worksheet, and reset your personalized worksheet view to the default one.

Import data into a worksheet from a CSV file, and export worksheet data to a CSV file.

Define master-detail worksheet relationships to enable the display of data from one worksheet as expandable detail records in another worksheet.

Delete a worksheet in a workbook.

Highlight worksheet rows to bring attention to important data in your worksheets, or to values that need review. You can configure a worksheet row to be highlighted automatically with a color if a field's value in that raw matches predefined crite...