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 list describes script statements that are not recommended for use in Qlik Sense.

Statement Recommendation
Command Use SQL instead.
CustomConnect Use Custom Connect instead.

Script statement parameters not recommended in Qlik Sense

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

Statement Parameters
Buffer

Use Incremental instead of:

  • Inc (not recommended)
  • Incr (not recommended)
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 list describes script and chart functions that are not recommended for use in Qlik Sense.

Function Recommendation

NumAvg

NumCount

NumMax

NumMin

NumSum

Use Range functions instead.

Range functions

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 information help you?

Thanks for letting us know. Is there anything you'd like to tell us about this topic?

Can you tell us why it did not help you and how we can improve it?