Skip to main content Skip to complementary content

Functions and statements not recommended in Qlik Sense

Most functions and statements that can be used in QlikView load scripts and chart expressions are also supported in Qlik Sense, but some of them are not recommended for use in Qlik Sense. There are also functions and statements available in previous versions of Qlik Sense that have been deprecated.

For compatibility reasons they will still work as intended, but it is advisable to update the code according to the recommendations in this section, as they may be removed in coming versions.

Script statements not recommended in Qlik Sense

This table contains script statements that are not recommended for use in Qlik Sense.

Script statements that are not recommended
Statement Recommendation
Command Use SQL instead.
CustomConnect Use Custom Connect instead.

Script statement parameters not recommended in Qlik Sense

This table describes script statement parameters that are not recommended for use in Qlik Sense.

Script statement parameters that are not recommended
Statement Parameters
LOAD

The following parameter keywords are generated by QlikView file transformation wizards. Functionality is retained when data is reloaded, but Qlik Sense does not provide guided support/wizards for generating the statement with these parameters:

  • Bottom
  • Cellvalue
  • Col
  • Colmatch
  • Colsplit
  • Colxtr
  • Compound
  • Contain
  • Equal
  • Every
  • Expand
  • Filters
  • Intarray
  • Interpret
  • Length
  • Longer
  • Numerical
  • Pos
  • Remove
  • Rotate
  • Row
  • Rowcnd
  • Shorter
  • Start
  • Strcnd
  • Top
  • Transpose
  • Unwrap
  • XML: XMLSAX and Pattern is Path

Functions not recommended in Qlik Sense

This table describes script and chart functions that are not recommended for use in Qlik Sense.

Functions that are not recommended
Function Recommendation

NumAvg

NumCount

NumMax

NumMin

NumSum

Use Range functions instead.

Range functions

Color()

QliktechBlue

QliktechGray

Use other color functions instead. QliktechBlue() can be replaced by RGB(8, 18, 90) and QliktechGray can be replaced by RGB(158, 148, 137) to get the same colors.

Color functions

QlikViewVersion

Use EngineVersion instead.

EngineVersion - script and chart function

ProductVersion

Use EngineVersion instead.

EngineVersion - script and chart function

QVUser  
Year2Date Use YearToDate instead.
Vrank Use Rank instead.
WildMatch5 Use WildMatch instead.

ALL qualifier

In QlikView, the ALL qualifier may occur before an expression. This is equivalent to using {1} TOTAL. In such a case the calculation will be made over all the values of the field in the document, disregarding the chart dimensions and current selections. The same value is always returned regardless of the logical state in the document. If the ALL qualifier is used, a set expression cannot be used, since the ALL qualifier defines a set by itself. For legacy reasons, the ALL qualifier will still work in this version of Qlik Sense, but may be removed in coming versions.

 

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!