• Guide
• Downloads
• Purchase

Welcome to QTools.

QTools is a powerful associative big test data generator suite for Mac, Linux and Windows. The test data generator produces realistic test | mock-up data and includes more than 90 field types that can be used and contains the following special features:

• Test data export in different formats: XLSX, XLS, CSV SQL (MySQL syntax).
• Generate realistic and associative test data in no time: ca. 10 million records, 10 associative tables within 1 minute!
• The test data files generated are already linked within the structured QlikView / Qlik Sense script created.
• You can use variables (field names) from other fields to generate a field value; e.g. Field substitution, e.g. <value> = Hello {fieldNameFirstName} {fieldNameLastName} → Hello Kenny Loggins.
• You can add your own custom types to create test data. They then can be used within the Excel definition file.
• Custom types can also be structured: This means that a generated test record preserves the relation between different generated field values for a defined structure within a record; e.g. Field A → Carnivora, Field B → Felidae, Field C → Cheetah.
• Simple math expressions such as "+-*/()", e.g. <formula> = {fieldA} * 10 - {fieldB} / 0.5 .
• Not-type: By using a "!" sign in front of a type, the generated test value will be assuredly different from the value used in another field with the same type.
• %-Blank-type: By using "%%-" in front of a type, the generated values are left blank for a certain amount of percentage %%.
• You can define the amount of records per table. The test generator is able to create foreign keys between the tables, so an associative out-of-the-box QlikView / Qlik Sense model can be loaded within the QlikView / Qlik Sense editor with the exported script.
• You can generate up to 1 million records per table (SQL and CSV format only if one table exceeds 20000 records) in the licensed pro-version.

Note: The generated QlikView / Qlik Sense script follows the syntax for QlikView version 11.20 and has not been adjusted since then. Contact us if you need QlikView / Qlik Sense syntax updates. Also, download and check the example projects below to inspect the script syntax; it still should work fine!

The QlikView / Qlik Sense script generator creates a structured QlikView / Qlik Sense script based on an Excel definition file and it includes most common features (free) such as:

• Rename routine that maps database field names to GUI field names; renaming is done within an Excel file.
• Geo-data with latitude and longitude for countries as well as flag images for these countries; flags images are also provided by the tool.
• QlikView / Qlik Sense Toolbar: The QlikView / Qlik Sense toolbar and even the right-click context menu can be configured through an Excel.
• Translation defined in external Excel sheet.
• Variables defined in external Excel sheet.
• Pre- and Post-Script inclusion mechanism.

Have a look at the documentation to find out more about QTools.

Project Settings

Output including Test Data

Example Projects

QTools project that shows usage of all test data field types used.

QTools example project that shows associative test data generated for a CRM QlikView / Qlik Sense model.