- String casing can be handled by Qlik Sense and QlikView. 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 Qlik Sense and QlikView. For instance, the following statement will replace all null values with '<NULL>'.
Set NullDisplay = '<NULL>'; - Qlik Sense and QlikView 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 has been used for years 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 Qlik Sense and QlikView. For instance, an original table or field named @1 will be renamed as @@1 inside Qlik Sense and QlikView.
