LEARNING

Home / FAQ

Learning Overview

New in Quantrix 3.0

FAQ

View Tour

Free Trial

Customer Success

View Tutorial

FAQ

The FAQ page lists the most common questions that are asked by users.

Quantrix 3.0 Questions

I am a current 2.x user. How do I try out Quantrix 3.0?
You can download a 30 day free trial of Quantrix 3.0 Professional Edition. Follow these steps:

Remember that good data practice dictates backing up your 2.x model files prior to using in 3.0.
Download the application installer.
Either uninstall your current 2.x installation and install 3.0 -OR- install 3.0 in a different directory from your 2.x installation.
Contact support@quantrix.com if you need installation assistance.

I installed 3.0, but it won't start. Only the splash screen displays for a short time.
Most likely the 3.0 installation was installed in the same directory as a Quantrix 2.4 installation. To resolve, simply delete the Quantrix installation directory (typically C:\Program Files\Quantrix Modeler) and run the 3.0 installation program again.

Is Quantrix 3.0 available for OS X?
We are planning to release a Mac version of Quantrix in our 3.1 release, due out this summer. Stay tuned to the Quantrix Newsletter for further announcements.

Can 3.0 files be opened in previous versions of Quantrix?
Any files created with Quantrix 3.0 cannot be opened with any of the 2.x or 1.x versions of Quantrix. Good data practice dictates backup up your 2.x model files prior to using in 3.0.

How are 2.4 charts converted into 3.0?
2.4 charts open in a presentation canvas in 3.0 with its associated table view exposed and all chart annotations are converted to the canvas presentation. To hide the table view on the canvas, right click on the chart and choose Chart > Hide Table View.

Installation / Internet Update Questions

Is Quantrix compatible with Windows Vista?
Quantrix is compatible with Vista starting with version 2.3.

I am having trouble activating Quantrix on Windows Vista.

If Quantrix appears to activate successfully, but then asks to activate again the next time Quantrix is launched, please do the following:

1. Navigate to the Quantrix installation directory - typically c:\program files\quantrix modeler
2. Find the Quantrix Modeler.exe file and right click on it.
3. Choose Run as Administrator. This will launch Quantrix in administrator mode.
4. Try the activation again.

Quantrix will not install on Windows 2003. How can I fix this?
A feature of Windows 2003 Service Pack 1 is "Data Execution Prevention". This security feature blocks the installation self-extractor from running. To fix this problem, do the following:

1. Click Start, right click My Computer, and select Properties.

2. On the Advanced tab, click the [Settings] button under the Performance section.

3. Select the Data Execution Prevention Tab in the Performance Options dialog.

4. Select the radio button for "Turn on DEP ... except those I select:"

5. Select "Add" and select the Quantrix installer. (the entry shows up as "InstallAnywhere Self-Extractor" in the dialog)

6. Select "Apply" on the "performance options" and "OK" on the "System Properties" page

7. Now run the installer

How do I make Quantrix automatically check for updates?
With Quantrix open, there are two ways:

1. For Windows, click Tools-->Options. For OS X, click Quantrix Modeler --> Preferences. Under Miscellaneous Options, click the checkbox “Automatically Update Quantrix on Exit”

2. Click Help/Update Quantrix in the file menu. An Update Quantrix dialog box comes up. Click the check box “Automatically check for updates each time Quantrix exits”.

Import / Export / Dynamic Linking Questions

What JDBC or ODBC Database drivers can be used with Quantrix?
Quantrix is designed to connect with any standard ODBC or JDBC driver. You can find out specific ones we have tried in this forum post.

Is the Quantrix HTML Export compatible with Internet Explorer 7?
All versions after Quantrix 2.3 are compatible with IE 7.

Are there any Quantrix formulas that will not export to Excel?
The following formulas are specific to Quantrix functionality and will not export to an Excel spreadsheet.
# isempty
# between
# clearerror
# clearzero
# dayofyear
# err
# first
# join
# last
# s
# select
# selectbetween
# selectgreaterthan
# selectlessthan
# selects

I am getting a Too Few Parameters error message when connecting Quantrix to an Access database via DataLink.
When trying to connect to Access stored queries that are unions of many external tables, any strings in the query need to be quoted with single quotes instead of double quotes. Once single quotes are used, the ODBC driver will be able to find the columns names and import the data successfully.

Via DataLink, I can connect to an Excel file, but no tables or columns display.
When connection to an Excel file with DataLink, users need to 'name' their ranges of Data in Excel in order for Quantrix to detect what data to access.

In Excel, select the data you are looking to import and choose Insert > Name > Define to apply a name to the range of data.

I just upgraded to Windows Service Pack 2 and now I can't view Quantrix HTML Export files. What can I do?
The installation of Windows XP Service Pack 2 also provides an upgrade to Internet Explorer (IE) 6. With this upgrade, a default security setting in IE prevents the Quantrix HTML export from being displayed in the browser. With this setting in place, the following message appears when loading a Quantrix HTML presentation.

"To help protect your security, IE has restricted this file from showing active content that could access your computer"

Clicking ‘Allow Blocked Content’ shows the HTML presentation, but this is a step that needs to be done each time a Quantrix HTML file is loaded in the browser.

You may choose to permanently allow Internet Explorer to view Active Content on local files. This will prevent the warning from appearing again. You can set this by doing the following:

1. Choose ‘Internet Options’ from the ‘Tools’ menu in Internet Explorer:

2. Navigate to the ‘Advanced tab’ in the ‘Internet Options’ dialog and then scroll down to the ‘Security’ section.

3. Enable the checkbox labeled "Allow active content to run in files on My Computer"

Please be assured that Quantrix HTML files utilize JavaScript technology that is safe to run on your computer.

Are there file size limitations when exporting Quantrix to HTML?
The HTML export is limited by the browsers ability to process large sets of complex data. Our internal testing and user experience has generally shown that exported matrices over 75,000 cells in size, and model files over 500,000 cells in total size cannot be displayed in either Internet Explorer or Mozilla.

Can I copy and paste data between Quantrix and other applications?
Yes! Using standard copy and paste functionality, you can copy cells and their values to the system clipboard and paste to the other application.

How do I open my Lotus Improv files (.imp) in Quantrix?
Quantrix has the ability to import Lotus Text Files (.imx) files into Quantrix. To create an .imx file in Improv, open your model, choose 'File --> Save As' and save as a file type .imx.

In Quantrix, choose 'File --> Import', and choose file type of .imx. Locate your file and click 'Import'.

You are not directly opening a native improv file. Quantrix imports a text version of the .imp file. It is likely some minor clean up will need to be done to get your Quantrix file into shape.

Formula Questions

What is the syntax for Inter-Model Formulas?
Inter-model formulas are formulas that call data residing in other Quantrix Models. In a simple example; Model1 contains Matrix1 that has a value of 1 for A1. In Model2, you want to write a formula that brings over the A1 value from Model1. The formula would be:

a1 = !model1.model!Matrix1::A1

The name of the model you want to call is surrounded by exclamation points in the formula.

Functions Questions

How do I use the SUMMARY statistical functions in the toolbar?
In the matrix:
1. Click on the category tile or group you want to apply a summary function to.
2. Either click the SUM button on the toolbar, or click the arrow in the toolbar to choose from the list of functions. (SUM, COUNT, COUNTA, AVE, MAX, MIN, PRODUCT)

Your statistical function will show up as an item in a new row or column and will be added as a formula in the formula pane.

Cells / Items / Groups / Categories

I want to switch the order of my items and/or groups in my Matrix. How do I do this?
Click on the item/group you want to move, hold the CTRL key down while pressing one of the arrow keys:
# Move item up: CTRL - Up Arrow

# Move item down: CTRL - Down Arrow

# Move item left: CTRL – Left Arrow

# Move item right: CTRL – Right Arrow

I want to enter values into cells without a formula. Can I do this? Is there a way I can tell what cells are allowed input?
Yes, you can change cells that are not controlled by formulas by typing the value into the cell. There is an easy way to differentiate between formula cells and input cells. In the View menu, click “Show Input Cells”. The cells that allow input will have a green tag in the upper right hand corner of the cell.

How do I link a category between two or more matrices?
Simply drag the category tile you want linked to the other matrices. The category and items will be shared between the matrices, but the data will not be shared.

You can also copy the desired category and paste to a new matrix choosing 'paste' from the menu.

Quantrix.com Web Site Support

I forgot my password to My Quantrix. How do I retrieve it?
Click here to go to a screen where you will be prompted to enter your email address. The email you receive will contain your password to access My Quantrix.

Where do I sign up for a My Quantrix account?
Click here to register for a My Quantrix Account. Here you can also sign up for the Quantrix email newsletter and stay informed of the latest Quantrix developments.

Quantrix Technical Questions

Can I integrate Quantrix with my existing business systems?
Quantrix Professional Edition includes an Application Programming Interface (API). Additionally, Quantrix's native file format is XML. Data that is available in XML form can be formatted using industry standard XML tools to be easily opened, viewed and manipulated in Quantrix.

How can I increase the memory allocation for Quantrix?
You can increase the amount of your computer's memory dedicated to Quantrix processing by doing the following:
# Open Tools > Options > General from the menu. (OS X users choose Quantrix Modeler > Preferences > General).

# Change the value in the Maximum Memory box to a number just below your computer's installed memory. So if you have 1Gig of memory, a setting of 950 is appropriate. A contiguous block of memory is required for this setting. If the number is too high, Quantrix will prompt you to lower the value. Please Note: The maximum memory value depends on the software installed on your system. If Quantrix fails to run after making this change, please contact support@quantrix.com.

# At your discretion, you can reduce the size of the undo stack to conserve system resources.

# If you have large matrices that are very sparse (lots of blank cells), choose Tools > Calculation > Calculation Settings and place a check in the box to 'Treat empty cells as missing values'. This will reduce the amount of memory formulas consume when calculating across sparse matrices.

What are the Quantrix System Requirements?
Please click here to view the System Requirements for Quantrix Modeler Standard and Professional Editions.

Can I share my Quantrix Mac models with my colleagues who are working with the Windows version?
Yes. The two versions are compatible.

Is Quantrix a server- based application?
Quantrix Modeler is currently available as a desktop application. In this way, users have immediate access and ultimate control over the application, processing bandwidth as well as data retrieval and storage.

What language is Quantrix written in?
Quantrix is written in Java. A compatible version of the Java Virtual Machine (JVM) will be part of the Quantrix Windows installation. The JVM that is installed is a local copy that will not overwrite the system installed JVM.

For OS X installation, you need to have the Java Virtual Machine that is provided by Apple Computer installed on your Mac. For Quantrix, we recommend having Java 1.4.2 installed.

Quantrix CD-ROM Flash Tour and Tutorial Support

I am having trouble viewing the CD-ROM Flash Demo. What are my options?
Due to the system demands of the audio-visual nature of the tour, the Quantrix CD-ROM Flash tour and tutorial require a CD-ROM drive with a read rate of 48X. If you don't have a CD-ROM that meets these requirements you can:

# View the presentation online at Quantrix.com.

# Copy the contents of the CD-ROM to your hard drive, and then double click on the START_HERE.EXE file to use your hard drive instead of the CD-ROM to play the tour and/or tutorial.

About Quantrix - Contact - Site Map - Refer A Friend - Support

Solutions - Products - Services - Community - Partners - Webinars - Learning - Store

FAQ

Quantrix 3.0 Questions

Installation/Update Questions

Import / Export / Dynamic Linking Questions

Formula Questions

Functions Questions

Cells / Items / Groups / Categories Questions

Quantrix.com Web Site Support

Quantrix Technical Questions

Quantrix CD-ROM Flash Tour and Tutorial Support

Quantrix 3.0 Questions

Installation / Internet Update Questions

Import / Export / Dynamic Linking Questions

Formula Questions

Functions Questions

Cells / Items / Groups / Categories

Quantrix.com Web Site Support

Quantrix Technical Questions

Quantrix CD-ROM Flash Tour and Tutorial Support