Skip to main content

Parameters handled by QlikView and Qlik Sense

  • String casing can be handled by QlikView and Qlik Sense. For instance, the following statements will convert data to upper or lower case respectively:

    Force Case Upper;
    Force Case Lower;

  • Null symbol representation can be handled by QlikView and Qlik Sense. For instance, the following statement will replace all null values with '<NULL>'.Set NullDisplay = '<NULL>';
  • QlikView and Qlik Sense will rename fields received from the Connector if they begin with '@'. There will only be one additional @ even if the name starts with more of them. This convention is used with other data sources inside QlikView. It is an easy way to iterate Tables and Fields, making virtual names like: @1 - @n. This is handled entirely inside QlikView and Qlik Sense. For instance, an original table or field named @1 will be renamed as @@1 inside QlikView and Qlik Sense.