Keywords with codes or numbers

CFPRICES

Indicates if data is in current or fixed prices.
C is used for Current and F for Fixed prices.
Quotation marks must be used. CFPRICES="C"
If the table has a contents variable the keyword is written as CFPRICES("value")="C".

DECIMALS

The number of decimals in the table cells. 0 - 15. (0-6 if SHOWDECIMALS is not included). Indicates how many decimals will be saved in the PC-Axis file. Written without quotation marks. Compare SHOWDECIMALS.

DEFAULT-GRAPH

This keyword is read and saved in the PX-file but not shown in PC-axis. Can be used in an interface to select as specific graph

HIERARCHYLEVELSOPEN

Indicate how the tree is to be displayed when the tree is shown for the first time
Example: HIERARCHYLEVELSOPEN("Country")=1 the first level is open.

HIERARCHYLEVELS

Indicate the number of levels existing for a symmetrical tree.
Example: HIERARCHYLEVELS("Country")=4

KEYS

If this keyword is used it must occur as many times as there are variables in the stub. It contains the name of the variable and whether the key is taken from VALUES or CODES. Example:
KEYS("age")=VALUES;
KEYS("region")=CODES;.
When it is used all data rows start with the Value/code of the variables in the stub. See Description of Data.

LANGUAGE

The language used in the PC-Axis file (2 chars), sv for Swedish, en for English etc. Compare language codes for text files. If the keyword is used, the words for “and” and “by” are read from the text file of that language. Otherwise these words are read from the text file of the language in which the program is running.

LANGUAGES

If more than one language in the PC-Axis file then all languages are mentioned here (2 chars each), Example: LANGUAGES="en","sv";

PRECISION

Can occur for single values. Determines that the value shall be presented with a number of decimals that differs from the keyword SHOWDECIMALS. Is to be written as PRECISION("variable name","value name")=n where n is a figure between 1 and 6.
The number of decimals for precision must be higher than the number of decimals for SHOWDECIMALS to have any effect.

PRESTEXT

States if texts or codes are shown for the keyword VALUES.
Normally a file is created so that texts are found after the keyword VALUES and codes after the keyword CODES. This is equivalent to PRESTEXT("variable name")=1; which is the default.
If a user changes presentation from texts to codes and saves the file the value codes will be saved after the keyword VALUES and value texts after the keyword CODES. In this case the keyword PRESTEXT is written as PRESTEXT("variable name")=0. This enables PC-Axis to know if it is necessary to switch to codes if aggregation is selected.
The user can also decide to show both codes and texts for a value and in this case the keyword is saved as PRESTEXT("variable name")=2 or PRESTEXT("variable name")=3. PRESTEXT becomes 2 if it originally was 1 and 3 if it originally was 0.

ROUNDING

If rounding is missing then rounding will be done in accordance with information in the pcax2000.ini file. If the keyword is missing then the decimalrule in pcax2000.ini is used. Rounding = 0 means that .5 is rounded up if the previous figure is odd, 1.5 becomes 2. Rounding = 1 means that .5 is always rounded up. 0.5 becomes 1 and 1.5 becomes 2.

SHOWDECIMALS

The number of decimals to be shown in the table, 0-6. Must be the same or smaller than the number stored as indicated by the keyword DECIMALS. If SHOWDECIMALS is not stated in the file the number stated by DECIMALS will be used.

STOCKFA

Indicates if data is stock, flow or average. The used characters S (stock), F (flow) and A (average) must be within quotation marks. STOCKFA="S"
If the table has a contents variable the keyword is written as STOCKFA("value")="S".

 

Designelement

|Statistics Sweden | PC-Axis at Statistics Sweden, Box 24 300, S-104 51 Stockholm, Sweden   | Contact us