Qlik Sense: Combo chart orientation changed to horizontal after upgrade to May 2021 or higher

[Andrea_Bertazzo]

Combo charts orientation changes form vertical to horizontal after the upgrade to Qlik Sense May 2021 or higher versions. The problem occurs for combo charts that were originally created as bar charts and then converted.

Environment

• Qlik Sense Enterprise on Windows May 2021 and higher

Cause:

The issue occurs for horizontal oriented bar charts created in older versions that were then converted to combo charts. In these cases, the horizontal property of the bar chart is remembered even though it did not exist in the old combo charts.

The combo charts were updated in latest version (May 2021) with this horizontal property and it was automatically applied to all the charts that inherited it from their previous status as bar charts.

Resolution:

It is necessary to convert all the affected charts to vertical orientation. This can be done either manually by changing the charts properties under "Presentation" or automatically with the program attached to this article.

The Qlik development team provided a script that traverses an app and changes the orientation of the combo charts. The code source is available here and compiled executable here (same as the one attached to this article). Notice that the orientation of all combo charts will be changed to vertical by the script.

That program connects to Qlik Sense on localhost using store certificates, it traverses all apps in the deployment and sets all combo chart orientations to vertical. Please make sure to execute the script with the Qlik Sense service account or a user that does have access to the QlikClient certificate.

Instructions:

1. Unzip the zip file to a folder on your Qlik Sense server central node.

2. Open a CMD prompt and navigate to the folder where the program has been unzipped

3. Run the below command to reorient all charts in all apps:

QlikChartReorienter.exe --all --commit

Internal investigation ID:  QB-6633 

[RajaDumpa]

@Andrea_Bertazzo  : Hi there, we tried the steps outlined below. Its shows the below error message. CertificatesNotFoundInStoreException : No certificate with the name "QlikClient"  found in store error . 

What kind of certificate is this program referring to ? Can you please advice ? 

[Sonja_Bauernfeind]

Hello @RajaDumpa 

That program connects to Qlik Sense on localhost using store certificates, it traverses all apps in the deployment and sets all combo chart orientations to vertical. Please make sure to execute the script with the Qlik Sense service account or a user that does have access to the QlikClient certificate.

All the best,
Sonja