This article explains how to change the default locale in QlikSense Server when you create a new app on the hub.

Environment:

Qlik Sense Enterprise on Windows 

When you create a new application on the hub, the default locale is based on the settings on the QlikSense Server.

In order to change this setting, it is required to change the locale settings on the server for the account that is running the services.

If you run services as local system, you will need to use a tool such as Psexec in order to be able to execute the control panel as local system and change this settings. 

This article will guide you on how to check audit logs to see users' activity on object/sheet/app.

First of all, we would need to enable Audit Logs on Qlik Sense side, to do so, you can follow this guide.

Once done all the steps from the above's guide, then we can check all user activity on object/sheet/level through the Operations Monitor app (from Qlik Sense 2019 release).

In the example below we will see a graphic example of how to check this information from Audit Logs.

User with ID "f9b8183a-bc07-4571-8ccb-94f7a1c5d9db" navigates into app with ID "1e4a22db-7395-46b3-bd43-78bc4cef811f" and then clicks on sheet with ID "1e4a22db-7395-46b3-bd43-78bc4cef811f" and finally selects a dimension:

User performing selections on an app

As we enabled Audit Logs, all traces coming from users selections will be logged on this path location: C:\ProgramData\Qlik\Sense\Log\Engine\Trace\ServerName_Audit_Engine.txt

Now we can check the audit logs directly from Operations Monitor app:

1. Go to Qlik Sense Hub
2. Under streams on the left hand side, click on "Monitoring apps"
3. Then click on "Operations Monitor" app
4. Then we can filter the Audit Logs we enabled before so we can check which actions have been performed on sheet/app level by any user
5. In the example we can see in the gif below, we are performing the following selections to filter:
   1. We first filter by app (where we performed the selections on the bar chart)
   2. Then the gif also shows more filter examples that you could use to filter your data from Audit Logs

Checking logs through the Operations Monitor app

Furthermore, you could also check from logs the object ID and action performed on it on the following columns from C:\ProgramData\Qlik\Sense\Log\Engine\Trace\ServerName_Audit_Engine.txt:

Checking object ID and action performed

Environment

Qlik Sense Enterprise on Windows 

The information in this article is provided as-is and to be used at own discretion. Depending on tool(s) used, customization(s), and/or other factors ongoing support on the solution below may not be provided by Qlik Support.

Related Content 

How to enable Audit Logging in Qlik Sense Enterprise on Windows

What is legacy mode?
Legacy mode in Qlik Sense allows users who have access to the data load editor to write load statements which reference file paths rather than through LIB statements.

Simple example:
Standard Mode:
LOAD * 
FROM [lib://data/data.csv]
(txt, codepage is 28591, embedded labels, delimiter is ',', msq);

Legacy Mode:
LOAD * 
FROM C:\data\data.csv
(txt, codepage is 28591, embedded labels, delimiter is ',', msq);

What are the security considerations when using legacy mode?

Out of the box, for a user to do development in Qlik Sense, they need some combination of two types of access:

1. An ability to create a data connection
2. An ability to read (or see) a data connection

This security model is the intermediary between the user inside of Qlik Sense and the data sources.

When using legacy mode, any user who has access to the Data Load Editor can now access the file system of the local Qlik Sense server as well as any network file shares that the Qlik Sense service account independent of the security rules configured on the Qlik Sense deployment. In this example, the user has access to AttachedFiles, which all users would out of the box, as well as a Salesforce data connection, yet they are still able to load from the data.csv:

This means that the traditional mechanism for ensuring governance and security over data access inside of the Data Load Editor will no longer apply and the user(s) will be accessing the files as the Qlik Sense Service account

What are the benefits of using Legacy Mode?

This is difficult to answer in an exhaustive manner, but generally the benefits are narrowly scoped to deployments where app development, self-service capabilities are disabled or where this level of access is restricted to a vetted set of administrators. Some benefits include:

• The ability to use relative paths in load scripts (e.g. LOAD * FROM ..\..\Customer1\sales.csv). Often used in conjunction with include scripts which allow easy deployment to multiple customers or tenants.
• The ability to use the EXECUTE function (in conjunction with an additional Settings.ini change) to directly call external processes during script execution
• The ability to re-use load statements from QlikView documents in Qlik Sense
• And others

Is legacy mode recommended by Qlik?
For most deployments, no, legacy mode is not recommended. It can be useful in some deployment scenarios where the security concerns are mitigated.

How do I switch to Legacy mode / disable standard mode?
Disabling standard mode - Enabling Legacy Mode - Qlik Sense on Windows

Qlik Sense Legacy mode

Qlik Sense Legacy Mode - Qlik Design Blog

Qlik Sense data files (.QVF) may contain sensitive organizational data.  As such, even though Qlik Technical Support has a very strict Non-Disclosure Agreement, it may be desired to  scrambled specific data before submitting apps Qlik Sense support for investigation.

For the currently available method in Qlik Sense Enterprise for Windows, see Scramble Sensitive Data In Qlik Sense Enterprise for Windows.

Data can be scrambled in two ways:

• Using Qlik Application Automation
• Using a predefined Excel sheet

Before providing the scrambled application to Qlik Support, please check that you can still reproduce the issue within the scrambled application.

Using Qlik Application Automation

The attached automation_scramble_Support.json automation creates a copy of your app before scrambling the data. 

Requirements:

• the app must be stored in a Shared Space (not a Personal Space or Managed Space)
• the user running the automation must have access to the Shared Space
• the tenant must have the Automation feature enabled; scrambling data using Qlik Application Automation is not available in Qlik Sense Business or Qlik Cloud Analytics Standard

To scramble your data using the automation:

1. Download automation_scramble_Support.json
2. Open your Qlik Cloud hub
3. Create a new Automation
   
   
   
   
4. Select Blank automation
5. Right-click the blank automation workspace and click Upload Workspace (see How to import and export automations)
6. Select and upload automation_scramble_Support.json
   
7. Configure the automation:
   1. Click the Get App Information block
   2. Add your app's ID in App Id
      
      
      
      
8. Click Run to run the automation
9. A copy of your app named Scrambled_YourAppName is created

Using a predefined Excel sheet

If Automations are not enabled, or you do not have the correct subscription model, use the attached Qlik Script and Excel file to scramble the data. 

To scramble data using an excel file and a Qlik script:

1. Duplicate the app in the Cloud hub
2. Review the app and work out the list of fields (and related tables) you want to scramble. Replace the contents in the metadata file scramble.xlsx with the list.
3. Upload both the edited scramble.xlsx and scramble.qvs (attached to this article) to a space in your tenant
4. On the duplicated app, paste the following script into the app script editor before any other script statement, including the SET variable statements (which should have been removed or commented out). Substitute the file names stored in the Binary data source location accordingly.

   Binary;
   $(Include=lib://NAMEOFSPACE:DataFiles/scramble.qvs);
   
   CALL Scramble('lib://NAMEOFSPACE:DataFiles/scramble.xlsx');
   
   Exit Script;

5. Reload the duplicated app and review the result
6. Export the app from the hub
   
   

Related Content:

Idea / Feature Request - Data Masking 
Alternative method using APIs and the DevHub: Data Scrambling in Qlik Sense 
Scramble Sensitive Data In Qlik Sense Enterprise for Windows
To access the examples, visit the community post or download it from here. 

Environment

Qlik Cloud 

The following error may occur when reloading data from Ms Excel: “Error: Too many columns in data source (16326) but the limit is 10000."

Resolution

Defect QB-22272 reported to R&D

This was an intentional change introduced in Qlik Cloud but was obviously set as a default limit for Qlik Sense Enterprise for windows as well. 

Information provided on this defect is given as is at the time of documenting. For up to date information, please review the most recent Release Notes, or contact support with the ID QB-22272 for reference.

Workaround:

As workaround, please add this parameter "MaxColumnsInDataSource=0" in "settings.ini" file
1. Stop Qlik Sense Engine service
2. Edit "settings.ini" file from C:\ProgramData\Qlik\Sense\Engine
3. MaxColumnsInDataSource=0 and save "settings.ini" file
4. Restart Qlik Sense Engine service and test

Fix Version:

R&D is planning to turn back as it was before the latest release but I can't predict the version in which a fix will be available.

Cause

Product Defect ID: QB-22272

Environment

• Qlik Sense Enterprise May 2023 and above
• Qlik Sense Cloud

This is a basic example in order to get started with Advanced Analytics Integration in Qlik Sense using PYTHON.

This customization is provided as is. Qlik Support cannot provide continued support of the solution. For assistance, reach out to our Professional Services or engage in our active Integrations forum.

The architecture at a high-level looks like this:



With this new capability, it is possible to add syntax to a chart expression that tells Qlik Sense that a particular expression should not be evaluated on the Qlik Sense server, but instead, all the information and data needed to calculate that expression should be sent via the server side extension on to the back end Python system for calculation.

 After the advanced analytic calculations are completed, the data is sent back to the Qlik Sense Server and to the client for visualization.

For an example with video that uses R-Server instead, see R Integration with Qlik Sense 

Resolution:

In order to display a "Hello World" message in the Qlik Sense App, Perform the steps below:

Note: To obtain the latest HelloWorld example and other Python examples, see Python Examples in Qlik's Github repository. Make sure to check out the GetStarted.md documentation as well.
 

1. Make sure you have Python 3.4 (or later) installed including 'PIP' option. Run python -m pip install --upgrade pip to upgrade to latest version of pip.
2. Install the grpcio package. In order to install it, use: python -m pip install grpcio
3. Install the numpy package. In order to install it, use: python -m pip install numpy
4. Install the nose package. In order to install it, use: python -m pip install nose
5. Install the pandas package. In order to install it, use: python -m pip install pandas
6. Install the google package. Use python -m pip install google
7. Install the protobuf package. Use python -m pip install protobuf
8. May need to install the google API Python package on older examples: If so, use pip install --upgrade google-api-python-client
9. Note: If using Qlik Sense Desktop, add SSEPlugin=<EngineName>,localhost:<port> on a new line in your Settings.ini file located at C:\Users\[user]\Qlik\Sense. For example: SSEPlugin=SSEPython,localhost:50052
10. Note: If using Qlik Sense Server, Create an Analytic Connection. See Creating an analytic connection
11. Create a Qlik Sense app with basic data. In the app attached to this article Inline Load of 2 strings was used. Alternatively, use the HelloWorld example app included with the Server-Side Extension (SSE) package that can be downloaded in .zip format under Qlik SSE. 
12. Note: See example app attached. Create a new KPI object in a Sheet. Under Measures, add: SSEPython.ScriptAggrStr('", ".join(args[0])' , HelloWorldData)
13. A Plugin using Python needs to be written so that you can communicate between Sense & Python engine using gRPC. See attached the example written using the open-source plugin provided by Qlik in order to test this functionality. Please note that these plugins are open-source and support will not be provided for it by Qlik Support (refer to the T&C in Writting an SSE Plugin
14. Run the plugin in CMD prompt, using command: python ExtensionService_helloworld.py  Note: Troubleshoot ModuleNotFoundError
15. You will be presented with this screen
    
    
    
    
16. Now restart Qlik Sense desktop & open your Sense app
17. You should the below object utilizing Python:
    
    

Understanding the Python script & Function:

SSEPython.ScriptAggrStr('", ".join(args[0])' , HelloWorldData)

Eight script functions are automatically added to the functionality of the plugin. What is needed to be covered on the plugin side to fulfill
the functionality is to implement the Script aggregate rpc function.

The syntax of these functions is <EngineSSEName>.<FunctionName>(Script [,Parameter...])
where the Script is a Python script to be evaluated & Parameter is the data sent from Qlik's end.

Here, the ScriptAggrStr function is used which accepts argument of type String & returns a String after an aggregation. The 'join' function in Python method returns a string, which is the concatenation of the strings in the sequence seq. The separator between elements is the string providing this method. From Qlik side, we pass a field called HelloWorldData which contains the 2 strings as we have loaded.

To use SSE function(s) to load data via application load script, the Extension clause needs to be used. See additional information as well as an example under Load > Argument > Extension and Examples > Loading from Analytic connections via the following link: Script Regular Statements: Load.

Related Content:

• R integration with Qlik Sense 
• Analytic Connections - Qlik Sense for Administrators 
• Script Regular Statements - Load - Qlik Sense on Windows 
• Creating an Advanced Analytics Server in 15 minutes using AWS 
• Qlik Server-Side Extension (SSE) with Analytic Connections 
• How to call an external / custom function in Qlik Sense? 
• Qlik Sense Analytic Connection (SSE) Error when reloading App 
   

Monitoring applications reload (Operation Monitor or Session Monitor) fails all of a sudden with error: 

Error: HTTP protocol error 500 (Internal Server Error):
Exception of type 'System.OutOfMemoryException' was thrown.

Looking several lines above you can identify what was the last Data Connection in use:

If the last connection opened was 'monitor_apps_REST_appobject' then it means that there are too many AppObject to load and the system is going out of memory.

Resolution

To work around this issue, it is possible to implement a filter in the data connection 'monitor_apps_REST_appobject' to reduce the amount of application object loaded.

To do so:

1. Open the Qlik Sense Management Console
2. Open Data Connections
3. Edit the Data Connection exhibiting the issue and view the Connection String. The default string will include https://localhost/qrs/app/object/full, which retrieves a full list of app objects.
4. Modify the filter to only obtain a specific AppObject type, such as 'sheet': 
   https://localhost/qrs/app/object/full?filter=objectType+eq+'sheet'

Internal Investigation ID(s):

QB-2436

Operation Monitor and License Monitor apps in Qlik Sense failed to reload with error message;

"Error: QVX_UNEXPECTED_END_OF_DATA: Unexpected character encountered while parsing value: <. Path '', line 0, position 0."

Step 1: Verify the connection string

Check the connection string of the data connections for your monitor_apps_*.
The connection string should be: queryHeaders=X-Qlik-XrfKey%20000000000000000%1User-Agent%2Windows;PaginationType=None; 
If the string is instead: queryHeaders=X-Qlik-XrfKey%20000000000000000%1User-Agent%2Forms;PaginationType=None;  then modify it to User-Agent%2Windows.

Step 2: Create a second Virtual Proxy allowing Windows authentication. 

Create a secondary virtual proxy using standard windows authentication. In our example we use "win" as the prefix. For detailed instructions on how to add a new Virtual Proxy, see Qlik Sense: How to create a new Virtual Proxy. 
 

Step 3: Modify the Data Connection prefixes

Edit all Data Connections prefixed with monitor_apps_ to use the new virtual proxy. Change the connector URL path to contain the Windows authenticated virtual proxy.

Cause:

Operations Monitor and License Monitor apps use the Qlik REST Connector to fetch data. The connector requires Windows Authentication to be successful in fetching data. This issue occurs when no virtual proxy in the Qlik Sense deployment utilizes Windows authentication. 

Environment

• Qlik NPrinting
• Qlik Sense
• QlikView

Issue:

• NPrinting Designer Straight Table Object incorrectly appears as a Pivot Table object
• Qlik App does not have a column header in one or more columns

Resolution

• Open the Qlik App
• Check every column label/header in the straight table for empty 'labels' (the QlikView example below shows that the label is empty)

• Add a column label description or formula for each column with a missing label
• Save the Qlik application and reload the NPrinting Connection

These above steps will allow the object to appears correctly in the NP designer as a straight table

The information in this article is provided as-is and to be used at own discretion. Depending on tool(s) used, customization(s), and/or other factors ongoing support on the solution below may not be provided by Qlik Support.

Related Content

• OP-95933

On Qlik Cloud, a button triggers an automation that should update a variable value.
However, when the automation completes, the value only gets updated in the variable editor, not in the objects that are supposed to show the value.

Environment

• Qlik Cloud 

Resolution

Define the value in the script first with:

SET vNameOfTheVariable='Initial Value';

If the variable is not the declared in the script, the value will only get updated in the editor, as part of the current interactive session.
If the script sets the definition of the variable at reload, then the value will also be accepted for Qlik Sense objects.

Cause 

This is a consequence of the design of the product, as there is a difference according to whether the definition of the variable is set on the script or not.
Our Engine team will have this properly documented with all the details in a future documentation update (ref. EN-5271).

This Techspert Talks session covers:

• Future Visualization Updates
• New Layout Container
• Dynamic Linking with Bookmarks

Chapters:

• 01:59 - New Straight Table
• 02:45 - Background Images, Fine Grid, Font Styling
• 03:45 - Turn off Sheet Title and Tool Bar
• 04:06 - Multi-Language App
• 04:41 - New Filter Panes
• 04:58 - Line Object
• 05:34 - New Rich Text Object
• 06:20 - Layout Container
• 07:21 - Tip 1: Don't go off grid
• 07:43 - Tip 2: Best things are odd, example app
• 09:26 - Tip 3: Image is everything, example app
• 12:15 - Tip 4: Simplicity
• 12:58 - Tip 5: You can, you don't have to
• 15:03 - Setting Default Bookmarks
• 16:34 - Creating Dynamic Bookmarks
• 17:46 - Search Expression Best Practices
• 18:44 - Update Bookmark
• 20:00 - Adding Layout options to bookmarks
• 21:34 - Sharing Bookmarks
• 22:50 - Q&A: Why selection gone after using bookmark?
• 24:30 - Q&A: How can we do multi-page exports?
• 25:08 - Q&A: Can container go inside containers?
• 25:50 - Q&A: How to learn about new releases?
• 26:43 - Q&A: How to change the font of an app?
• 27:12 - Q&A: Do chart settings override the theme?
• 27:46 - Q&A: How to make a filter pane collapse?
• 28:30 - Q&A: Where demo apps are available?
• 29:25 - Q&A: When will the new Text Object be available?
• 29:49 - Q&A: Can you import an Excel chart in Sense?
  30:36 - Q&A: Are values in a Rich Text Object selectable?
• 31:03 - Q&A: Does public bookmarks trigger a notification?
• 31:42 - Q&A: Where to find those Search Expressions?
• 32:26 - Q&A: How to send Bookmark links?
• 32:52 - Q&A: Are some of these add-on features?
• 33:12 - Q&A: How to apply a bookmark to a monitored chart?

Resources:

• Product Innovation Blog
• Color Brewer tool
• What's New - on Help.qlik.com
• Ideation - Technical Preview
• Demos at Qlik.com
• Visualization vocabulary app
• Search Expression Cheat Sheet 2.0

Q&A:

Q: Your multi language apps is really critical to my business as we globalise - where is there more content about how we can handle dimension name translation in line with the native Qlik langauge translations?

A: Dimension names can be renamed in the load script, but it may not be necessary, just translate the dimension labels in the app instead.
Making a Multilingual Qlik Sense App

How to Rename Fields

Q: Do the objects within the new Container have to be master visualizations?

A: No, you don't need to use Master visualizations. You can add new charts to the object or drag and drop existing charts from the sheet.

Q: When will the Layout Container be available?

A: Most likely later this year

Q: After update, there is a problem with filtering a "toString" field. I can't open the application for 10 minutes. What wrong with that field? (e.g. load * inline [toString test1];)

A: Hard to tell without seeing the app and knowing what the field is. As a general rule, keep the cardinality of fields down. If I would guess toString in this case may stop the engine from optimizing the field. To learn more, read HiCs post.

Symbol Tables and Bit-Stuffed Pointers

Q: Will we be able to pin objects to certain locations on the grid? As shown, a sheet menu build using the layout container would be nice to pin to the top left corner for example?

A: In the first release positioning and size will be using percentages. So, if you would have the position 0% for both axis then it would be pinned in the corner.

Click here to see video transcript

After upgrading to QlikView May 2023 on a Windows 2012/Windows 2012 R2 server, WebView no longer works in QlikView Desktop.

• If Microsoft Edge is not installed on the server the result is a blank page
• if Microsoft Edge is installed on the server, a "Rendering on WebView failed!" error pop-up appears

In both cases, WebView cannot be used.

Environment

• QlikView Desktop 12.80 IR or higher, on a Windows 2012 or Windows 2012 R2 server

Resolution

WebView2 is not supported on Windows 2012 R2, as it uses libraries that are not present in the final version of Microsoft Edge  that can be installed on that operating system.
This is a limitation from Microsoft.

Also please note that in our system requirements, we state that we support the operating system "* Provided there is Standard manufacturer Support for the platform. "

As Windows 2012 R2 has now reached the end of standard support, we consider that operating system as no longer supported for any purposes.

Cause

QlikView Desktop has changed its rendering engine to WebView2. WebView2 is a modern Microsoft Edge-based web technology replacing the previous WebView that was based on MS Internet Explorer technology.

The Qlik Sense Reload Monitor app does not reload and if manually reloaded from the hub, remains stuck at the calendarization section.

Resolution

1. Duplicate the Reload Monitor
2. Open the duplicate app
3. Open the Script editor
4. Select Calendarization on the left
5. Select all and replace it with the attached  script from Calendarization.txt
6. Save the app
7. Publish and replace over the existing Reload Monitor app
8. Reload the Reload Monitor app

Cause

A log file includes a line that is being misinterpreted as a date.

Related Content

Qlik Sense Operations Monitor reload takes too long, the calendar generation does not complete (includes a script specific to the Operations Monitor)

Environment

Qlik Sense Enterprise on Windows 

When changing the name of a dataset, the source name still stays the same. This can be seen by uploading a  “firstname.qvd" and renaming it to “secondname.qvd”. 

The dataset's detail will show "firstname.qvd" as the source.

As a consequence:

1. you can have several datasets with the same name, but different sourcenames.
2. the data load editor always refers to the source name (“firstname”), not the data set name. 
   
   
   

   
   Trying to load  “FROM [lib://DataFiles/secondname.qvd]” will produce a "(Connector error: File not found)" error.

Resolution

This is not a defect, it's how the product is designed.

A dataset represents a data resource with its properties such as name. The value of that is that you are able to use more user-friendly names of datasets without having to change the source names, which can be useful when the dataset is pointing to a database table for instance.

In the future, there is a plan to add the possibility of calling the name of the datasets in the script. 

Environment

Qlik Cloud 

When executing the task in DWH, there is no mention of Dropping the Staging tables in the ETL statements. Qlik Compose shows the creation and truncation of these tables only:

Explanation of the behavior:

For TMP tables and TSTG tables, whenever the Qlik Compose engine sees a create statement for these tables, and that is the statement shown in the ETL statements list, it does a DROP for that table in the background (Silently) : 

pool-2-thread-5 2023-10-03 13:29:37.554 [engine ] [VERBOSE] [] PI# 5 BEGIN dropSilentBeforeCreate()
pool-2-thread-5 2023-10-03 13:29:37.636 [engine ] [TRACE ] [] PI# 5 Performed implicit DROP TABLE [ADAM_DWH].[dboAdam].[TSTG_Categories]
pool-2-thread-5 2023-10-03 13:29:37.636 [engine ] [VERBOSE] [] PI# 5 END dropSilentBeforeCreate()

The same behavior can be seen for all the TMP tables Qlik Compose creates.

To verify this, run the task at TRACE level logs, and look for dropSilentBeforeCreate in the logs.

The staging tables are not dropped for customer convenience. This facilitates the development of user-defined statements like Pre/Post Loading ETL and Single/Multi Table ETL, which often involve these tables. Additionally, customers find it useful to have them available for adding test data during their development process, especially when Qlik Compose is not active.

Environment

Qlik Compose 

The following error can occur when using SAP BW Connector to extract data from InfoProvider/CompositeProvider.
--------
[ERR] [QVX] RfcAbapException:JOB_CANCELLED
Job aborted, check log for Job /QTQVC/READ_MPDATA in Job Overview (transaction SM37)
---------

Environment

• Qlik SAP Connector

Resolution

Reported bug QB-18952 was closed by R&D as WAD(working as designed) .

Information provided on this defect is given as is at the time of documenting. For up to date information, please review the most recent Release Notes, or contact support with the ID  QB-18952  for reference.

Workaround

From the SAP System,

1. Go to transaction SE37 and execute function module /QTQVC/GET_METADATA. 
2. Check the concerned INFOPROVIDER

The allowed maximum width  is 8192 characters.

From the INFOPROVIDER, if the field is of, for example 15282 characters wide, a simple workaround would be to split the extraction into two or more extractions. Then in Qlik Sense or QlikView, depending on your data model, use JOIN / CONCATENATE.

Cause

Product Defect ID: QB-18952

A Qlik Sense App may load slowly in the Qlik Sense Enterprise on Windows hub.

Resolution

Qlik advises following our best practice guides when designing and publishing an app.

See:

• Optimizing app performance 
• Best practices for data modeling 
• Best practices for choosing visualization types 
• Best practices for designing visualizations 

In addition, the following five points may impact load times:

Qlik does not recommend against using the options below, but to keep them in mind when designing an app or measuring its performance. For a more hands-on and individual appraisal of your app and how to streamline it, please contact our professional services.

1. Session access
   
   Session access evaluation has not cache, it is always evaluated on each app open. So it is important that the section access script is optimized to avoid loss of time at any opening.
   Group based reduction is a great improvement recommended to shorten Session Access list and make calculation cache reuse more efficient.
   
   Defining data reduction by user ID adds unnecessary processing and calculation cache segregation. Changing to group-based reduction adds a noticeable performance improvement.
   
   
2. Security Rules
   
   Wide use of string-based "like" comparison instead of "=" comparison in rule leads to large processing overhead. Try to use fewer and simpler rules to speed up the opening process.
   
   
3. Static Content should be reduced whenever it is possible
   
   In particular, thumbnails images for the sheets in the app overview, leads to a noticeable time cost for the download. Part of processing time is derived from security rule evaluation per image, which improves with the security framework.
   
   If possible, avoid to use unique thumbnail images for sheets and choose one common logo image for all.
   
   
4. Calculated dimensions
   
   Reduce the number of calculated dimensions or dimensions defined by an expression. For more information, please, follow this article.
   
   
5. Network
   
   Network aspects should also be taken in consideration, especially if the delay occurs more often when users connect from home than from the office, or from a region more that others.

This Techspert Talks session addresses the following:

• Discover different chart types
• Learn about new capabilities
• Visual Analytics best practices

• 00:00 – Intro
• 01:10 – Pareto Chart
• 03:01 – Most sold combinations
• 04:38 – Display Null values
• 06:08 – Annotations in a chart
• 07:28 – Using Zoom when sharing
• 08:43 – The sorting in a Pivot Table
• 10:49 – Setting colors in charts
• 12:51 – Sheet background images
• 14:04 – Fine grid settings
• 15:02 – Slope Chart
• 16:31 – Sunburst Chart
• 18:17 – Org Chart
• 19:55 – Q&A: Can get around Line Chart dot limits?
• 21:24 – Q&A: New Visualizations?
• 22:50 – Q&A: How to do neat filters?
• 23:50 – Q&A: How to widen the Master Items column?
• 24:28 – Q&A: How to do Regression Analysis?
• 25:08 – Q&A: How to adjust label size?
• 26:08 – Q&A: Is there a browser zoom alert?
• 26:55 – Q&A: How to adjust color of KPI?
• 28:54 – Q&A: How to limit a map chart?
• 30:06 – Q&A: How to build a Bullseye chart?

Resources:

24 Days of Visualizations, season 2

Recipe for Cyclic Groups

Recipe for an ABC Analysis

Let’s Make New Charts with Qlik Sense 

Click here to see video transcript

Several patches to May 2023 worked to resolve issues with quoted entries when using Modern Style Quoting (MSQ) for multi-line entries in CSV files. These resolved the issues raised at the time but resulted in a change in behavior when parsing quoted entries with a space after the delimiting character.

As an example, the following entry from a CSV:

A,"B
on 2 lines",C

This is parsed correctly as:

This is due to there being no space between the comma and the quoted B field

However the following entry:

A, "B
on 2 lines", C

The entry is parsed as:

The multi-line quoted field is not parsed due to the space after the comma (or whatever delimiter is specified)

Environment

Qlik Sense May 2023

Workaround:

A fix for this behavior will be delivered in a patch at a future date, though where feasible removing the spaces after the delimiting character will allow Qlik Sense to properly parse the file.

Fix Version:

August 2023 Patch 2
May 2023 Patch 6

Cause

Product Defect ID: QB-21429

Using Office 365 Sharepoint Connector (single file)

1. Identify base URL and site/Subsite Path. For example:
   • BaseURL: 
   • 
   • Site/subsite path: sites/SupportTrainingandEnablementDevelopmentArea
   • 
2. Configure the Connection
   • 
3. Click on the Authenticate button
4. Copy the Authentication code from the Authentication tab into the field and click 'Verify'
5. Proceed to the app by clicking on the Create and Analyze  button
6. Locate and select file in the folder
   • 
7. Select Table and Fields
   • 
8. Apply and necessary table associations
9. Load the data

Environment

• Qlik Cloud

The information in this article is provided as-is and to be used at own discretion. Depending on tool(s) used, customization(s), and/or other factors ongoing support on the solution below may not be provided by Qlik Support.

Click here to see the video transcript

@Bjorn_Wedbratt