This Techspert Talks session covers:

• What Qlik Cloud Reporting can do
• Alerts and Subscriptions
• Migration process

Chapters:

• 01:29 - Qlik Cloud Reporting strategy
• 02:13 - How to Monitor Charts
• 04:18 - How to set Data Alerts and Subscriptions
• 06:32 - Shared Subscriptions with Section Access
• 07:49 - How to use Automation with Reporting
• 09:23 - Using Themes
• 11:08 - Distributing to Recipient Lists
• 13:18 - Excel Tabular Reports with the Qlik Add-in
• 16:58 - How to use Reporting Templates
• 18:53 - Using Filters
• 20:30 - Using NPrinting Excel report templates
• 22:36 - Q&A: How to trigger a monthly report?
• 23:11 - Q&A: How many reports sent for free?
• 24:36 - Q&A: Can NPrinting templates be used in Qlik Cloud?
• 25:21 - Q&A: Available Report format options?
• 26:12 - Q&A: Can selections be applied dynamically?
• 27:05 - Q&A: A separate license for Cloud Reporting?
• 27:48 - Q&A: What Role is needed for Alerts/Subscriptions?
• 28:24 - Q&A: Is App Access required?
• 28:53 - Q&A: Will Alerting and NPrinting be deprecated?
• 29:53 - Q&A: Is the EAP still open?

Resources:

Qlik Ideation

Qlik Cloud Reporting – Improving Table Presentation

Reporting Service Forum

How to send an Excel report as an attachment using Qlik Application Automation

Creating an Automation from Templates

Tips For Designing Application Automation Reporting Reports

Click here to see video transcript

@Andrew_Kruger 

Join Qlik Support's office-hours, recorded live, where our experts answer your questions and give more insight into our data analytics products and features. This month's topic talk is New to Qlik Cloud.

Questions:

• 02:37 - New Onboarding Sites
• 07:47 - What's a Tenant?
• 09:12 - SaaS App Demonstration
• 11:15 - Path to the Onboarding material
• 13:12 - Is a Tenant similar to streams?
• 14:34 - Is Dev, Test, and Prod treated as separate tenants?
• 15:53 - Qlik automation with Excel and SharePoint connector the best replacement for Qlik Cloud Nprinting functionality?
• 17:22 - What Qlik products will be available in Qlik Cloud Replicate, and if Replicate, how are firewall rules handled?
• 17:56 - Using Section Access to control what internally and externally users can view.
• 20:00 - Are there any free trainings available?
• 23:07 - How often does a tenant back up?
• 27:42 - Can you clone a user so all the apps they have access to carry over to the new users as well as space access?
• 29:51 - Are there any difference between Qlik View and Qlik Sense?
• 30:18 - Can I put Qlik Sense and Qlik View in the same tenant?
• 31:50 - Plan to add better file management options?
• 33:47 - How to implement sheet access by group membership in Qlik Sense Cloud?
• 37:03 - If a personal app is deleted but the published app exists, how do I retrieve it?
• 37:50 - ETA on the QBDC AS-400 data connector for Cloud
• 40:12 - Can Excel files stay on on-prem instead of uploading it to Qlik Cloud storage?
• 40:45 - User group data brough via single sign-on, is this available from within an app?
• 43:15 - Using AI secure with preventative without having it exposed outside of QS Cloud?
• 44:58 - Does the Qlik Replicate Oracle to Oracle data support the lift and shift approach from on-prem to the Cloud?
• 45:38 - Optimizing an app that is taking, 3 to 5 mins to load.
• 47:08 - Is there a clear list of what we can get with SaaS?

Resources:

Qlik Cloud Admin Onboarding

Qlik Cloud Best Practices

Migrating QlikView to Qlik Cloud

Qlik Cloud: Unpublish an app with the REST API

List of supported ODBC connections

App Performance Evaluation

Get Progress Method

Qlik Cloud Analytics Plans and Pricing

Did we answer your question? Let us know by clicking the like button!

Click here to see video transcript

@eherndon @Troy_Raney @Mario_Petre @spmayle @SwathiPulagam @Daniele_Purrone  

Join Qlik Support's office-hours, recorded live, where our experts answer your questions and give tips and best practices for Qlik Replicate. Experts share knowledge of the limitations and considerations for Qlik Replicate. This month session: Qlik Replicate Best Practices

Questions:

• 01:46 - What should be done prior to upgrading?
• 03:50 - How to make end destination schema different from source?
• 05:01 - Estimated release for GenAI feature?
• 06:13 - Plans to support older SQL endpoints?
• 06:55 - Possible to replicate Open Edge database?
• 08:04 - How to drop a recreated table index in a task script?
• 09:11 - How to adjust how long redo archives are kept?
• 10:02 - How to change the ports that are used?
• 12:14 - How to manage multiple servers with around 100 tasks each?
• 14:23 - In AWS, what is the recommended share drive for high availability?
• 15:34 - Should it run on port 3552 to disable legacy protocol?
• 17:04 - Why empty rows when extracting from SAP?
• 19:53 - How to schedule downtime for tasks?
• 20:46 - Does Replicate support clustering?
• 22:08 - Recommended AWS service for shared storage?
• 23:00 - How to capture only specific operations (updates, inserts, or deletes)?
• 23:50 - Is there an Open Edge connector?
• 24:46 - Is it better to have one multi-billion record task or to split it?
• 27:06 - Is it possible to resume a PostgreSQL task instead of running a full load?
• 29:28 - How to capture DDL changes without a full reload?
• 31:36 - How to improve performance from SAP to Qlik Cloud?
• 33:14 - How often should Qlik Replicate be upgraded?
• 35:21 - Possible to replicate non-cluster index AND where are parameters documented?
• 36:37 - Can we give task level permissions to security groups?
• 37:26 - How to apply non cluster indexes?

Resources:

Qlik Replicate Headers

Suggest an Idea

Qlik Replicate Limitations and Considerations

TLS Support Documentation

Task Scheduling Documentation

Setting up Qlik Replicate in a cluster environment

High Availability cluster install process

 Did we answer your question? Let us know by clicking the like button!

Click here to see video transcript

@eherndon @KellyHobson @Steve_Nguyen @Dana_Baldwin @Bill_Steinagle 

This Techspert Talks session covers:

• What the app can do
• How to deploy it
• Troubleshooting demonstration

Chapters:

•  01:23 - Log Collector

• 02:28 - Qlik Sense Services

• 04:17 - How to load data into the app

• 05:42 - Troubleshooting poor response times

• 08:03 - Repository Service Log Level

• 08:35 - Transactions sheet

• 12:44 - Troubleshooting Engine crashes

• 14:00 - Engine Log Level

• 14:47 - QIX Performance sheets

• 17:50 - General Log Investigation

• 20:28 - Where to download the app

• 20:58 - Q&A: Can you see a log message timeline?

• 21:38 - Q&A: Is this app supported?

• 21:51 - Q&A: What apps are there for Cloud?

• 22:25 - Q&A: Are logs collected from all nodes?

• 22:45 - Q&A: Where is the latest version?

• 23:12 - Q&A: Are there NPrinting templates?

• 23:40 - Q&A: Where to download Qlik Sense Desktop?

• 24:20 - Q&A: Are log from Archived folder collected?

• 25:53 - Q&A: User app activity logging?

• 26:07 - Q&A: How to lower log file size?

• 26:42 - Q&A: How does the QRS communicate?

• 28:14 - Q&A: Can this identify a problem chart?

• 28:52 - Q&A: Will this app be in-product?

• 29:28 - Q&A: Do you have to use Desktop?

Resources:

The Qlik Sense app for troubleshooting Qlik Sense Enterprise on Windows logs

How to download Qlik Products

Qlik Downloads page

Ideation page

Click here to see video transcript

Join Qlik Support's office-hours, recorded live, where our experts answer your questions and give more insight on common issues encountered while upgrading your Qlik Sense Enterprise on Windows deployment, best practices, and important configuration settings. This month's topic is: Upgrading Qlik Sense.

Questions:

• 00:00 - Intro
• 02:36 - Qlik Sense version recommendation.
• 04:31 - Best way to upgrade Qlik Sense from February 2022 to February 2023.
• 07:38 - Importing Word document into Qlik Sense Cloud.
• 08:29 - Qlik Sense Client Management.
• 11:04 - Instructions on upgrading to latest version of Qlik Sense.
• 12:27 - Best way to avoid deprecated features issues.
• 13:54 - Patches: installed in order version or jump to the latest patch?
• 15:05 - Post Upgrade Issues with widgets deprecation.
• 16:38 - Navigation guide document in the Qlik Sense cloud.
• 17:54 - Geo Analytics Plus Update with latest Qlik Sense EM installer
• 19:09 - RIM nodes upgrades be notified if the Qlik Repository database service is not running?
• 21:36 - Access to files without a license; Data Catalog license
• 23:21 - Should the service's account have a license or not?
• 26:04 - Any Issue bypassing versions? Ex. Feb 22 to May 23
• 27:02 -Safer to use installer for Postgres upgrade 9.6 to 12?
• 29:28 - Postgres installer Issue 14.8
• 31:41 - is there a recommended upgrade path for people running older versions?
• 33:24 - What to know when upgrading OS central node from Windows Server 12 to 19?
• 35:48 - Migrating from Qlik View from Nov ’17 to Qlik Sense Cloud
• 37:22 -Avoid restoring all passwords for data connections after the upgrade.
• 39:46 - Can multiple RAM nodes be updated at the same time?
• 40:21 - Can you please recommend how to resolve the Postgres SQL vulnerabilities?
• 41:21 - Noticeable advantages running Postgres 14 over 12.5.
• 41:57 - Roadmap on Qlik Sense version compatible with the newer DB version
• 44:19 - Postgres SQL password issue after upgrade Postgres Database

Resources:

Upgrading Qlik Sense Repository Database using the Qlik PostgreSQL Installer

How to count sessions in Qlik Sense

How to backup or restore the PostgreSQL database in Qlik Sense

PostgreSQL 14.8 Release Notes

Qlik Sense Upgrade Guide - Step-by-Step plus common issues and tips included

Migrating QlikView to Qlik Cloud

How to change the Qlik Sense Enterprise on Windows PostgreSQL password

 Did we answer your question? Let us know by clicking the like button!

Click here to see video transcript

@MarioPetre @Alan_Slaughter @Jay_Brown @Mike_Dickson @Boris_Iwan @eherndon 

This Techspert Talks session covers:

- Supported PostgreSQL versions

- Demo of Upgrade Process

- How to resolve issues

00:00 – Intro

01:00 - What is PostgreSQL used for?

01:19 - Different versions of PostgreSQL

02:38 - Prerequisites for upgrading

03:21 - QS Feb 2022 threshold

04:33 - Downloading the QPI Installer

06:00 - Upgrade process

09:54 - Verifying a successful upgrade

12:08 - Removing the old Database Service

14:16 - Resolving common issues

17:28 - Q&A: When is best time to upgrade?

18:05 - Q&A: Does the QPI Tool use the latest version?

18:27 - Q&A: Which versions should you be careful with?

18:55 - Q&A: What are the Do's and Don'ts?

19:44 - Q&A: What should we upgrade first?

20:28 - Q&A: How to we avoid having to restart the upgrade?

21:22 - Q&A: Can we upgrade the database only?

21:47 - Q&A: Is it possible to lose any custom settings?

22:31 - Q&A: How to tell which version QS is using?

23:35 - Q&A: What is the command to remove the old service?

24:12 - Q&A: What if the database is on the D drive?

24:50 - Q&A: Can the back-up be on ANY local drive?

25:05 - Q&A: Are old version of QS compatible with new PostgreSQL?

Resources:

Upgrading Qlik Sense Repository Database using the Qlik PostgreSQL Installer

 Qlik Sense Enterprise on Windows: How To Upgrade Standalone PostgreSQL

 Qlik Sense System Requirements

 How to backup or restore the PostgreSQL database in Qlik Sense

 Q&A:

Q: Do patch updates and new versions normally work?

A: The Patch update for Qlik Sense will continue to work normally. It is suggested that you do make sure that you remove the Qlik Sense Repository Database service after installing the standalone version of PostgreSQL so that you do not run into any issues with the Qlik Sense setup or update.

Q: For Standalone installs, is there a way in Qlik Sense to see the standalone server name for the Postgres server?

A: Yes! Using the Qlik Sense Util (C:\Program Files\Qlik\Sense\Repository\Util\QlikSenseUtil), you can view the Connection String Editor tab to get the “Host” name being used which is typically the server name or localhost

Q: If I have a postgreSQL 11.x version, how longer can I wait before upgrading it to the 12.x version?

A: We don’t have a specific timeline on how long 11.x will be supported with Qlik Sense. So, it is not required to upgrade if you do not want to as it will continue to work with Qlik Sense. Only 9.6 is no longer supported after November 2022 version of Qlik Sense.

Q: From which version will Qlik have already installed 14.8 version?

A: Currently 12.5 is still being used within the standard installation of Qlik Sense. Qlik is working on including 14.8 with the Aug 2023 version of Qlik Sense. This is not set in stone, but it is the tentative release version.

Q: How can I update the PostgreSQL standalone on Azure?

A: You can follow the procedure provided on the Azure help site for upgrading the PostgreSQL.

https://learn.microsoft.com/en-us/azure/postgresql/single-server/how-to-upgrade-using-dump-and-restore

Q: Do you have a process for migrating to Qlik Cloud service from an older on-prem / Azure VM instance?

A: Yes. Here are two resources to help with that:

https://help.qlik.com/en-US/migration/Content/Migration/Qlik-migration-playbook.htm

https://help.qlik.com/en-US/migration/Content/Migration/qliksense-qliksense-planning-your-migration.htm

Q: Is it possible to restore a 9.6 QSR onto a standalone 12.x?

A: Yes, you can restore any of the older version of the QSR database to a newer version of PostgreSQL.

Q: In future QS on Windows, this setup will be standard - separate PostgreSQL service and no Qlik Repo service?

A: No, it is not the “standard” as we still include the Qlik Sense Repository Database with new installs of Qlik Sense. It is just another way to easily upgrade the database and provides a little more flexibility for the environment.

Q: Is it possible to restore the old service after deleting it to restore to the old PostgreSQL Service? As you mentioned, I need to delete it before running an update.

A: It would not be suggested to do this because the only way to install the Qlik Sense Repository Database Service is to do a clean installation of Qlik Sense. This will install PostgreSQL 12.5. If you used the QPI tool the new database version would be 14.8 and it would not be advised to restore to an older version.

Click here to see video transcript

Join Qlik Support's office-hours, recorded live, where our experts answer your questions and give more insight on our data analytics products and features. This month's topic talk is: Qlik Cloud Login Troubleshooting.

Questions:

• 01:49 - Use Qlik Cloud with two IdPs configured?
• 02:24 - Next question, how do I find disabled users?
• 06:32 - Follow Up: What about more than one method, name or email for login?
• 07:19 - Understanding session timeout: What's the standard session duration or timeout limit?
• 08:59 - What all possible issues could occur regarding logging into Qlik sense SaaS Cloud?
• 11:44 - Do we have any limitations with long Okta names?
• 12:50 – Can you open On-premise apps and SaaS apps, supposing you have the same IdP?
• 14:49 – How to setup an IdP on a SaaS tenant that already has user created?
• 16:25 - Any considerations for email address to work for Qlik ID and IdP?
• 18:02 - Are there any limitations around the number of groups created in Qlik Cloud via the IdP?
• 18:54 – Newly added Cloud users are losing their on-premise access.
• 19:58 - How to ensure users are directed to the correct stream, when logging in?
• 21:39 - Suitable alternative than NPrinting in Qlik Sense SaaS Cloud?
• 24:35 - Session Timeout: Idle vs Logging back in?
• 27:14 - Creating Separate space for external users with the ID?
• 29:07 - How to fix a situation where an invite for a user has expired?
• 30:36 - Setting up a group manually before users logged in to Qlik Cloud with the group?
• 31:48 - How to set up Google Cloud as the IdP with Qlik Cloud?
• 33:30 - Can’t get Azure Ad group member read all to work. Any tips?
• 36:41 - How do I log into Qlik Sense desktop with Qlik Cloud?
• 37:50 – How to fix “no access pass” error”?
• 39:02 - Can you explain how capacity licensing works?

Resources:

• Qlik Cloud Best Practices
• Okta login limitations documentation
• Video guide for Azure
• Single sign-on with Google
• The URL/API call for checking groups: https://<tenantURL>/api/v1/groups

Did we answer your question? Let us know by clicking the like button!

Click here to see video transcript

@eherndon @Frank_S @Qlik_Eric_Thomas @Vinay_B 

This Techspert Talks session covers:

• How to load on-premise data
• Scheduling reloads via API & Automations
• Managing Users
• Managing Apps & Spaces

• 00:00 - Intro
• 00:57 - How to connect to on-premise data
• 04:29 - Where to download Qlik Data Gateway
• 06:01 - How to build a task chain with Application Automation
• 09:00 - How to trigger an Automation with APIs
• 11:40 - How to manage spaces & resources
• 14:40 - How to manage Groups
• 17:26 - How to troubleshoot user access
• 19:20 - Q&A: Does an Alias affect data connection?
• 19:51 - Q&A: Why manage resources in Qlik Cloud?
• 21:10 - Q&A: How to change the font of all objects?
• 21:50 - Q&A: How to use color to highlight KPIs?
• 22:47 - Q&A: Where is Qlik Sense Desktop?
• 23:36 - Q&A: Can you use extensions with Qlik Cloud?
• 23:56 - Q&A: How to make all sheets public?
• 24:22 - Q&A: How to copy apps to a Development space?
• 25:20 - Q&A: What are the User Roles? New ones?
• 26:21 - Q&A: How to hide the QVD files in a space?
• 27:09 - Q&A: How to migrate bookmarks to Qlik Cloud?
• 28:14 - Q&A: Can Data Gateway load flat files?
• 28:52 - Q&A: How to version control in Qlik Cloud?
• 29:46 - Q&A: Which Role can trigger a reload?
• 30:21 - Q&A: How to connect Azure AD as IdP?
• 30:47 - Q&A: What are monitoring apps for Qlik Cloud?
• 31:21 - Q&A: How to load from Google Spreadsheets?

Resource:

Date Gateway Installation Guide

Space Aware Data Syntax documentation

Qlik Developer site

Version Control with Application Automation

How To: Configure Qlik Sense Enterprise SaaS to use Azure AD as an IdP. Now with Groups!

The Qlik Sense Monitoring Applications for Cloud and On Premise

How to change the font in an app

How to work with Custom Themes

Q&A:

Q: Can we trigger tasks at the source of the data?

A: Yes, you can trigger both App Reloads and Application Automations via API requests that could be performed from the data source.

Q: How can we load from data in a DMZ?

A: Depends on if the Data is in the DMZ layer or behind it in an Internal LAN (with no internet). If you can get to the internet, whitelisting QCS or utilizing Data Gateway. No internet, likely need to be creative and utilize flat files and file transfer capabilities to get the data where Qlik Cloud can reach.

Q: I'm migrating from on-prem to the cloud, but I have large qvd (~30GB) that can't be uploaded to the cloud, how would you suggest to handle this and also how to work with large qvd's since the memory is limited?

A: I think our documentation doesn’t recommend going over 6gb for qvd sizes. Dedicated Capacity is a license addon offered to give more resources for larger applications. For the QVD themselves, you could begin splitting them into smaller qvds based on a relevant Dimension e.g. Product, Year, Region etc.

Q: "api/v1/diagnose-claims" where do you want us to run? In the end-user browser?

A: Yes, sorry if that wasn’t clear. After a user has logged into Qlik cloud, that endpoint can be added to the url in the end-user's browser to view the claims relevant to their user.

Q: What is the number of  users limitation for altering and notification?

A: The number of alerts that you own or subscribe to, is limited to 50. Disabled alerts also count towards the limit.

Q: What is backup solution with Qlik cloud? Does it take all the QVDs?

A: The platform itself has backups. 3^rd party services can also be used to store backups of apps/qvds. E.g. Github for apps or S3 for qvds

Q: Is there a way to monitor app utilization in Qlik Cloud?

A: Currently, the Entitlement Analyzer app provides this functionality

Q: Having transformed data that shall be reused by several apps in several spaces. How do you set that up in the best way?

A: Hard to be specific in this scenario, you could centralize the QVDs/Data Connections in an ‘ETL’ space and utilize them in the other applications.

Q: How do you delete multiple files from a data-space, we found only one way, create an app, open editor, select space and delete files one by one …

A: This is likely the best option short of scripting something out via APIs. There is no delete all.

Q: Can you have automation in chain that run in parallel?

A: There is a template that demonstrates apps reloads in parallel and multiple automations can run simultaneously. There is a limit though and at a certain point will queue up

Q: Can I centrally turn off the notification that the users would get, when users (not group) added to a space?

A: Notifications per user can be managed at /settings/notifications

Q: I wasn't aware of the Space-aware data source thing, thanks for the tip. When using this, does it mean that you have to store your QVD loader app in the same space as the QVDs? (I think this would be a no-no in enterprise, but maybe less of a problem in cloud)

A: Yes, if a space is not specified, this syntax will utilize the connections/data files from the space the app resides in. There are roles that dictate if a user can utilize data files/connections in a space

Q: When looking at the claim, I see what I am passing, but how can I see what Qlik is accepting?

A: If you are using the /api/v1/diagnose-claims endpoint, you are seeing what Qlik Cloud is aware of

Q: What's the easiest way for Analyzer users to load an app with the click of a button? Will this be possible like it is for Professional users in the future, i.e. having a button that can directly carry out the "Reload data" command?

A: A user with Analyzer or Analyzer Capacity license cannot modify an app. This is by design and is not likely to change.

Q: If not using Groups, is there a way to clone a user.  Example: New employee needs same access rights as John Doe.   Also is there a way to see all apps that a user has access to. Thanks…

A: Not that I'm aware of. You can use something like /v1/spaces

Q: Are there best practices for data sources to be consumed by apps in different spaces. Should these shared data sources be bundled in a dedicated space?

A: There are permissions for every space that determine whether those Data Connections/Data Files are available to members, that is probably the most important consideration.

Q: Which world region is Qlik Cloud using? Can we relocate it closer to our cloud provider storage region?

A: Current regions are Americas, Europe, APAC, Singapore

Q: Is there any goods practices  to manage section access?

A: Here is a great Techspert Talks sessions addressing section access. It’s the same for Qlik Cloud as Qlik Sense Enterprise on Windows: https://community.qlik.com/t5/Techspert-Talks/STT-Troubleshooting-Section-Access-in-Qlik-Sense-Enterprise/m-p/1800067

Click to see video transcript

Our Qlik experts offer best practices and helped users get the most from their Qlik Replicate implementation. They answered questions about setting up tasks and some end-point specific configuration settings.

Questions:

• 03:07 -What should be checked prior to upgrading Qlik Replicate?
• 04:30 - Can Qlik Replicate rights to QVDs as an endpoint?
• 05:21 - Any documentation on Python API?
• 06:06 - Is it possible to join tables within a Qlik Replicate task?
• 07:24 - Are there any future Replicate plans to support Oracle autonomous as a source endpoint?
• 08:30 - Is single sign on or SAM authentication on the roadmap for Qlik Replicate on-prem?
• 9:06 - What are some of the new features that we should know?
• 10:34 - Replicate prerequisites are incomplete. Don’t see libraries like Enum 43 and EM Client?
• 11:47 - Will APIs support, adding and deleting endpoints soon?
• 13:18 - For larger tables, is there a eat to force Replicate not to use parallel loading?
• 14:59 - Documentation on all Replicate commands with examples
• 15:38 - Why does Oracle Source table require a primary key to Replicate to an Oracle target?
• 16:20 – What’s the best upgrade path from an older version?
• 18:20 - Roadmap for support of integration to MQTT for IoT devices?
• 19:13 - Any roadmap to support cloud ERPs to extract data via APIs?
• 20:12 - Best practice when we must truncate and reload a fact table?
• 21:11 – We need to resume or reload tasks, is there a way to run all tasks at once?
• 22:18 - How does somebody access Postgres database that resides on a QEM?
• 23:02 - “Any tips for avoiding when resuming processing?
• 24:18 – Where can we subscribe for notifications when new releases are available?
• 25:18 – Where are Console command lines for Replicate?
• 26:06 - How does replicate handle independent data marts?
• 27:10 - While importing tasks, are there plans to introduce a way to merge tasks?
• 29:09 - Is parallel loading an option with Azure Data Lake Storage target?
• 29:54 - Does Qlik Replicate handles foreign keys?
• 30:51 – How to interpret “fail to get a value for name int tab” error?
• 31:54 - Any roadmap to support Snowflake as a standard source endpoint?
• 32:10 - Question 21 Part 2:
• 33:31 - Qlik On-Prem: What's the typical upgrade path to SaaS?
• 34:53 – How to normalize Log Stream tables in a OLTP in cases of failure?
• 35:54 - Disable replicate article, truncate the table, then reload, any advice?
• 36:52 - Any SAP transports required to use the new SAP ODP connection type?
• 37:57 – How to run a Log Stream staging task for synchronizing data?
• 38:40 - Can we right click replicate logs alone to a separate drive or folder?
• 39:17 - Any idea why this write is needed in an Oracle database for replicate users?
• 40:17- What is the optimal way to migrate from dev to production?
• 41:56 - How to merge an existing task with another task containing also other tables.
• 44:00 - Are there any timed sleep functions in Qlik Replicate?
• 44:35 - Is there a better way to manage a single endpoint to control the HDFS folder?
• 45:38 - How can I do CDC if the table has no primary key?
• 46:37 - Is there a way for Qlik Replicate to run a post load script after a full load completed?
• 47:04 - How to resume the child task if Log Stream parent task has failed due to some reason?

Resources: 

• Enterprise Manager Python API
• Qlik Replicate PDF Guide
• Qlik Replicate Release Notes
• RepCTL Command Line
• Parallel Load 
• Qlik Ideation 
• Qlik Help

Did we answer your question? Let us know by clicking the like button!

Click here for video transcript

This Techspert Talks session addresses:

• How to get started
• Making API calls
• Using Predictive Analysis

• 00:56 - What is AutoML?
• 01:31 - Iris demo intro
• 02:46 - Demo working AutoML Iris app
• 04:40 - How to setup data for AutoML
• 10:06 - ML Model Management
• 11:18 - How to add AutoML to a Sense App
• 13:56 - Prediction Analysis in a KPI object
• 15:19 - Batch predictions
• 16:35 - HR Promotion Analysis
• 18:00 - Additional Resources
• 19:00 - Q&A: Can the experiment data set be updated?
• 19:58 - Q&A: Is AutoML free?
• 20:36 - Q&A: What is the data size limit?
• 21:17 - Q&A: Can I choose my own index?
• 22:05 - Q&A: Is AutoML on for Qlik Cloud?
• 22:20 - Q&A: What data sources can be used?
• 22:52 - Q&A: Does AutoML work with Snowflake?
• 23:59 - Q&A: How to troubleshoot a connection error?
• 24:20 - Q&A: How do you schedule an the predictions?
• 24:43 - Q&A: Where can we find more documentation?

Resources:

How To Get Started with Qlik AutoML

AutoML Hands On Tutorial

Qlik AutoML Demonstration Overview

Introduction to Qlik AutoML (Learning.Qlik.com)

Machine learning with Qlik AutoML (Help.Qlik.com)

Qlik AutoML on Qlik Cloud - sample data

Qlik Continuous Classroom AutoML courses

Click here to see video transcript

Join Qlik Support's office-hours, recorded live, where our experts answer your questions and give more insight into our data analytics products and features. This month's topic talk is Qlik Sense Enterprise Monitoring and Observability.

Questions:

• 03:38 – Where can I find the best monitoring tools to use?
• 09:44 – How can we see performance log info in real time?
• 15:16 – Any plans to implement tools like butler in Qlik for live monitoring?
• 16:24 – Which third party dashboard would you suggest to monitor users' activity?
• 12:12 – Where to find documentation for the Qlik Cloud Monitoring apps?
• 29:09 – What monitoring is possible with QSDA Pro in Qlik Cloud?
• 35:30 – Can Node graph (except Qlik lineage connector) be used anymore?
• 38:43 – How to monitor a multi-node deployment that includes QlikView and QAP?
• 41:44 – Will there be an app that might monitor QMC change logs?
• 44:03 – Is there any kind of threshold alerts that you might be able to set?

Resources:

Qlik Sense Enterprise Scalability Tools 

Monitoring & Observability In Qlik Sense on Windows 

Optimizing Performance for Qlik Sense Enterprise 

Optimizing Qlik Sense SaaS Apps with App Analyzer  

Qlik Sense Admin Playbook 

Setting up Butler SOS 

App Metadata Analyzer 

Telemetry Dashboard for Qlik Sense 

Grafana: The open observability platform | Grafana Labs 

Prometheus 

Elastic Stack: Elasticsearch, Kibana, Beats & Logstash | Elastic 

Datadoghq 

Entitlement Analyzer QSE 

QSDA Pro 

Node Graph 

Did we answer your question? Let us know by clicking the like button!

Click here for video transcript

This Techspert Talks session addresses:

• Monitoring multi-node activity
• Centralized metrics collection
• Demo of available tools

• 00:00 – Intro
• 01:19 - Overview of multi-node architecture
• 02:04 - Butler SOS architecture
• 03:24 - Grafana Loki architecture
• 05:20 - Butler SOS demo
• 11:32 - Loki with Grafana demo
• 16:30 - Selenium IDS tool
• 17:53 - New Relic Demo
• 19:49 - Q&A: What about data model and app optimization?
• 20:16 - Q&A: What security issues are there?
• 23:04 - Q&A: What metrics should we be monitoring?
• 24:06 - Q&A: Can this be done with the Operations Monitor app?
• 25:03 - Q&A: How to set this up?
• 25:51 - Q&A: Are these tools free and publicly available?
• 26:26 - Q&A: Will these tool work with QlikView?
• 26:50 - Q&A: Can you measure App response times?

Resources:

Optimizing Performance for Qlik Sense Enterprise

Qlik Sense Enterprise deployment examples

Butler SOS

Setting up Butler SOS

Grafana Loki | Grafana Loki documentation

Docker + Compose

Portainer for Docker management

Selenium IDE for user session replay

Webmin for server admin

Click here to see video transcript

Join Qlik Support's office-hours, recorded live, where our experts answer your questions and give more insight into our data analytics products and features. This month's topic talk is New to Qlik Cloud.

Questions:

• 04:26 - Where can I learn about how to create a dashboard?
• 07:56 - What is the best way to migrate apps?
• 09:40 - What is a good practice to organize QVDs or csv-files?
• 11:00 - When will the console usability and functionality be improved?
• 12:27 - How does Section Access work in the cloud?
• 13:37 - Is there an API Endpoint for extracting tenant logs?
• 15:53 - Is there any Qlik NPrinting equivalent for the Qlik Sense Enterprise?
• 17:30 – Can we create an onboarding custom page, especially for larger user groups?
• 19:41 – How can we reload at shorter intervals than an hour?
• 22:41 - How do I choose the kind of space to use?
• 24:29 - Are there plans to enhance subscriptions or bring NPrinting to cloud?
• 25:42 – Are there pivot table column size fixes in the cloud?
• 26:50 – How do we get access to the QMC?
• 27:57 - Is it possible to carry over filter with variables from different datasets?
• 30:07 - Is there a monitoring app that will monitor the user's ""clicks""?
• 31:55 - How to prevent users from uploading datafiles?
• 34:23 – How to regain control over updates?
• 36:43 – Where to learning about the Qlik Application Automation?
• 37:20 - Any way user can reload manually?
• 37:57 - Will Qlik Cloud offer out of the box version control for the apps?
• 38:43 - Can Mac users on Chrome browser export to csv/excel data from Qlik?
• 39:50 - Is there a way to send mail from Qlik Cloud?
• 41:35 - Why Qlik Forts will be retired in the next months?
• 42:50 – How to publish app to a shared space for specific users?
• 43:58 - How is it possible to see if a field is used in any dashboard?
• 44:35 – How to allow superusers to create sheets but not upload new data?
• 46:25 - Is there a possibility to use FTP or FTPS in Qlik Cloud?
• 47:26 - Why 'GetFieldSelections' do not return the values in the selection order?
• 48:17 - Is there audit users selections made in an app?
• 49:26 - Can we connect to Oracle on-prem databases?
• 50:22 – Can you share the license / permissions chart?
• 51:00 – I’m getting a "Connection TimedOut" error. What would be the cause?
• 52:00 - How to find if it is used in some object in some dashboards, not for lineage?
• 53:25 – How to publishing a whole Qlik Cloud app for public access?

Resources:

How to use Qlik-CLI to Migrate Apps to Qlik Sense SaaS

Qlik Ideation 

Learning.qlik.com

How to: task chaining with Qlik Application Automation

When will there be a full Cloud version of NPrinting?

Creating a variable

Analyzing lineage for apps and datasets

Embed content using iframes and anonymous access

Did we answer your question? Let us know by clicking the like button!

Click here for video transcript

Join Qlik Support's office-hours, recorded live, where our experts answer your questions and give more insight on our data analytics products and features. This month's topic talk is Qlik Sense Migration to Qlik Cloud.

Questions:

• 00:03:34 -- Where can we learn more about using apps in the Cloud?
• 00:07:15 -- What is the time frame to allow Subscriptions to email an Excel formatted attachment?
• 00:08:01 -- When will Qlik be able to support the movement of Bookmarks, Personal Sheets, and Community sheets to cloud when doing a migration?
• 00:09:22 -- If QVDs/QVFs are encrypted on-prem, will there be issues when migrating to SaaS?
• 00:11:50 -- Is there a way to ensure that named ownership of all sheets, including private sheets, is preserved when migrating from on-prem to Cloud?
• 00:12:37 -- What is the best way to move apps from on-prem to the cloud?
• 00:13:55 -- Is there any way to bulk download script execution and user sessions logs related to our Qlik Cloud tenant for ingestion and analysis in custom dashboards?
• 00:16:35 -- What are security differences between Sense (behind a Company firewall) and SAAS? Are there 0-Trust solutions for company external Users to only see certain things in the SAAS environment?
• 00:16:52 -- If one uses multiple Tenants to solve this what is the cost and effort of maintaining multiple tenants in SAAS?"
• 00:20:07 -- When is NPrinting going to be available on SaaS?
• 00:21:25 -- Is bring your own key implemented?
• 00:23:06 -- What are best practices for migrating detailed security concepts from Qlik Sense on Windows to the Cloud? Is there a roadmap to extend the current options in terms of security?
• 00:24:25 -- The migration topic continuous classroom is available only for users with a subscription?
• 00:25:07 -- Do you recommend using Data Transfer of Qlik Data Gateway when migrating apps to Qlik Sense SaaS?
• 00:28:05 -- Is there a recommended framework or to do list for a successful migration?
• 00:29:30 -- How can the print function be integrated analogously to NPrinting?
• 00:32:00 -- The reassignment of sheets is a big issue. You can import sheets by pulling the binary, but then you cannot reassign to those users.
• 00:33:13 -- How would you approach migrating from QlikView to Qlik Sense SaaS? Most of the documentation I find all relate to Qlik CM to Qlik SaaS or QlikView to Qlik CM.
• 00:35:44 -- How to use functionalities like comments, alerting, pin on home page etc. with extension objects like VizLib?
• 00:37:20 -- Sometimes, our customers’ needs to distribution app from on prem to SaaS. The prerequisites to do that is the SLKs are the same on both environments. But, in my case the environments, the SLK is not the same, in my on-prem has SLK with multi-cloud enabled. In this case can I distribute Apps to SaaS?
• 00:39:21 -- Is there a plan to allow exporting Storyboards to PDFs in SaaS, as you can do in Enterprise?
• 00:40:40 -- I wonder about QVD PATH including folders and subfolder. Do you have a file notation or AI utility or documentation to transform i.e. folder_subfolder_pippo.qvd to folder\subfolder\pippo.qvd on QCS storage?
• 00:41:55 -- Will Qlik cloud support access to on-prem files, MS SQL databases, API calls?
• 00:43:21 -- What happens when we run the provided bat file script after generating the CSV files. Does the app (which had been selected for migration) go to the personal space or managed space or both?"
• 00:44:06 -- On prem, when a professional user was leaving the company, I was using the QMC App Objects section to give myself ownership of their sheets to revise them and assign the useful ones to their colleagues. How can I do this on SaaS? 00:45:50 -- Will Qlik cloud support section access?
• 00:46:34 -- If there is a data governance need in our business (e.g. data sovereignty rules preventing data being moved/processed outside of our region) can we still migrate to Qlik cloud?
• 00:48:10 -- For 3rd party extensions we're currently able to test them in new versions in our Enterprise test environment before we upgrade. In Cloud is it possible an extension could unexpectedly break since the upgrades happen automatically?
• 00:49:23 -- We have some specific use case On-premise on Qlik NPrinting. We generate multiple broadcasts on Excel. What can be a good solution to move it on Qlik Cloud? (We already have QlikAutomation and look a bit Qlik Enterprise reporting).
• 00:51:58 -- Most customers use integration with IDP, mainly Azure AD, but since Microsoft has disabled simple authentication, some automation and reporting functions do not work due to the need for multifactor authentication. Is there a road map for this?
• 00:54:40 -- Is there a tool recommended for migration if any?
• 00:55:27 -- Users need to duplicate public sheets (private sheets made public) to have their private sheets again after migrating an apps to cloud, is there in easiest way?

Did we answer your question? Let us know by clicking the like button!

Click here for video transcript

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

Join Qlik Support's office-hours, recorded live, where our experts answer your questions and give more insight on our data analytics products and features. This month's topic talks about Qlik Cloud Reporting capabilities and roadmap.

Questions:

• 24:00 - Will NPrinting receive the same new features as Qlik Cloud reporting?
• 24:51 - For data alerts, is this at a load execution level or object level, or both?
• 25:42 - Export to csv?
• 26:16 - Are there API capabilities for native export of data and images?
• 27:00 - Can you create a hidden sheet just for reporting purposes?
• 28:10 - Can slides, sheets and objects be modular? show/hide based on conditions?
• 28:50 - How do the headers and footers work? is it an easy customization?
• 29:55 - Plan to change Qlik Alerting from a value-add product for client managed?
• 30:25 - Can we default all reporting app fonts to Arial at a QMC level?
• 30:58 - Is there any limitation of volumetric? ppt size?
• 32:19 - What type of report distribution methods will be available other than push to email?
• 32:55 - PixelPerfect (ish) web-based PDF Report design?
• 33:50 - In Hybrid deployments, would both solutions be needed?
• 34:42 - Are multi-page tables supported by reporting in cloud?
• 35:45 - When we add a note, who can see the notes? Everyone or only the one who got tagged?
• 36:45 - What is the estimated release date of a full-fledge NPrinting replacement in Cloud?
• 38:12 - Object Font style?
• 39:20 - Will the add-on also be available for word or power point? may be other formats?
• 41:07 - On Multi-cloud Environment, is it possible to RUN Reporting on Synchronized PRES (cloud distributed)?
• 42:07 - How to achieve the N-printing report designer tool capabilities into Qlik Cloud?
• 42:51 - If the pixel perfect design in Qlik Sense sheet will be released?
• 44:15 - Does cloud reporting support multiple app sheets within one report page?
• 45:30 - The new report add on will have a basic (included) version for current users and then an expanded (licensed) version?

Did we answer your question? Let us know by clicking the like button!

Click here for video transcript

Join Qlik Support's office-hours, recorded live, where our experts answer your questions and give more insight on our data analytics products and features. This month's topic talks about navigating Qlik Support's resources!

Questions:

• 10:38 Where to find self service resources.
• 17:27 What are Qlik Fix videos?
• 23:38 Where to post what in the Qlik Community forums.
• 26:46 Difference between Qlik Support and Professional Services
• 30:06 How to contact Qlik Support.
• 32:01 Learn more about Qlik's Chat Bot.
• 34:47 When are live chat agents available?
• 35:00 What to do if no live chat agent is available.
• 36:25 Resources requiring Qlik Community login
• 38:32 What is the difference between Severity 1, 2, and 3?
• 39:33 What to do if a production environment is down?
• 42:50 When to engage with your Qlik Partner
• 45:20 What else can you find on the Qlik Community?
• 49:32 Where to leave product suggestions and ideas.
• 50:04 Get to know the Qlik Gallery; share and explore Qlik Sense Apps
• 50:52 All Qlik Resources in one space

Transcript Attached.

Did we answer your question? Let us know by clicking the like button!

This Techspert Talks session covers:

• Full Load vs. Reload
• Examining Task Options
• Configuration Best Practices

00:00 – Intro

00:58 - Full Load tasks

02:26 - Adjusting load priority

04:13 - Loading LOB fields

05:43 - Full Load Passthrough Filter

09:58 - Using Insert Date and Update Date

13:42 - Parallel Loading

15:28 - Setting up Notifications

18:23 - Q&A: Can Replicate do compressions?

18:45 - Q&A: What can affect performance?

20:03 - Q&A: How does metadata affect performance?

20:19 - Q&A: Is Replicate compatible with Oracle Data Bricks?

21:09 - Q&A: What if a task gets "Max Row Size Limit"?

21:58 - Q&A: Are Oracle OCI Plugable Databases supported?

22:39 - Q&A: What is the recommended version of Qlik Replicate?
23:59 - Q&A: How to limi or filter notifications?

24:58 - Q&A: How can you restart a stopped task?

25:49 - Q&A: Is Qlik Replicate free with Qlik Cloud?

26:11 - Q&A: How to change the Primary Key field?

27:21 - Q&A: How to investigate task latency?

28:15 - Q&A: What kind of hardware helps performance?

28:47 - Q&A: How to adjust segments to improve load performance?

Q&A:

Q: If I have 10 tables in a task, could I select only 1 table for a full load or does it have to be managed via a separate task?

A: Reload of a specific table is possible from the monitor screen. The whole task/all tables will reload at the task level.

Q: What is the best way to debug the CDC apply changes process?

A: Review the Troubleshooting Qlik Replicate Latency with Kelly Hobbs. She details this process.

Q: Do lookups affect latency of tables?

A: Yes, there is some overhead when the task issues the select statement on the source in order to get the data.

Q: If our target database is used by another development, will it be affected? Is there any possibility of data deadlock?

A: Yes, if the other application ever issues a lock on the target table rows that could cause an error for the Replicate task.

Q: Is there a way to setup a Notification that sends only a few e-mails when a Task has an Error or Task Stops because it can't connect to the Target and needs to stop? My experience has been that it fills my e-mail inbox with hundreds of pages.
A:  You can set up rules in your mail, or send notifications to the event viewer and have a program that scans the event viewer and sends emails based on the logic coded into the program.

Q: What happens in Replicate on a delete?

A: The delete will remove the record from the target. We do have a way to do a soft delete that will keep the record and mark it as deleted. Check out this article: Filter Deletes in Replicate

Q: The options available for tuning LOB handling when we use Log Stream as source as opposed to native application type source endpoint, are limited. So is there any way to explicitly pass the config options in task JSON configuration?

A: The LOB limitations on the LOG stream are by design and cannot be overridden.

Resources:

Customizing Data with Qlik Replicate

Adding Update Date field

Adding Table level Insert Date

Qlik Replicate Supported End Points

Troubleshooting Qlik Replicate Latency

Click here for video transcript

This Techspert Talks session covers:
- Different types of latency
- How to identify the bottleneck
- Configuration Best Practices

00:00 – Intro

00:56 - Replicate Overview

01:46 - Defining different types of latency

04:04 - Overview of the task

05:12 - Review bad task Settings

06:42 - Monitoring Latency in Replicate

08:54 - How to add performance info to logs

10:16 - How to add notifications

11:20 - Best Practice Settings

13:37 - Troubleshooting

Resources:

Troubleshooting Qlik Replicate Latency and Performance Issues

Qlik Replicate Troubleshooting

How to analyze a Qlik Replicate log

Click here to see video transcript

This Techspert Talks session covers:
- How authentication works
- Configuring your own IDP
- Resolving common issues

00:00 – Intro

01:06 - Authentication Workflow

03:37 - Setup IdP from Okta

06:41 - Setup IdP in Qlik Cloud

09:36 - Create configuration and Validation

11:42 - Recovery URL

12:13 - Importing Groups & Managing Spaces

13:40 - Troubleshooting expired Secret key

14:45 - Troubleshooting Groups

20:05 - Troubleshooting Validation Failure

21:30 - Q&A: How do we connect to users in Google?

22:02 - Q&A: How to set Azure token not expire?

22:46 - Q&A: Do we need to configure AD in tenant for multi-cloud?

23:38 - Q&A: Where is documentation for setting up SSO with ADFS?

24:26 - Q&A: Can multi-cloud use Google authentication?

25:08 - Q&A: Can the same license be used in client-managed and Qlik Cloud?

25:45 - Q&A: Where is documentation for setting up SSO with Ping Federate?

26:20 - Q&A: Can you login with Qlik ID after setting up 3rd party IDP?

26:59 - Q&A: How to map users from old IdP to new IdP?

27:33 - Q&A: How to setup 2-factor authentication?

27:58 - Q&A: Will Email Verified Override create duplicate users?

28:52 - Q&A: How to restrict access to groups?

29:49 - Q&A: Can we connect to multiple Azure IdPs at once?

30:17 - Q&A: Is it possible to use Azure AD and still have manual users?

Resources:

Qlik Cloud: The provided client secret keys are expired. Visit the Azure Portal to create new keys for your app

Qlik Sense SaaS: How to verify group information returned by Azure AD Graph API

Qlik Sense: How to request an OIDC token manually and check if correct attributes are included (PowerShell)

Using Active Directory Federation Services (ADFS) as an IDP for Qlik Cloud

Click here for video transcript