Known limitations

General

• The Modified date available in the Overview tab will only be updated after a run or when any of the name, description or tags of the table recipe are edited, and not when the steps of the table recipe themselves are changed.

• Empty and Null values contained in columns will appear as "NaN" in the Data distribution area instead of the proper label.

• Table recipes can't fully display on small screens. For the best experience, use a screen size that provides enough space for the table recipe interface.

• Table recipes are subject to the same data and field limits that apply when loading data in Qlik Cloud Analytics. For example, a field cannot have more than 2,147,483,648 distinct values, and the total number of fields and rows that can be loaded is limited by available memory. For details, see Guidelines for data and fields.

Sources and targets

• Header detection for CSV and Excel files is not always accurate. If your column names look wrong, try editing file settings. See Configure the file settings of CSV and Excel sources for more information.

Functions

• When working on columns with the date type, the Convert to date function disappears from the suggestions when using a filter.

Collaborative work

• Although collaboration from two users or more on a single table recipe is limited at this time, it is possible for multiple users to edit a table recipe in a shared space. If you open a table recipe, and someone makes a concurrent change, a prompt will open to notify that you need to reload the table recipe. After you get the latest version, you can make your change.

• Table recipes do not currently support the versioning feature found in Scripts and Applications.

Create calculated column function

• Column references must be surrounded by brackets or quotes.

• Some script functions are not supported, even though they are displayed as valid in the expression editor:

  For aggregation functions that exist in both script and chart variants, the script variant is not supported.

  • Aggregation functions (script variant): FirstSortedValue, Max, Min, Mode, Only, Sum, Count, MissingCount, NullCount, NumericCount, TextCount, IRR, NPV, XIRR, XNPV, Avg, Correl, Fractile, FractileExc, Kurtosis, LINEST_B, LINEST_DF, LINEST_F, LINEST_M, LINEST_R2, LINEST_SEB, LINEST_SEM, LINEST_SEY, LINEST_SSREG, LINEST_SSRESID, Median, Skew, Stdev, Sterr, STEYX, Chi2Test_chi2, Chi2Test_df, TTest_conf, TTest_df, TTest_dif, TTest_lower, TTest_sig, TTest_sterr, TTest_t, TTest_upper, TTestw_conf, TTestw_df, TTestw_dif, TTestw_lower, TTestw_sig, TTestw_sterr, TTestw_t, TTestw_upper, TTest1_conf, TTest1_df, TTest1_dif, TTest1_lower, TTest1_sig, TTest1_sterr, TTest1_t, TTest1_upper, TTest1w_conf, TTest1w_df, TTest1w_dif, TTest1w_lower, TTest1w_sig, TTest1w_sterr, TTest1w_t, TTest1w_upper, ZTest_conf, ZTest_dif, ZTest_lower, ZTest_sig, ZTest_sterr, ZTest_upper, ZTest_z, ZTestw_conf, ZTestw_dif, ZTestw_lower, ZTestw_sig, ZTestw_sterr, ZTestw_upper, ZTestw_z, Concat, MaxString, MinString, FirstValue, LastValue.

  • Counter functions: autonumber, autonumberhash128, autonumberhash256, IterNo, RecNo, RowNo.

  • File functions: Attribute, ConnectString, FileBaseName, FileDir, FileExtension, FileName, FilePath.

  • Inter-record functions: Exists, LookUp, Peek, Previous.

  • Mapping functions: ApplyMap, MapSubstring.

  • String functions: Evaluate.

  • System functions: IsPartialReload.

  • Table functions: FieldName, FieldNumber, NoOfFields.

  • Window functions: Window, WRank.