Qlik Sense Chart-level scripts: REPLACE LOAD ..... RESIDENT HC1 does not return expected result

[Joseph_Musekura]

The conclusions in this article were reached in collaboration with cjgorrin from the European Commission's Joint Research Centre Qlik Sense team.

With Qlik Sense's new feature, Chart-level scripts, the Replace prefix replaces all values ​​in the HC1 table with a calculated value defined by the script.

Based on the Qlik Sense online documentation, using the attached CHART LEVEL SCRIPT_REPLACE RESIDENT load.qvf, we would expect the table to display the correct result regardless if an as (alias statement) is used or not.

Example One: Even if "as" is not used in the REPLACE statement, the error Load statement with star ('*') not supported in hypercube is displayed.

REPLACE LOAD 
  MyDim1, 
  MyDim2, 
  MyMeasure1, 
  MyMeasure2
RESIDENT HC1;

Example Two: If "as" is used in the REPLACE statement, no error is displayed but all rows are loaded with the same values. The values should remain unchanged.

REPLACE LOAD 
  MyDim1 as MyDim1, 
  MyDim2 as MyDim2, 
  MyMeasure1 as MyMeasure1, 
  MyMeasure2 as MyMeasure2 
RESIDENT HC1;

Resolution

This issue is caused by QB-27902, which will be resolved in an upcoming release of Qlik Sense Enterprise on Windows. Monitor the Release Notes for details.

Cause

REPLACE LOAD when used in a dynamic chart-level script is using only one row for the source data regardless of the actual number of source rows. It also incorrectly added rows to the chart.

Internal Investigation ID(s)

QB-27902

Environment

• Qlik Sense Enterprise on Windows May 2024