Adding a quota variable (AskiaAnalyse)

This feature allows you to create a quota question based on AskiaField quotas for inclusion in your analyses.

In this topic:

Options

OPTION DESCRIPTION

Use Cca Web API to retrieve the quota

If selected, the survey will be accessed using the Cca Web API. Contact your system administrator to check if the Cca Web API is available for you to use. 

If this option is selected, the next two fields are disabled and will be ignored. 
Connection to AskiaField database
This option only applies if Use Cca Web API to retrieve the quota is not selected.

Text string containing the following parameters to define the database connection pathway to the AskiaField installation. 

Each parameter is separated from the next with a semicolon:

  • Provider = sqloledb; - always present in this form
  • Data Source = server-address; - replace server-address with the URL or IP address of the askiafield server
  • Initial Catalog = database-name; - replace database-name with actual name of the database
  • Trusted_Connection=no; - always present in this form
  • User Id = user-id; - replace user-id with a valid UserId with access to the server
  • Password = pass; - replace pass with the password associated with the UserID

For example, for a survey located at IP address 10.0.10.1, with the servername MY.SERVER.Cca, and accessed by user U1234 with the password xyzZ1213z, the string would be written like this:

Provider=sqloledb;Data Source=10.0.10.1;Initial Catalog=MY.SERVER.Cca;Trusted_Connection=no;User Id=U1234;Password=xyzZ1213z

In many case, the database connection string database connection string can be obtained from AskiaField by accessing Supervisor > CCA settings > Tasks > Surveys >  with "Surveys" changed to "Cca" in the string
Surveys
This option only applies if Use Cca Web API to retrieve the quota is not selected.
A drop down list populated with the name of the surveys, once the database connection has been established. 
Use currently opened survey file If selected, scripts and definitions will be obtained from the currently opened survey file. If not selected, the .QES file must be specified in the next field, Askia file. 
Askia file

The name of the .QES file to use to access the quota variable and script definitions. To enter a filename, click the button ... to the right of the file name field and browse your file storage to locate the relevant .QES file. 

You only need to specify a filename if the checkbox Use currently opened survey file (above) is unchecked.
Remove zero targets If selected, any quota cells with a target of zero will be removed from the created quota variable. 
Remove targets above If selected, you may specify a maximum target value in the adjacent field. Any cells with a quota target above this value will be omitted from the created quota variable.  
Show indent

If selected, the nesting structure of the quota definition will be represented in the text labels generated, with one space added to the beginning of the text for each subordinate level. For example, for a quota defined as gender x age, all age-within-gender labels would be indented by one space. 
Show question If selected, the question name (shortcut) will be added to the generated text label. 
Separator Only applies when the adjacent box Show question (see above) is selected. Specifies an option text separator character which will be placed in front of the question (shortcut) name inserted into the generated text label. 
Add target counts to caption If selected, the target number of respondents will be added to the end of the text label generated for each quota cell in the created quota variable. If not selected, the targets will not be shown. 
Separator

Only applies when Add target counts to caption (see above) is selected. Specifies an option text separator character which will be placed in front of the quota target value inserted into the generated text label. 

Adding a quota variable to AskiaAnalyse

To add a quota variable:

  1. Un the edit menu select create a variable....
  2. In the create a variable window, select closed by scripts.
  3. Click import quota settings from AskiaField:

    The import quotas from AskiaField window appears.

Import%20quotas%20from%20askiafield

Click the above image to enlarge the view.

 

 

  1. In connection to AskiaField database, you will need to provide a suitable connection string. Please contact your system administrator if you need assistance with this.
  2. Select the appropriate survey in the surveys list.
  3. Use the other options to specify how you want the data to appear.
  4. Click OK. Your responses will be automatically generated according to your settings.

    View example

     

Including the quota variable in a cross-tab

When including your quota question in a cross-tab, you can use calculation arithmetic or cleaning scripts to read the targets from the captions. You will obtain the following result:
cleaningscript1

Cleaning script example:

Create your own Knowledge Base