Till innehåll på sidan

Nyckelord för varje variabel

There is always at leas one variable in a PC-Axis file. Variables can be either in STUB or HEADING. For each variable the following information can be available:
VALUES
Mandatory for each variable. Which values exists for the variable.
VALUES("region")="Stockholm", "Vallentuna";

CODES

Which codes the existing values have.
VALUES("region")="0180", "0114";

DOMAIN

Which domain the variable belongs too. Needed only if aggregations files are used.
DOMAIN("region")="region2000";

ELIMINATION

If a variable can be eliminated.
ELIMINATION("age")="total";
ELIMINATION("sex")=YES;

DOUBLECOLUMN

If values and codes should be shown in different columns.
DOUBLECOLUMN("region")=YES;

MAP

If the table can be shown on a map.
MAP("region")="Sweden";

NOTE and NOTEX

If there are footnotes for a variable.
NOTE("region")="Text for footnote for the variable region";
NOTEX("age")="Text for mandatory footnote for the variable age";

PRESTEXT

If values or codes should be shown for a variable.
PRESTEXT("region")=1;
PRESTEXT("time")=0;

VARIABLE-TYPE

A type of variable. Options for new applications. Not used in PC-Axis or PX-Web.
VARIABLETYPE("time")=T;

HIERARCHIES

One variable in a table can be hierarchical.
HIERARCHIES("region")="SE","SE":"0180",...

HIERARCHYLEVELS

A hierarchical variable can have a number of levels.
HIERARCHYLEVELS("region")=2;

HIERARCHYLEVELSOPEN

A hierarchical variable can have a number of levels open when first shown.
HIERARCHYLEVELSOPEN("region")=0;

HIERARCHYNAMES

A hierarchical variable can have a names for the levels.
HIERARCHYNAMES("region")="The whole country","Municipalities";

KEYS. For STUB variables

If sparse data, KEYS for each variable in stub.
KEYS("region")=CODES;

PARTITIONED. For one variable

Only one PARTITIONED variable for a table.
PARTITIONED("region")="Municipality",1,4;
PARTITIONED("region")="Subarea",5;

TIMEVAL. Special for time variable.

If the table has a regular time scale information can be given in time. This makes it possible to do some extra editing and converting.
TIMEVAL("time")=TLIST(A1),"2008";
TIMEVAL("time")=TLIST(Q1),"20012","20013","20014";

PRECISION. For specific values

If there are different numbers of decimals.
PRECISION("$$SORT","Per cent")=2;

VALUENOTE and VALUENOTEX. For specific values

There can be a footnote for a specific value for a variable.
VALUENOTE("region","Stockholm")="Text for footnote regarding Stockholm";
VALUENOTEX("region","Stockholm")="Text for mandatory footnote regarding Stockholm";

CELLNOTE and CELLNOTEX. For combinations of values

There can be a footnote for a data cell or a number of datacells.
CELLNOTE("Stockholm","*","2008")="Text for cell note regarding Stockholm, all ages, 2008";
CELLNOTE("Stockholm","20","2008")="Text for mandatory cell note regarding Stockholm, 20 year old, 2008";

DATA

NOTECELL. For combinations of values

There can be a note to show together with a figure in a data cell.
DATANOTECELL("0180", "*", "2008")="Ae";
DATANOTECELL("0180", "20", "2008")="Ae";