# Defining variables in analyses

Available in...

* Big Data Platform
* Cloud API Services Platform
* Cloud Big Data Platform
* Cloud Data Fabric
* Cloud Data Management Platform
* Data Fabric
* Data Management Platform
* Data Services Platform
* MDM Platform
* Real-Time Big Data Platform

## Before you begin

You have created a database analysis in the Profiling perspective.

## Procedure

1. Click the [+] button to add lines in the table.

   Suppose that you want to profile a postal\_code column and you want to analyze the postal codes that start with 15 in the development environment and with 75 in the production environment. You also want to allow different concurrent connections per analysis in the two environments.
2. Click in the Name field and enter the name of the variable you are creating.

   In this example, the first variable is where\_clause.
3. Repeat the above steps to define all the variables for the different contexts.

   In this example, set the value of the where\_clause variable in the Test context to postal\_code like '15%', and for the Prod context to postal\_code like '75%'. Set the value for the concurrent connections per analysis in the development and production environments to three and five respectively. ![Configuration in the Context view following the procedure.](https://help.qlik.com/talend/en-US/studio-user-guide/Resources/images/context_in_analyses6.png)
4. Click ![Manage variables icon](https://help.qlik.com/talend/en-US/studio-user-guide/Resources/images/ContextButton.png) at the bottom of the view to import any of the contexts created and centralized in the Talend Studio repository and use it with the current analysis.