Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Forums for Qlik Analytic solutions. Ask questions, join discussions, find solutions, and access documentation and resources.
Forums for Qlik Data Integration solutions. Ask questions, join discussions, find solutions, and access documentation and resources
Qlik Gallery is meant to encourage Qlikkies everywhere to share their progress – from a first Qlik app – to a favorite Qlik app – and everything in-between.
Get started on Qlik Community, find How-To documents, and join general non-product related discussions.
Direct links to other resources within the Qlik ecosystem. We suggest you bookmark this page.
Qlik gives qualified university students, educators, and researchers free Qlik software and resources to prepare students for the data-driven workplace.
Regex has been one of the most requested features in Qlik Sense for years, and now it’s finally here.
With this year's May 2025 release, Qlik added native support for regular expressions in both load scripts and chart expressions. That means you can validate formats, extract values, clean up messy text, and more, all without complex string logic or external preprocessing.
In this post, we’ll look at what’s new, how it compares to the old workarounds, and a practical example you can plug into your own app.
Regex (short for Regular Expression) is a compact way to define text patterns. If you’ve used it in Python, JavaScript, or other programming languages, the concept will feel familiar.
Qlik now includes native support for regular expressions with functions that work in load scripts and chart expressions:
MatchRegEx() – check if a value matches a pattern
ExtractRegEx() – extract the first substring that matches
ReplaceRegEx() – search and replace based on a pattern
SubFieldRegEx() – split text using regex as the delimiter
There are also group-based versions (ExtractRegExGroup, etc.), case-insensitive variants (MatchRegExI), and helpers like CountRegEx() and IsRegEx().
Here's where regex saves time:
Pattern-based replacements: Clean or reformat values without chaining multiple functions.
With regex:
If(MatchRegEx(Code, '^[A-Z]{2}-\d{5}$'), 'Valid', 'Invalid') // check format
ExtractRegEx(Text, '\d{5}') // get first 5-digit number
ReplaceRegEx(Field, '\D', '') // strip non-digits
Cleaner logic. Fewer steps. Easier to maintain.
If any of the following sound familiar, regex will help:
Format checks: postal codes, product SKUs, ID numbers.
Data extraction: get domain from email, number from notes, etc.
PII masking: hide parts of a SSN or credit card.
String cleanup: strip unwanted characters, normalize spacing.
Splitting tricky fields: CSV lines with quoted commas, mixed delimiters.
Keep in mind that these functions can be used directly in chart expression, so you can build visuals or filters based on pattern logic, not just static values.
Let’s say you’ve got a bunch of phone numbers like this:
(312) 678-4412
312-678-4412
3126784412
123-678-4412 // invalid: area code starts with 1
312-045-4412 // invalid: exchange starts with 0
312-678-441 // invalid: too short
You want to:
Validate that it’s a proper 10-digit North American number
Standardize the format to (###) ###-####
Here’s how to do it with regex in your load script:
LOAD
RawPhone,
// 1. Strip out anything that's not a digit
ReplaceRegEx(RawPhone, '\D', '') as DigitsOnly,
// 2. Validate: 10 digits exactly, starting with 2–9
If(MatchRegEx(RawPhone, '^\(?[2-9]\d{2}\)?[-.\s]?\d{3}[-.\s]?\d{4}$'),
'Valid', 'Invalid') as Status,
// 3. Standardize format to (###) ###-####
ReplaceRegEx(
ReplaceRegEx(RawPhone, '\D', ''),
'(\d{3})(\d{3})(\d{4})',
'(\1) \2-\3'
) as FormattedPhone
INLINE [
RawPhone
3025557890
(404) 222-8800
678.333.1010
213 888 9999
1035559999
678-00-0000
55577
];
Result:
One pattern replaces multiple conditions and formatting is consistent. This is much easier to maintain and easy to expand if the rules change.
Not sure how to write the pattern?
Tools like regex101.com or regexr.com are great for testing and adjusting before you build in Qlik.
With native regex in Qlik Sense, you can now clean, validate, extract, and transform text with precision without convoluted scripts or third-party tools. It’s a quiet but powerful upgrade that unlocks a ton of flexibility for real-world data.
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.
The Techspert Talks session from December was Unleashing the Qlik Talend Cloud Dynamic Engine.
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:
Hi Qlik Community,
We’re kicking off December with something fun, interactive, and built to bring the entire Community together. The Qlik Community Scavenger Hunt is officially live and will run from December 3–17.
This two-week experience is designed to help you explore new corners of the Community, learn about key resources, and test your eye for detail. Whether you’re a longtime contributor or brand new to Qlik, this is a great way to jump in!
How the Scavenger Hunt Works
We’ve published a dedicated post with everything you need to get started, including all the clues, instructions, and the form to submit your final answer. Each clue leads you to a specific forum or page across the Community where you’ll uncover one hidden letter. Collect all the letters, solve the final phrase, and submit your entry.
Everyone who completes the hunt will be entered into a raffle for a chance to win exclusive Qlik swag.
Holiday Snow on Homepage!
We’ve brought back the snow to the Community homepage. You can toggle the snow off or on through the snow button to the right of the homepage.
That’s all for now! We can’t wait to see how many of you complete the hunt. Good luck, and thank you for being part of the Qlik Community. We’ll be back soon with more updates.
Your Qlik Community Managers,
Sue, Jamie, Nicole, Caleb, and Brett
@Sue_Macaluso @Jamie_Gregory @nicole_ulloa @Brett_Cunningham
Education in Brazil is changing fast, and data skills are becoming more important every day,especially with the rise of AI. That’s why the Qlik Academic Program is gaining so much attention across the country. More universities, teachers, and students are discovering how Qlik can help them learn and grow.
Teachers across Brazil are using Qlik to update their classes and give students a taste of what today’s job market looks like. Whether it’s a workshop, a guest lecture, professor training, a Qlik Sense demo, or a presentation about the Academic Program in São Paulo, Rio de Janeiro, Paraná, Florianópolis, Paraíba, and beyond, the Academic Program offers simple, collaborative, and flexible ways to learn about data.
Brazil has a strong culture of creativity and learning, which aligns perfectly with Qlik’s mission. The Academic Program gives students and teachers free access to high-quality learning materials. Students can explore data, practice real-world skills, and even earn recognized certificates. Teachers also receive ready-to-use resources that make it easy to bring Qlik into their lessons.
As the Qlik Academic Program continues to grow in Brazil, these collaborations represent something bigger than expansion. Whether you're studying in Porto Alegre, teaching in Recife, or researching in Manaus, the goal is the same: to help everyone learn and succeed.
If you want to learn more about how Qlik can support your studies or teaching, visit Qlik Academic Program: Creating a Data-Literate World
Namespaces for REST and Events APIs are being introduced in Qlik Cloud to support the growing number of APIs and services in the platform, and to unlock versioning support in the future. This change makes it easier for you to find, understand, and use Qlik APIs by grouping related resources by context, as well as standardizing the interface for the APIs.
To learn more, see the API namespaces overview page on qlik.dev.
v1 from the path: v1 will be removed from the path to prepare for versioning support in the future.analytics namespace for Analytics-specific resources such as apps, notes, and ODAGs apps.core namespace for platform-wide resources such as users, groups, ip-policies, and roles.Events will adhere to the same namespace rule to avoid conflict of resource names and to match the REST resources. This changes the pattern from com.qlik.v<version>.<eventContext>.<action> to com.qlik.<namespace>.<eventContext>.<action>.
Head to the API namespaces overview page for additional details and examples.
Thank you for choosing Qlik,
Qlik Support
Qlik Data Gateway - Direct Access versions 1.4 and 1.5 are reaching End of Life by January 31st, 2026*.
The original announcement can be read in Direct Access gateway versions 1.4 and 1.5 reaching End of Life by January 31st, 2026.
Both versions will stop working after reaching End of Life. We recommend you plan to upgrade to the latest available version of the currently supported 1.7.x as soon as possible.
For the upgrade procedure, please refer to Upgrading Qlik Data Gateway - Direct Access on Qlik's online help. This page also lists all the significant changes for each version.
The upgrade to 1.7.x from 1.4 or 1.5 has been thoroughly tested, and the process is expected to be smooth. However, please follow the steps carefully and always take a backup before upgrading. It is also worth noting that .NET 8.x is required (from v1.6.6) and will be automatically installed during the upgrade.
Several configuration settings were added in later versions of the Direct Access gateway that may apply to your deployment. Therefore, please review all details in the online help on Configuring and troubleshooting Qlik Data Gateway - Direct Access. Note that most Direct Access gateway settings can be configured in the Qlik Cloud Administration activity center (from v1.7.2).
Always upgrade to the latest version!
If you have questions or need additional assistance, our forums are always open to you, and Support is only a chat away.
Thank you for choosing Qlik,
Qlik Support
* The previously announced date was set for December 31st, 2025, and was later extended until January the following year.
Kristu Jayanti University in India prioritizes graduate employability by equipping students with data skills so that they are career ready. Founded in 1999, the university ranks among India’s top 50 (34th rank), offering programs in arts, sciences, management, and commerce to nearly 15,000 students, supported by 650 staff.
Various initiatives have been successfully initiated by Kristu Jayanti with Qlik such as the Centre of Excellence in Analytics, two Datathons and numerous students getting trained and completing the qualifications and certifications.
Hello Qlik admins and developers,
Previously, the Dropbox API used only long-lived access tokens. These long-lived access tokens have been deprecated since the fall of 2022, and only short-lived access tokens are created. Long-lived tokens remain usable for existing authentications.
The Qlik Dropbox connectors have maintained the use of long-lived access tokens, and it is now time to deprecate these tokens and remove them. We aim to end support for long-lived tokens by October 31, 2025.
Re-authenticate to avoid interruption.
You will not have to take action for connection definitions created in Qlik products released from 2023 and onwards, and which were created or re-authenticated after 2022.
This is applicable to the following scenarios:
If you are using a long-lived access token in a Dropbox connection definition, you must follow the steps below to re-authenticate. This can be done proactively at any time, which will avoid the connections from breaking.
Your connections will stop working once the long-lived access token expires. You can still re-authenticate in the same way at a later time; your connection will be repaired, and your reloads will work again.
Unfortunately, there is no indication showing which type of token is used. However, if you are not sure when the connection was created or last re-authenticated, there is no harm in re-authenticating, regardless of whether it is necessary or not.
To re-authenticate the Dropbox connectors in Qlik Sense, update the connection within the Data load editor, then select Authenticate and follow the on-screen process to retrieve a new Authentication Code. Verify and Save the connection when done.
Re-authenticate via the CanAuthenticate table by selecting to Clear the current Authentication Token, and then Authenticate to get a new Authentication Token. Save and Run when done.
While performing this review of your Dropbox connection definitions, it may also be an opportunity to remove any redundant connection definitions not in use.
If you have any questions, we're happy to assist. Reply to this blog post or start a chat with us.
Thank you for choosing Qlik,
Qlik Support
Several Qlik Reporting blocks will be deprecated on February 25th, 2026. Automation developers will notice the following blocks reflecting their deprecated status:
Review if you have any of the deprecated blocks in use and update them to their new variants as soon as possible.
When updating the blocks, automation developers should note that there are changes to the error handling between the corresponding blocks.
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

We uncovered the true time it takes to move goods through ports.

We can improve deliverable timelines by utilizing both the historic and estimated future discharge times.

Our audience is both the operations group within LP and the LP customers who move goods through these ports.

We have improved our communication of deliverables and our timeliness reporting.
As part of our ongoing commitment to our client-managed solutions, we are thrilled to announce the General Availability of Qlik Replicate November 2025! This release is centred on increasing the velocity and fidelity of your data pipelines, expanding our footprint in cloud ecosystems, and delivering critical governance and automation enhancements. For data architects and pipeline engineers, these updates ensure your real-time data strategy is future-proof and enterprise-ready.
This release delivers the value of Microsoft Fabric Open Mirroring for seamless cross-platform data sharing, improvements in Databricks and Azure ADLS integration, and expanded opportunities with new data type support for greater customer ROI.
Here is a breakdown of the key innovations and why they matter for your data integration strategy.
New and Enhanced Endpoints
This release significantly expands Qlik Replicate’s ability to connect to and handle modern data sources and targets, ensuring you can replicate data wherever it needs to be.
Security
Qlik Enterprise Manager Enhancements
Qlik Enterprise Manager is bundled with Qlik Replicate to provide a single-pane-of-glass view across multiple Replicate servers for monitoring, operations and maintenance. Qlik Enterprise Manager November 2025 enhancements introduce advanced automation and monitoring capabilities, streamlining the management of large-scale replication environments.
The November 2025 release of Qlik Replicate and Qlik Enterprise Manager provides the speed, flexibility, and operational efficiency needed to accelerate your data modernization efforts. We encourage you to upgrade and take advantage of these powerful new capabilities!
As always, each new release is fully supported for two years. To check the status of support for your currently installed version, please see the relevant product lifecycle pages.
We hope you enjoy using Qlik Talend Data Integration & Quality products and would love to hear your feedback and success stories, especially in any improvements you achieve.
To get the latest versions, please visit the Downloads and Release Notes section on Qlik Community.
To learn more about what is included in these releases, be sure to check out the Release notes, which are available here
To obtain any of these releases, go to the Qlik Downloads Site in the Community and filter “Product Category” by “Qlik Data Integration”, and then select the product and the versions you would like to download.
Note: For most products, selecting “Latest release and patch” under the “Show Releases” should be enough.
If required, you can filter further by selecting the latest “Release” and/or Service Release (SR) version under “Release Number”.
Most forecasts fall short because they treat drivers in isolation. Multivariate Time Series in Qlik Predict™ models interconnected factors like promotions, weather, and costs, so forecasts reflect real-world complexity. Analysts can build no-code models in minutes, explain results with SHAP transparency, and trigger proactive actions through Qlik automations. With governance and MLOps built in, models stay trusted and enterprise-ready. Fully embedded in Qlik Cloud, Multivariate Time Series turns analysis into action faster than standalone AutoML tools that stop at raw predictions.
Thank you for choosing Qlik,
Qlik Support
Don't miss our previous Q&A with Qlik! Hear from our panel of experts to help you get the most out of your Qlik experience.
Hello Qlik Users,
As announced previously (see Qlik Automate execution token changes), execution tokens will become header parameters on February 1st, 2026.
When triggering a triggered automation through the trigger URL (see the endpoint below), the execution token must be sent as a header parameter. Currently, it is possible to send the execution token as a query parameter. Starting February 1st, 2026, sending execution tokens as header parameters will be enforced.
api/v1/automations/{id}/actions/execute
Don't hesitate to reach out if you have any questions or address our experts directly in the Qlik Automate forum.
Thank you for choosing Qlik,
Qlik Support
We’re excited to share that the Qlik Learning Catalog is now available—bringing all your learning resources together in one easy-to-navigate location.
Explore our comprehensive library of self-paced courses designed to help you grow your expertise, whether you're creating impactful visualizations or managing complex system deployments. Access the Qlik Learning Catalog directly from the top navigation menu of Qlik Learning.
Use filters to quickly find the most relevant courses for your role or the products you work with. You’ll also be able to easily see which courses are free for all users and which require a learning subscription.
Start exploring today and continue building your Qlik skills with confidence!
New: Concurrent runs for automations
We are excited to share that Qlik Automate will now support concurrent runs, giving you more speed, scalability, and flexibility when managing your automations in Qlik Cloud.
With concurrent runs, you can process multiple runs of the same automation in parallel, making it easier to handle high-volume workloads, event-driven workflows, or large-scale data operations that need to happen fast.
Key Benefits:
This functionality is being rolled out in phases and not immediately available in all regions.
This can be configured in the settings for each automation and globally in the Automations section in the Activity center. For more information, see the Settings section in Navigating the user interface.
See Qlik Automate in Action
Want to see how Qlik Automate helps teams connect data, orchestrate processes, and drive intelligent action?
Check out our new Qlik Automate overview video — a great introduction for anyone looking to get more out of their automation workflows.
Do More with Qlik with Mike Tarallo: Explore the 4-part series “Taking Action on Your Data” to see how Qlik Analytics and Qlik Automate combine to build intelligent, action-driven dashboards.
Part 1: Part 1 - Quick Demo - Taking Action On You..
Part 2: Part 2 - "Hello World" - Taking Action On ...
Part 3: Part 3 - Input Parameters - Taking Action ...
Part 4: Part 4 - Taking Action on Your Data - Full Basic Tu...
Livestream Recording: Livestream Fridays: Taking Action on Your Data
Recent Qlik Automate Update You May Have Missed
In case you missed them, here are a few Qlik Automate updates released over the past few months:
Other Helpful Resources on Qlik Automate:
GitOqlok (git time machine) is an easy-to-use tool for version control in Qlik Sense.
Git + Qlik Sense integration.
GitOqlok could retrieve your load script, serialize diagrams, master items, variables into JSON and store it in the GitHub/Gitlab/Bitbucket. So, you could revert to the previous versions of the application.
Also, you could easily share your Qlik Sense applications and code snippets with Qlik Community and your team.
Import and reuse objects from QS applications:
✔ sheets;
✔ variables;
✔ master items;
For instance, you could import Rob Wunderlich QlikViewComponents into any application by one click.
See more:
初日は滞在ホテルでの Welcome Reception からスタートです。開催期間中は、CEO である Mike Capone もルンドに滞在し、ご挨拶としてこのミートアップの重要性を参加の皆様にあらためてお伝えしました。
今年は、日本からはホンダ小川様、セガ萬様の2名にご参加いただきました。Qlik からは CEO の Mike をはじめ、製品事業部トップの Drew Clark、Brendan Grady、製品開発チームなどが参加し、ロードマップや開発中の新機能の UI などを紹介しました。中でもオープンレイクハウス、エージェンティック AI、データプロダクトの重要性が強調されていました。午後は開発、ユーザー、パートナーによるワークショップとなり、次の製品デザインに向けてのフィードバックやアイディア出し、議論が行われました。
また、Qlik ユーザーである地元のアイスホッケーのチーム Redhawks の本拠地を訪問し、バックステージツアーと事例セッションが行われました。
このミートアップは、Qlik にとってユーザーからフィードバックを聞く貴重な機会です。同時にグローバルなユーザー同士の情報交換の場でもあり、多くのディスカッション、会話が生まれていました。
なお、Qlik Luminary の日本版である Qlikアドボケイトでは、引き続きメンバー募集中です。ご興味のある方はぜひお声がけください。
One of the many things that I love about working here at Qlik, is that I am always learning something new. Let me show you something I learned recently while updating the CPG Market Analytics app. In the app I found this sheet:
This page is titled ‘How do we compare’ and shows five different gauges, each showing a different metric along with three ranges, and a reference line. The tick mark represents an average for the brand. So, the purpose of these visualizations is to show the values of each metric for Qlik_CPG, a manufacturer. I wanted to take these gauges to create a cleaner visualization, while also keeping and improving the capabilities of the originals by allowing users to compare the metrics of Qlik_CPG to other manufacturers.
So how can I do this?
After much debate and searching for inspiration, I decided upon a bullet chart. A bullet chart is kind of like a combination of a bar chart, and a gauge. It uses a bar within the chart to show progress toward a goal.
Unlike a bullet chart which requires both a measure and a dimension, our gauges only need a measure, but that is okay, we’ll be using a synthetic dimension to combine our gauges into a single dimension.
Here’s how:
We’ll start with the dimension. Bullet charts only allow for one dimension to be used, so we can use the ‘ValueList’ function to display multiple metric names. Our dimension will look like this:
The ValueList() function creates a synthetic dimension that allows you to define a list of values that Qlik treats like one dimension. So basically, “Hey Qlik, I want to create a dimension, here are the values.”
So, with our dimension taken care of, we’ll move to the measure. This is what our measure looks like:
A little more complicated, but easily explainable. Our expression can be broken down into three functions, ValueList, Match and Pick.
ValueList() creates a synthetic dimension inside the chart with the labels we want to show (e.g., Attractive Packaging, Creative Advertisement, etc.).
Match() takes the current ValueList() value and compares it to our list of labels, returning the position of the first match (1 for the first item, 2 for the second, and so on).
Pick() then uses that numeric position to return the Nth measure expression from our list of measures. In other words, the order of labels in Match() is aligned with the order of expressions passed to Pick(): label #1 maps to measure #1, label #2 to measure #2, etc.
This lets us pair each label with its corresponding calculation. For example, when Qlik evaluates the Attractive Packaging dimension value, the expression resolves to Avg({$<Manufacturer={'Qlik_CPG'}>}[Attractive packaging]). Each ValueList item is evaluated in the same way, with Pick returning the appropriate measure for that label. When we place this into a bullet chart with targets, ranges, and styling, we get a compact visual of performance vs target across multiple KPIs.
Now keep in mind; that as per our expression, we are only showing these values for one Manufacturer, ‘Qlik_CPG’, we’re missing out on the functionality of being able to compare Qlik_CPG with the other Manufacturers. To keep this functionality, we’ll add another bullet chart with the other manufacturers to compare our Qlik CPG metrics to.
Here is an expression for the second bullet chart:
Great! Now our comparison chart shows every Manufacturer, and we can put it side by side with our Qlik_CPG chart to compare!
Maybe we want to be able to compare our Qlik_CPG metrics against the metrics of selected Manufacturers instead of all of them at once, adding a Filter Pane with the Manufacturers field will allow us to do just that.
To make things even better, we can go into our second bullet chart and make a dynamic title to show which manufacturers we’re showing in our chart. That expression for the Title will look like this:
This just says, “If we don’t have any selections for Manufacturer made, just title the chart ‘All Brands’ but if we do have a Manufacturer selected, name the chart those selections”.
So now we have taken our sheet, and gave it a whole new look that is much more concise and cleaner, while learning about the Pick, Match and ValueList functions.
Did you learn something through this article? Do you think the updated sheet looks better than the original? What would you do differently? How do you plan to use these functions in your own sheets? Leave your ideas in the comments below!