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.
| 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.
| 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:
|
Functions not recommended in Qlik Sense
This table 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. |
|
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. |
| QlikViewVersion |
Use EngineVersion instead. |
| ProductVersion |
Use EngineVersion instead. |
| 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.