Skip to main content

Table names

Qlik Sense tables are named when they are stored in the Qlik Sense database. The table names can be used, for example for,LOAD statements with a resident clause or with expressions containing the peek function, and can be seen in the $Table system field in the layout.

Tables are named in accordance with the following rules:

  1. If a label immediately precedes a LOAD or SELECT statement the label is used as table name. The label must be followed by a colon.

    Example:  

    Table1:

    LOAD a,b from c.csv;

    See: Table labels

  2. If no label is given, the file name or table name immediately following the keyword FROM in the LOAD or SELECT statement is used. A maximum of 32 characters is used. The extension is skipped if the file name is used.
  3. Tables loaded inline are named INLINExx, where xx is a number. The first inline table will be given the name INLINE01.
  4. Automatically generated tables are named AUTOGENERATExx, where xx is a number. The first autogenerated table is given the name AUTOGENERATE01.
  5. If a table name generated according to the rules above should be in conflict with a previous table name, the name is extended with -x , where x is a number. The number is increased until no conflict remains. For example, three tables could be named Budget, Budget-1 and Budget-2.

There are three separate domains for table names: section access, section application and mapping tables. Table names generated in section access and section application are treated separately. If a table name referenced is not found within the section, Qlik Sense searches the other section as well. Mapping tables are treated separately and have no connection whatsoever to the other two domains of table names.

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!