Blogs

Upgrade advisory for Qlik Sense on-premise November 2024 through November 2025: ...

Edit January 21st 2026: Updated the title and content to include the November 2024 release During recent testing, Qlik has identified an issue that can occur after upgrading Qlik Sense on-premise to specific releases. While the upgrade completes successfully, some environments may experience problems with ODBC-based connectors after the upgrade. The issue is upgrade path dependent and relates to connector components that are included as part of t... Show More

Edit January 21st 2026: Updated the title and content to include the November 2024 release

During recent testing, Qlik has identified an issue that can occur after upgrading Qlik Sense on-premise to specific releases. While the upgrade completes successfully, some environments may experience problems with ODBC-based connectors after the upgrade.

The issue is upgrade path dependent and relates to connector components that are included as part of the Qlik Sense client-managed installation.

The advisory applies to the following releases:

Qlik Sense Enterprise on Windows November 2024
Qlik Sense Enterprise on Windows May 2025
Qlik Sense Enterprise on Windows November 2025

Recommendation: After upgrading Qlik Sense on-premise, verify your connector functionality as part of your post-upgrade checks.

How can I identify if I am affected?

The issue can typically be identified by files being missing after the upgrade. In this example, the Athena connector is not working, and the following file is missing:

C:\Program Files\Common Files\Qlik\Custom Data\QvOdbcConnectorPackage\athena\lib\AthenaODBC_sb64.dll

In this example, all ODBC connectors stopped working:

C:\Program Files\Common Files\Qlik\Custom Data\QvOdbcConnectorPackage\QvxLibrary.dll

With the QvxLibrary.dll missing, both existing and newly created ODBC connections will fail.

How do I resolve the issue?

A fix will be delivered in upcoming patches. Stay up to date with the most recent version by reviewing our Release Notes.

Workaround

If your connectors have been impacted by this upgrade, rollback your ODBC connector package to the previously working version based on a pre-update backup. See How to manually upgrade or downgrade the Qlik Sense Enterprise on Windows ODBC Connector Packages for details.

The workaround is intended to be temporary. Apply the fixed Qlik Sense Enterprise on Windows patch for your respective version as soon as it becomes available.

If you are unable to perform a rollback, please contact Support.

If you have any questions, we're happy to assist. Reply to this blog post or take your queries to our Support Chat.

Thank you for choosing Qlik,
Qlik Support

Show Less

3

1858

Community News

Community Updates & What to Explore Next

Some more January updates!

0

38

Subprocessors List

Qlik and Talend Subprocessors - Version 6.9 - 28th January 2026

Version 6.9 Current as of: 28th January 2026 Qlik and Talend, a Qlik company, may from time to time use the following Qlik and Talend group companies and/or third parties (collectively, “Subprocessors”) to process personal data on customers’ behalf (“Customer Personal Data”) for purposes of providing Qlik and/or Talend Cloud, Support Services and/or Consulting Services. Qlik and Talend have relevant data transfer agreements in place with the Subp... Show More

Version 6.9 Current as of: 28th January 2026

Qlik and Talend, a Qlik company, may from time to time use the following Qlik and Talend group companies and/or third parties (collectively, “Subprocessors”) to process personal data on customers’ behalf (“Customer Personal Data”) for purposes of providing Qlik and/or Talend Cloud, Support Services and/or Consulting Services.

Qlik and Talend have relevant data transfer agreements in place with the Subprocessors (including group companies) to enable the lawful and secure transfer of Customer Personal Data.

You can receive updates to this Subprocessor list by subscribing to this blog or by enabling RSS feed notifications.

Third party subprocessors for Qlik Cloud

Third Party	Location of processing (e.g., tenant location)	Service Provided/Details of processing	Address of contracting party	Contact
Amazon Web Services (AWS)	See Qlik Cloud locations at: https://www.qlik.com/us/regions	Qlik Cloud is hosted through AWS	Amazon Web Services, Inc. 410 Terry Avenue North, Seattle, WA 98109-5210, U.S.A	AWS AWS Privacy
MongoDB	See Qlik Cloud locations at: https://www.qlik.com/us/regions	Any data inputted into the Notes feature in Qlik Cloud	Mongo DB, Inc. 229 West 43rd St., New York, NY 10036 USA	MongoDB
Third party subprocessors for Qlik mobile device apps
Google Firebase	United States	Push notifications	Google LLC 1600 Amphitheatre Parkway Mountain View California United States	Google

Third party subprocessors for Talend Cloud

Third Party	Location of processing (e.g., tenant location)	Service Provided/Details of Processing	Address of contracting party	Contact
Amazon Web Services (AWS)	See Talend Cloud locations at: https://www.qlik.com/us/regions	These Talend Cloud locations are hosted through AWS	Amazon Web Services, Inc. 410 Terry Avenue North, Seattle, WA 98109-5210, U.S.A.	AWS AWS Privacy
Microsoft Azure	See Talend Cloud locations at: https://www.qlik.com/us/regions	These Talend Cloud locations are hosted through Microsoft Azure	Microsoft Corporation 1 Microsoft Way, Redmond, WA 98052, USA	Microsoft Enterprise Service Privacy Microsoft Corporation 1 Microsoft Way Redmond, Washington 98052 USA
MongoDB	See Talend Cloud locations at: https://www.qlik.com/us/regions	Any data inputted into the DataPrep and Stewardship modules of Talend Cloud. Hosted in the same region as the customer’s Talend Cloud environment on AWS or Microsoft Azure, as selected by the customer.	Mongo DB, Inc. 229 West 43rd St., New York, NY 10036 USA	MongoDB

Third party subprocessors for Qlik and Talend Support Services and/or Consulting Services

The vast majority of Qlik’s support data that it processes on behalf of customers is stored in Germany (AWS). However, in order to resolve and facilitate the support case, such support data may also temporarily reside on the other systems/tools below.
Third Party	Location of processing (e.g., tenant location)	Service Provided/Details of processing	Address of contracting party	Contact
Amazon Web Services (AWS)	Germany	Support case management tools	Amazon Web Services, Inc. 410 Terry Avenue North, Seattle, WA 98109-5210, U.S.A.	AWS AWS Privacy
Salesforce	UK	Support case management tools	Salesforce UK Limited Village 9 Floor 26 Salesforce Tower 110 Bishopsgate London, UK EC2N 4AY	Salesforce
Microsoft	United States	Customer may send data through Office 365	Microsoft Corporation One Microsoft Way, Redmond, WA 98052 USA	Chief Privacy Officer One Microsoft Way, Redmond, WA 98052 USA
Ada	Germany	Support Chatbot	Ada Support 371 Front St W, Unit 314 Toronto, Ontario M5V 3S8 CANADA	Ada
Persistent	India	R&D Support Services	2055 Laurelwood Road Suite 201 Santa Clara, California 95054 USA	Persistent
Atlassian (Jira Cloud)	Germany, Ireland (Back-up)	R&D support management tool	350 Bush Street Floor 13 San Francisco, CA 94104 United States	Atlassian
Stretch Qonnect APs	Denmark	2nd line support for the Qlik Analytics Migration Tool	Kompagnistræde 21 1208 Copenhagen Denmark	Martin Sahlin

Affiliate Subprocessors for Qlik and Talend

Affiliate Subprocessors These affiliates may provide services, such as Consulting or Support, depending on your location and agreement(s) with us. Our Support Services are predominantly performed in the customer’s region: EMEA – France, Sweden, Spain, Israel; Americas – USA; APAC – Japan, Australia, India.
Subsidiary Affiliate	Location of processing (e.g., tenant location)	Service Provided/Details of Processing	Address of contracting party	Contact
QlikTech International AB	Sweden	These affiliates may provide services, such as Consulting or Support, depending on your location and agreement(s) with us. Our Support Services are predominantly performed in the customer’s region: EMEA – France, Sweden, Spain, Israel; Americas – USA; APAC – Japan, Australia, India.	Scheelevägen 26 223 63 Lund Sweden	DPO
QlikTech Nordic AB	Sweden			DPO
QlikTech Latam AB	Sweden
QlikTech Denmark ApS	Denmark		Dampfaergevej 27-29, 5th Floor 2100 København Ø Denmark
QlikTech Finland OY	Finland		Simonkatu 6 B 5th Floor FI-00100 Helsingfors Finland
QlikTech France SARL, Talend SAS	France		93 Ave Charles de Gaulle 92200 Neuilly Sur Seine France
QlikTech Iberica SL (Spain)	Spain		"Blue Building", 3rd Floor Avinguda Litoral nº 12-14 08005 Barcelona Spain
QlikTech Iberica SL (Portugal liaison office), Talend Sucursal Em Portugal	Portugal
QlikTech GmbH	Germany		Joseph-Wild-Str. 23 81829 München Germany
QlikTech GmbH (Austria branch)	Austria		Am Euro Platz 2, Gebäude G A-1120, Wien, Austria
QlikTech GmbH (Swiss branch)	Switzerland		c/o Küchler Treuhand Brünigstrasse 25, CH-6055 Alpnach Dorf Switzerland
QlikTech Italy S.r.l.	Italy		Piazzale Luigi Cadorna 4 20123 Milano (MI)
QlikTech Netherlands BV	Netherlands		Evert van de Beekstraat 1-122 Building B, 6th Floor 1118 CL Schiphol
QlikTech Netherlands BV (Belgian branch)	Belgium		Culliganlaan 2D 1831 Diegem
Blendr NV	Belgium		Bellevue Tower Bellevue 5, 4th Floor, Ledeberg 9050 Ghent Belgium
QlikTech UK Limited	United Kingdom		1020 Eskdale Road, Winnersh, Wokingham, RG41 5TS United Kingdom
Qlik Analytics (ISR) Ltd.	Israel		1 Atir Yeda St, Building 2 7th floor 4464301, Kfar Saba Israel
QlikTech International Markets AB (DMCC Branch)	United Arab Emirates		AB (DMCC Branch) JBC 3 Building, Cluster Y 3rd Floor, Office 301 P.O. Box 120115 Jumeirah Lake Towers Dubai
Qlik Business Solutions Company	Kingdom of Saudi Arabia		6629 King Abdul Aziz, District King Salman, Riyadh, Kingdom of Saudi Arabia
QlikTech Inc.	United States		211 South Gulph Road Suite 500 King of Prussia, Pennsylvania 19406
QlikTech Corporation (Canada)	Canada		1133 Melville Street Suite 3500, The Stack Vancouver, BC V6E 4E5 Canada
QlikTech México S. de R.L. de C.V.	Mexico		c/o IT&CS International Tax and Consulting Service San Borja 1208 Int. 8 Col. Narvate Poniente, Alc Benito Juarez 03020 Ciudad de Mexico Mexico
QlikTech Brasil Comercialização de Software Ltda.	Brazil		51 – 2o andar - conjunto 201 Vila Olímpia – São Paulo – SP Brazil
QlikTech Japan K.K.	Japan		105-0001 Tokyo Toranomon Global Square 13F, 1-3-1. Toranomon, Minato-ku, Tokyo, Japan
QlikTech Singapore Pte. Ltd.	Singapore		9 Temasek Boulevard Suntec Tower Two Unit 27-01/03 Singapore 038989
QlikTech Hong Kong Limited	Hong Kong		Unit 19 E Neich Tower 128 Glouchester Road Wanchai, Hong Kong
Qlik Technology (Beijing) Limited Liability Company, Talend China Beijing Technology Co. Ltd.	China		51-52, 26F, Fortune Financial Center, No. 5 Dongsan Huanzhong Road, Chaoyang district, Pekin / Beijing, 100020 China
QlikTech India Private Limited, Talend Data Integration Services Private Limited	India		“Kalyani Solitaire” Ground Floor & First Floor 165/2 Krishna Raju Layout Doraisanipalya Off Bannerghatta Road, JP Nagar, Bangalore 560076
QlikTech Australia Pty Ltd	Australia		McBurney & Partners Level 10 68 Pitt Street Sydney NSW 2000 Australia
QlikTech New Zealand Limited	New Zealand		Kensington Swan 40 Bowen Street Wellington 6011 New Zealand

In addition to the above, other professional service providers may be engaged to provide you with professional services related to the implementation of your particular Qlik and/or Talend offerings; please contact your Qlik account manager or refer to your SOW on whether these apply to your engagement.

Qlik and Talend reserve the right to amend its products and services from time to time. For more information, please see www.qlik.com/us/trust/privacy and/or https://www.talend.com/privacy/.

Show Less

5

59960

Product Innovation

Write Table now available in Qlik Cloud Analytics

Introducing Write Table a simple, interactive way for users to work directly with their data inside their analytics apps

18

15184

Product Innovation

Qlik Sense November 2025 (Client-Managed) now available!

What’s New & What It Means for YouWe’re excited to announce the November 2025 release of Qlik Sense Enterprise on Windows. This update brings enhancements across app settings, visualizations, dashboards, and connectors making your analytics smoother, more powerful and easier to maintain. Below is a breakdown of the key features, how your teams – analytics creators, business users, data integrators and administrators – can benefit, and some practi... Show More

What’s New & What It Means for You

We’re excited to announce the November 2025 release of Qlik Sense Enterprise on Windows. This update brings enhancements across app settings, visualizations, dashboards, and connectors making your analytics smoother, more powerful and easier to maintain. Below is a breakdown of the key features, how your teams – analytics creators, business users, data integrators and administrators – can benefit, and some practical next-steps to get ready.

Show Less

8

3380

Support Updates

Qlik Replicate and an update on Salesforce “Use Any API Client” Permission Depre...

Dear Qlik Replicate customers, Salesforce announced (October 31st, 2025) that it is postponing the deprecation of the Use Any API Client user permission. See Deprecating "Use Any API Client" User Permission for details. Qlik will keep the OAUT plans on the roadmap to deliver them in time with Salesforce's updated plans. Salesforce has announced the deprecation of the Use Any API Client user permission. For details, see Deprecating "Use Any API ... Show More

Dear Qlik Replicate customers,

Salesforce announced (October 31st, 2025) that it is postponing the deprecation of the Use Any API Client user permission. See Deprecating "Use Any API Client" User Permission for details.

Qlik will keep the OAUT plans on the roadmap to deliver them in time with Salesforce's updated plans.

Salesforce has announced the deprecation of the Use Any API Client user permission. For details, see Deprecating "Use Any API Client" User Permission | help.salesforce.com.

We understand that this is a security-related change, and Qlik is actively addressing it by developing Qlik Replicate support for OAuth Authentication. This work is a top priority for our team at present.

If you are affected by this change and have activated access policies relying on this permission, we recommend reaching out to Salesforce to request an extension. We are aware that some customers have successfully obtained an additional month of access.

By the end of this extension period, we expect to have an alternative solution in place using OAuth.
Customers using the Qlik Replicate tool to read data from the Salesforce source should be aware of this change.

Thank you for your understanding and cooperation as we work to ensure a smooth transition.

If you have any questions, we're happy to assist. Reply to this blog post or take your queries to our Support Chat.

Thank you for choosing Qlik,
Qlik Support

Show Less

3

1022

Qlik Academic Program

Announcing the 2026 class of Qlik Academic Program Educator Ambassadors!

The Qlik Academic Program is proud to announce our 2026 class of Educator Ambassadors. Academic Program Ambassadors are educators who champion the Qlik Academic Program at their universities and beyond, with a passion for preparing students for the data driven workplace. These individuals are some of our most active participants of the Qlik Academic Program who fully utilize the free software, training resources and qualifications that we provide... Show More

The Qlik Academic Program is proud to announce our 2026 class of Educator Ambassadors.

Academic Program Ambassadors are educators who champion the Qlik Academic Program at their universities and beyond, with a passion for preparing students for the data driven workplace. These individuals are some of our most active participants of the Qlik Academic Program who fully utilize the free software, training resources and qualifications that we provide to university students and educators. The members of our 2026 class are:

Marcin Stawarz

Blerim Emruli

Dr. Javier Leon

Dr. K. Kalaiselvi

Katherine Taylor Pearson

Angelika Klidas

Dr. Terrence Perera

Chee-wai Ho

Dr Ravi Aavula

Alexander Flaig

Gabriel Navassi

Daniel O'Leary

Angel Monjarás

Marisa Sánchez

Priscila de Jesus Papazissis Paolinelli

Manikant Roy

Meet the Qlik Academic Program Professor Ambassadors for 2026

We are thrilled to be recognizing the efforts of these individuals to help the Qlik Academic Program to achieve its mission - to create a data literate world, one student at a time. Each ambassador has been selected through a self-nominated application process, where they were required to answer various questions covering their motivations for becoming an ambassador, and to evidence their passion for upskilling their students in analytics over the past 12 months. This year, we are excited to select another 16 ambassadors, 3 new ones and 13 returning ambassadors whose efforts continued to impress us. By way of thanks for their efforts our ambassadors will receive exclusive benefits such as webinars and discussion groups with Qlik leaders, opportunities to showcase their experience with the Qlik Academic Program and the chance to grow their network with other educators across various fields and geographies.

Throughout 2026 our ambassadors will continue their advocacy for the Qlik Academic Program and help us to reach even more students and educators with our free resources. Stay tuned over the coming months for more in-depth profiles on each of our ambassadors, and get to know who they are, what they teach and why they are so passionate about bridging the data literacy skills gap!

Learn more about the program and how to apply for future classes.

Show Less

2

51

Support Updates

Decommissioning the legacy support portal (support.qlik.com) January 23rd, 2026

The legacy Qlik Support portal (previously known as support.qlik.com) has been decommissioned on the 23rd of January, 2026. How will this affect me? You will be largely unaffected. Access to our existing and up-to-date portal is not impacted by this change, meaning chat, knowledge, and your support cases remain exactly where you expect them to. Did you know? We're launching additional My Account features for customerportal.qlik.com. Read more her... Show More

The legacy Qlik Support portal (previously known as support.qlik.com) has been decommissioned on the 23rd of January, 2026.

How will this affect me?

You will be largely unaffected. Access to our existing and up-to-date portal is not impacted by this change, meaning chat, knowledge, and your support cases remain exactly where you expect them to.

Did you know? We're launching additional My Account features for customerportal.qlik.com. Read more here in Your Qlik Customer Portal My Account features.

I used to access my licenses on the old portal. Where do I go now?

If you previously accessed your legacy (perpetual) Qlik licenses and control numbers on support.qlik.com, your next stop is our Support Chat. A live agent will share the license, control number, and LEF with you on request.

Thank you for choosing Qlik,
Qlik Support

Show Less

1

340

Qlik Academic Program

How Qlik Academic Program is shaping careers in Analytics

In today’s job market, data literacy and analytics skills are among the most sought-after capabilities employers look for. To help prepare students for meaningful careers in analytics, business intelligence, and data science, Qlik’s Academic Program is making waves in universities across India and the Asia Pacific — providing students with hands-on experience, real tools, and industry-recognized qualifications that boost employability and spark i... Show More

In today’s job market, data literacy and analytics skills are among the most sought-after capabilities employers look for. To help prepare students for meaningful careers in analytics, business intelligence, and data science, Qlik’s Academic Program is making waves in universities across India and the Asia Pacific — providing students with hands-on experience, real tools, and industry-recognized qualifications that boost employability and spark innovation.

Show Less

2

54

Support Updates

Qlik Cloud Analytics: Scheduled subscription reports creation issue January 14th...

An update deployed to Qlik Cloud Analytics on January 14th,  2026, impacted the creation and scheduling of end user subscriptions (see Scheduling reports with subscriptions). Any selections made (to reduce the distributed data set) before creating the subscription were not properly saved. As a result, the subscriptions are executed without any filters applied. The upgrade has since then been reverted (January 19th). This does not impact in-app re... Show More

An update deployed to Qlik Cloud Analytics on January 14th,  2026, impacted the creation and scheduling of end user subscriptions (see Scheduling reports with subscriptions). Any selections made (to reduce the distributed data set) before creating the subscription were not properly saved. As a result, the subscriptions are executed without any filters applied.

The upgrade has since then been reverted (January 19th).

This does not impact in-app reporting for traditional burst tasks as documented in In-app reporting with Qlik Cloud Analytics.

What action do I need to take?

Users who created subscriptions during this period (January 14th to 19th) should review their subscriptions and the selections that are stored for the subscription. If the desired data selections are not in place, then the user should remove the current subscription and add a new subscription with the desired selections in place.

To verify if a subscription has selections:

Click the navigation menu (waffle menu)
Go to Analytics
Go to Subscriptions
Select the subscription
In the Details tab, locate the Data field and review the subscription’s Selections

For more information on this feature, see Scheduling reports with subscriptions.

What time frame is affected?

Subscriptions created between:

14th of January 2026 15:47 UTC
to 19th of January 2026 12:10 UTC

If you have any questions, we're happy to assist. Reply to this blog post or take your queries to our Support Chat.

Thank you for choosing Qlik,
Qlik Support

Show Less

2

489

Support Updates

Techspert Talks - Setting up Knowledge Marts for AI

Hi everyone, Want to stay a step ahead of important Qlik support issues? Then sign up for our monthly webinar series where you can get first-hand insights from Qlik experts. Next Thursday, January 29th Qlik will host another Techspert Talks session and this time we are looking at Setting up Knowledge Marts for AI. But wait, what is it exactly?Techspert Talks is a free webinar held on a monthly basis, where you can hear directly from Qlik Techs... Show More

Hi everyone,
Want to stay a step ahead of important Qlik support issues? Then sign up for our monthly webinar series where you can get first-hand insights from Qlik experts.

Next Thursday, January 29th Qlik will host another Techspert Talks session and this time we are looking at Setting up Knowledge Marts for AI.

But wait, what is it exactly?
Techspert Talks is a free webinar held on a monthly basis, where you can hear directly from Qlik Techsperts on topics that are relevant to Customers and Partners today.

In this session we will cover:

Synchronizing data in real time
Connecting to Structured and Unstructured data
Monitoring data quality

Choose the webinar time that's best for you.

The webinar is hosted using ON24 in English and will last 30 minutes plus time for Q&A.
Hope to see you there!!

Show Less

0

182

Explore Qlik Gallery

clay tech_Myfairhotel

clay tech_Myfairhotelclay techThis dashboard provides a month & year–wise comparison of hotel revenue, highlighting key KPIs, room type performance, folio revenue contribution, and business source distribution to quickly track revenue trends and drivers.DiscoveriesSome of the key discoveries from using this app include clear visibility into month-on-month and year-on-year revenue trends, identification of top-performing room types, and understand... Show More

clay tech_Myfairhotel

This dashboard provides a month & year–wise comparison of hotel revenue, highlighting key KPIs, room type performance, folio revenue contribution, and business source distribution to quickly track revenue trends and drivers.

Discoveries

Some of the key discoveries from using this app include clear visibility into month-on-month and year-on-year revenue trends, identification of top-performing room types, and understanding which business sources contribute the most to overall folio revenue.

Impact

This app has helped the business make faster, data-driven decisions by highlighting revenue drivers and gaps, enabling better pricing, channel optimization, and room mix planning to improve overall performance.

Audience

This app is primarily used by hotel management, revenue managers, sales & marketing teams, and finance stakeholders. It is displayed on management review dashboards and is accessed daily/weekly for performance tracking, making it a critical tool for monitoring revenue health and supporting strategic decisions.

Data and advanced analytics

The app leverages consolidated transactional data with time-based comparisons and KPI-driven analytics to uncover trends and patterns. It enables proactive analysis of revenue, room type performance, and business sources, helping the business optimize forecasting, pricing strategies, and overall revenue management.

Show Less

0

64

Design

The New Write Table

The write table was introduced to Qlik Cloud Analytics last month so in this blog post, I will review how it works and how it can be added to an app. The write table looks like the straight table but editable columns can be added to it to update or add data. The updated/added data is visible by other users of the app provided they have the correct permissions. Read more on write table permissions here. Something else to note, if using a touch scr... Show More

The write table was introduced to Qlik Cloud Analytics last month so in this blog post, I will review how it works and how it can be added to an app. The write table looks like the straight table but editable columns can be added to it to update or add data. The updated/added data is visible by other users of the app provided they have the correct permissions. Read more on write table permissions here. Something else to note, if using a touch screen device, is you will have to disable touch screen mode for the write table to work. Looking at the write table for the first time, I found it intuitive and easy to use. Let’s create a write table with some editable columns to see how easy it is.

The write table object can be added to a sheet like any other visualization. Once it is added, columns can be added the same way dimensions and measures are added to a straight table. Below is a small write table with course information including the course ID, course name, instructor and location.

write table.png

To add an editable column from the properties panel, click on the plus sign (+) and select Editable column.

The new editable column will be added. In the properties for the column, the title for the column can be modified and from the show content drop down, manual user input or single selection can be selected. Manual user input will create a free form column that the user can type into. The single selection option will allow me to create a drop-down list of options that the user can choose from.

single selection.png

I will change the title to Course Level and for show content I will select single selection and add three list items by typing the list item and then clicking on the plus sign to add it to the list. The list items will be displayed in the drop-down in the order they are added but can be rearranged by hovering over the list-item and dragging it to the desired position. List-items can also be deleted by hovering over it and clicking the delete icon that appears to the left.

list items.png

When you come out of edit mode, the message below will appear for the editable column prompting you to define a set of primary keys.

Once you click Define, you will see the pop-up below where you can select the column(s) that will be used for the unique primary key. This is necessary to save and map the data entered in the editable column to the data model. I will select the CourseID column as the primary key.

Once this is done, I will see the Course Level column with the drop-down of list-items I added.

Let’s add one more editable column that takes manual user unput and name it Notes.

As I add data or update the editable columns, the cells will be flagged orange to indicate that my edits have not been saved. Once I save the table, they will be flagged green and any new values entered are visible to other users. A cell will be blue if another user is currently making changes to the row, thus locking it. Changes are saved for 90 days in a change store (temporary storage location) provided by Qlik. After 90 days, the data will be deleted. It is also important to note that if an editable column is deleted, the data will be lost. This is also the case if the primary key used for the editable column is removed.

It is possible to retrieve the changes from a change store via the change-stores API or an automation. Using the REST connection and the change-store API, the changes made in a write table can be retrieved and stored in a QVD (if needed for more than 90 days) or added to the data model for use in other analytics. Qlik Automate can also be used to retrieve data from the change-store using the List Current Changes From Change Store block or the List Change Store History block. From there the data can be stored permanently in an external system for later use or used in the automation for another process. Qlik Help offers steps for retrieving data from a change-store.

The write table can make it easy for users to add updates, feedback and important information that may not be available in the data model. Not only can this be done quickly, but it can be immediately visible to other colleagues. Learn more about the write table in the Product Innovation blog along with links to videos and write table FAQs.

Thanks,

Jennell

Show Less

1

337

Explore Qlik Gallery

ClayTech_PortfolioSummary

ClayTech_PortfolioSummaryClayTech SystemThis provides an overall comparison of how different stakeholders are performing across the Indian region. It is intended for those who prefer data and numbers over visual or fancy charts. The analysis highlights spend, onboarding, and activation ratios, helping management clearly identify key performance metrics and critical business gaps. DiscoveriesSome of the discoveries from using this app include: How... Show More

ClayTech_PortfolioSummary

This provides an overall comparison of how different stakeholders are performing across the Indian region. It is intended for those who prefer data and numbers over visual or fancy charts. The analysis highlights spend, onboarding, and activation ratios, helping management clearly identify key performance metrics and critical business gaps.