Skip to main content

How can we help?

Frequently searched: Android devices, cloning, ADC Gallery, Glossary,...

Tab definition

Create tables, from simple to advanced!

In this article

    Keywords when reporting

    When defining your tables in AskiaVista or Analyse, you can use special keywords in your table definitions in order to dynamically display up-to-date information in a table caption.

    When your table is generated, the keyword is replaced with the corresponding information.

    For example, imagine your Table result base is 20,000 interviews and you want inform the table reader that your result is also weighted, you can use the following keywords :

    Summary Table 
    Base: ??B??
    Filter : ??SP??
    Weights: ??W??

    In the generated table, the caption would appear as  follows

    mceclip0.png

     

    The following keywords are available:

     

    Top used keywords

    • ??R??: Returns the row question title.

    • ??C??: Returns the title of the question in column.

    • ??B??: Returns the base for the question as the number of interviews.

    • ??W??: Returns the weighting name.

    • ??U??: Returns the name of the universe.

    • ??L??: Returns the analysis level.

    • ??SP??: Returns the name of the filter (a filter is also known as a sub-population). Designate a sub-population that you can apply to your tables or to your variables in creation mode.

    • DK: Don't Know.

     

    Miscellaneous

    • ??UB??: Returns the unweighted base.

    • ??Waves??: In a Surf (.qew) file, this returns the selected wave captions (comma separated) of selected waves. If all waves are selected then 'All waves' will be shown.

    Row

    • ??R??: Returns the row question title.

    • ??R??: Returns the row question title.

    • ??RLC??: Returns the long caption title of the question in the row.

    • ?RSC??: Returns the short caption of the row variable, when you are specifying general table options. It allows you to display the short caption and the long caption on the same tab. RSC can be used directly in the header/footer fields and also in the title field in the general tab of table definition.

    • ??RS??: Returns the shortcut of the question in the row.

    • ??RT??: Returns the type of the question in the row. It returns Numeric, Single or Multiple.

    • ??RPN??: Returns the name of profile found in the row.

    Column

    • ??C??: Returns the title of the question in column.
    • ??CS??: Returns the shortcut of the question in the column.

    • ??CPN??: Returns the name of profile found in the column.

       

    Edge

    • ??ES??: Returns the shortcut of the question in the edge.

    • ??E??: Returns the title of the question in edge.

    • ??ER??: Returns the category wording in edge response.

    • ??EPN??: Returns the name of profile found in the edge.

     

    Filter

    • ??SP??: Returns the name of the filter (a filter is also known as a sub-population). Designate a sub-population that you can apply to your tables or to your variables in creation mode.

    • ??SPD??: Returns the description of the filter (a filter is also known as a sub-population).

    • ??GSP?? (Global sub-pop) - returns the name of the sub-pop applied at the portfolio level e.g. Global SP (portfolio level sub-pop).

    • ??GSPD?? (Global sub-pop description) - returns the description of the sub-pop applied at the portfolio level.

     

    Caption

    • %c: Displays the answer category wording.

    • %C: Returns the answer category wording in upper case .

    • %V: Returns the value associated with the answer category.

    • $$Shortcut$$: Returns the scaled value of the question.

     

    Footer/Header

    • ??Cont??: Returns the reference "Cont'd" (continued) when the table is split according to the page size .

    • ??ColSig??: Returns the list of columns being compared in any significance test being applied.

    • ??Page??: Returns the number of the page within a section.

    • ??Pages??: Returns the total number of pages.

    • ??SectionPage??: Returns the number of pages of the Table Definition section).

    • ??FilePath??: Questionnaire file access path (.qes).

    • ??FileName??: Questionnaire name with extension "qes".

    • ??FileTitle??: Questionnaire name without extension "qes".

    • ??Table??: Returns the number of tables (when the break the table according to... feature has been activated).

    • ??Version??: Returns the version of Analyse used and the whether it’s the 32 or 64 bit application being used e.g. 5.4.6.0 [32 bit]

     Date

    • ??Date??: Current date (execution date based on that of your server

    • ??DateLoadSurvey??: Returns the date of the latest survey load.

    • ??DateLoadData??: Returns the date of the latest data load

    • ??Hour??: Current hour (execution time based on that of your server). 

    Related articles