Ask a Question

Business

Analytics & AI

Forums for Qlik Analytic solutions. Ask questions, join discussions, find solutions, and access documentation and resources.

Data Integration & Quality

Forums for Qlik Data Integration solutions. Ask questions, join discussions, find solutions, and access documentation and resources

Explore Qlik Gallery

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.

Support

Chat with us, search Knowledge, open a Qlik or Talend Case, read the latest Updates Blog, find Release Notes, and learn about our Programs.

Events

Learn about upcoming Qlik related events, webinars and local meetups.

Groups

Join a Group that is right for you and get more out of your collaborations. Some groups are closed. Closed Groups require approval to view and participate.

Qlik Community

Get started on Qlik Community, find How-To documents, and join general non-product related discussions.

Blogs

This space offers a variety of blogs, all written by Qlik employees. Product and non product related.

Qlik Resources

Direct links to other resources within the Qlik ecosystem. We suggest you bookmark this page.

Qlik Academic Program

Qlik gives qualified university students, educators, and researchers free Qlik software and resources to prepare students for the data-driven workplace.

Community Sitemap

Here you will find a list of all the Qlik Community forums.

Product Innovation

Write Table now available in Qlik Cloud Analytics

Turn insights into action... right inside your analytics! As we wrap up the year and before everyone starts tying bows on projects, dashboards and wi... Show More
Turn insights into action... right inside your analytics!

As we wrap up the year and before everyone starts tying bows on projects, dashboards and wish lists, we wanted to add one more gift to the pile. Something that helps you move from insights to action faster, collaborate more easily, and keep your workflows flowing straight into the new year.

Unwrap Write Table, now available in Qlik Cloud Analytics.

Write Table is included with Premium, Enterprise, and Enterprise SaaS subscriptions. No add-ons or extra licensing required. You can find it in the Chart Library now.

A More Interactive Analytics Experience

Write Table introduces a new editable table chart that lets you update data, add context, validate decisions, and collaborate directly within your analytics apps. No reloads. No switching systems.

Just click, update, and watch your changes sync instantly across active sessions.

And because it’s built natively into Qlik Cloud Analytics, it seamlessly integrates into your existing workflows, transforming your apps into actionable workspaces.

"Probably the most awaited feature for customers who want to turn insights into action. Write table closes the gap between analytics and transaction applications, offering a compelling solution for those who always want to take it a step further. "

— Henri Rufin, Head of Data & Analytics, Radial

From Decisions to Automation

Now you can capture decisions and act on them.

With real-time syncing and change tracking, every update you make in a Write Table is stored in a Qlik-managed database called a “change store” that can be exported and connected into Qlik Automate workflows. That means approvals, changes, or comments made in an app can instantly trigger downstream processes.

From updating operational records... to routing approvals... to notifying teams... to pushing changes into your operational systems....

Write Table helps you move smoothly from insight -> decision -> action in one place.

“The new Write Table is a game-changing addition to Qlik's data and analytics solution. It allows our users to interact with the data, add context to their insights and collaborate effortlessly within the same trusted end-to-end platform. We're going to use it for everything, from updating data easily to seamlessly integrating with third-party tools using Qlik Automate workflows.”

— Sebastian Björkqvist, Solution Lead, Fellowmind

Key Highlights
- Editable table chart for updating values, adding comments, and capturing decisions in the Chart Library
- Real-time sync across active sessions, without reloads
- Qlik-managed change store for secure update handling
- Integration with Qlik Automate to trigger downstream workflows and orchestrate actions
- Native to Qlik Cloud Analytics, included for Premium, Enterprise and Enterprise SaaS subscriptions
Learn more
- Write Table Product Tour
- What’s New in Qlik Cloud | Qlik Help
- Write Table | Qlik Help
- Write Table - SaaS in 60 | Video
Show Less
By QlikProductUpdates 2025-12-09 / 09:41 AM

24 8 3757
Support Updates

Introducing: Write Table now available in Qlik Cloud Analytics

Make your analytics apps interactive. Edit data, add comments, and watch your updates sync across sessions instantly. With Write Table’s instant sync... Show More
Make your analytics apps interactive.

Edit data, add comments, and watch your updates sync across sessions instantly. With Write Table’s instant syncing and change tracking, teams can collaborate in real time and export updates through Qlik Automate.

Find it in the Chart Library when editing an app and get started!

Learn more here:
Thank you for choosing Qlik,
Qlik Support

Show Less
By Sonja_Bauernfeind 2025-12-09 / 09:57 AM

5 3 563
Japan

ダッシュボード上で直接入力・編集が可能に！ Qlik Cloud の新機能「ライトテーブル」

従来のBIツールでは、ダッシュボードで分析した内容を踏まえ次のアクションを取るために他システムへ入力したり、Excelでデータを修正して再度取り込み、また確認するといった作業が必要でした。分析画面と日常業務がつながっていないと、気付きを反映するまでに時間がかかったり、担当者間で認識がずれたりするケ... Show More

従来のBIツールでは、ダッシュボードで分析した内容を踏まえ次のアクションを取るために他システムへ入力したり、Excelでデータを修正して再度取り込み、また確認するといった作業が必要でした。分析画面と日常業務がつながっていないと、気付きを反映するまでに時間がかかったり、担当者間で認識がずれたりするケースも少なくありません。

こうした課題に応える新機能として、Qlik Cloudに「Write table（ライトテーブル）」が追加されました。これは分析画面上に配置できる編集可能なテーブルで、ユーザーが直接セルに入力したり、プルダウンを使って更新することができます。複数人による同時編集にも対応しており、行単位でロックされるため競合が起きません。編集内容は“change store”に保存され、APIを使って外部システムとの連携や自動化フローのトリガーとして利用することも可能です。

この機能がもたらす価値は、「分析」と「実務」がこれまで以上に近づく点にあります。例えば在庫数の修正、配送ステータスの更新、営業案件の進捗管理、社内コメントの書き込みなど、従来であれば別システムで行っていた作業を、Qlikアプリ内で完結できるようになります。特にビジネス部門において、現場が気付いた内容をその場で即時反映できることは大きな強みです。

さらに、外部システム連携や自動化機能（Qlik Automate）を組み合わせれば、入力内容をもとに通知や外部システム更新を自動化するなど、「分析 → 編集 → 実行」を継ぎ目なく実現できます。BIを見るためのツールから意思決定と実行を支えるプラットフォームへ進化させたい企業にとって、Write tableは大きな一歩となるでしょう。

データ修正の二度手間を減らし、ダッシュボードと現場作業を自然につなぐ体験が、業務プロセスの質を大きく変えるはずです。ぜひ一度試してみてください。

Write tableは、Qlik Cloud Analytics Premium以上のサブスクリプション、または Qlik Sense Enterprise SaaS でご利用いただけます。

Qlik TECH TALK セミナー：分析アプリでの直接データ操作とリアルタイム情報共有を実現！Write Tableのご紹介

Write table

Creating write tables

Show Less

By Yuki_Suzuki 2025-12-10 / 12:33 AM

0 0 35
Japan

【12/24（水）15:00 開催】製造業向け自社製品の製品価値を最大化する！

製造業における競争力は、いま“データを活かせる製品”かどうかで大きく変わりつつあります。本 Web セミナーでは、自社製品に Qlik Cloud Analytics をバンドルすることで実現できる新たな価値創出モデルをご紹介します。センサーデータや稼働ログを可視化し、予兆保全やリモート診断を可能に... Show More

製造業における競争力は、いま“データを活かせる製品”かどうかで大きく変わりつつあります。本 Web セミナーでは、自社製品に Qlik Cloud Analytics をバンドルすることで実現できる新たな価値創出モデルをご紹介します。センサーデータや稼働ログを可視化し、予兆保全やリモート診断を可能にするだけでなく、製品改善につながる利用データの取得、アフターサービスの収益化など、多くのメリットを具体的なユースケースを交えて解説します。“売り切り”から“継続的な価値提供”へ。製品の競争力を高め、顧客満足度を向上させるための実践的な方法をぜひご確認ください。

※ パソコン・タブレット・スマートフォンで、どこからでもご参加・ご視聴いただけます。

今すぐ申し込む

今すぐ申し込む
Show Less

By Qlik_JP_MKT2 2025-12-09 / 03:01 AM

0 0 10
Design

Qlik Trail: an extension to record, replay, and share your selection journeys

When I’m exploring a Qlik app, I often want to show exactly how I reached a view—without typing instructions or jumping on a call. Qlik Trail is a sma... Show More
When I’m exploring a Qlik app, I often want to show exactly how I reached a view—without typing instructions or jumping on a call.

Qlik Trail is a small extension I created that does just that: Click Record, make your selections, and you’ll get a tidy list of steps that you can replay from start to finish, or jump to a specific step. Then, when you’re happy with the journey, you can export the trail as JSON and hand it to someone else so they can import and run the same sequence on their side.

Why not just use bookmarks?

Bookmarks are great for destinations (one final selection state). Qlik Trail is more about the path:
- Multiple steps in a defined order (A → B → C)
- Replay from start for narration or Replay a specific step
- Export/import a whole journey, not a bunch of one-offs
You can use bookmarks to save a point in time, and use Qlik Trail when the sequence matters more.

What can you do with the Qlik Trail extension?
- Record steps manually, or toggle Auto to capture each change
- Name, duplicate, reorder, delete, or ungroup steps
- Organize steps into Groups (Executive Story, Sales Ops, Training, …)
- Replay to here (apply one step) or Replay from start (play the group)
- Export / Import trails as JSON
Demo

Before we go into how the extension was built, let's see a demo of how it can be used.

I’ll share two practical trails an Executive Story and Sales Ops with selections you can record and replay on your end, for this demo I'll use the Consumer Goods Sales app (which you can get here: https://explore.qlik.com/details/consumer-goods-sales)

Setup
- Upload the extension .zip file in the Management Console, then add Qlik Trail (custom object) to a sheet.
- Optional: enable Auto-record in the object’s properties if you want every change captured while you explore.
- Toolbar (left to right): Record, Replay from start, Delete, Delete all, Auto, Group filter, New group, Export, Import.
Trail 1 — Executive Story

Create Group: Executive Story

Step 0 — “US overview: top categories”
Selections: (none)

Step 1 — “Northeast · Fresh Vegetables”
Selections: Region = Northeast, Product Group = Fresh Vegetables

Step 2 — “Northeast · Cheese (A/B)”
Selections: Region = Northeast, Product Group = Cheese
quick A/B inside the same region.

Step 3 — “West vs Northeast · Fresh Fruit”
Selections: Region = West, Northeast, Product Group = Fresh Fruit
same category across two regions to see differences.

Step 4 — “Northeast focus: PA · Fresh Fruit”
Selections: Region = Northeast, State = Pennsylvania, Product Group = Fresh Fruit
drill to a particular state.

Presenting: select the group → Replay from start. If questions land on Step 4, use Replay to here.

Trail 2 — Sales Ops Story

Create Group: Sales Ops Story

Step 1 — “South · Ice Cream & Juice (summer basket)”
Selections: Region = South, Product Group = Ice Cream, Juice

Step 2 — “Central · Hot Dogs (promo check-in)”
Selections: Region = Central, Product Group = Hot Dogs

Step 3 — “West · Cheese (margin look)”
Selections: Region = West, Product Group = Cheese

Tips when building trails
- One idea per step. (Region + Category) or (Region + a couple of States)
- Duplicate then tweak for fast A/B comparisons
- Group by audience. Exec, Ops, Training
- Ungrouped steps = scratchpad. Move into a group when it’s ready
- After recording, drag to reorder so replay tells a clean story
Sharing your trails

Click Export to download qliktrail_export_YYYY-MM-DD_HHMM.json.

Your teammate can Import, pick a group, and hit Replay from start. Same steps, same order—no instructions needed.

Tech notes

1) Module & CSS injection
Load CSS once at runtime so the object stays self-contained:
```
define(['qlik','jquery','./properties','text!./style.css'], function(qlik, $, props, css){
  if (!document.getElementById('qliktrail-style')) {
    const st = document.createElement('style');
    st.id = 'qliktrail-style';
    st.textContent = css;
    document.head.appendChild(st);
  }
  // …
});
```
2) Capturing selections per state
Read SelectionObject, group by qStateName, then fetch only selected rows via a lightweight list object. Store both text and numeric to be resilient to numeric fields:
```
app.getList('SelectionObject', function(m){
  // build grouped { state -> [fields] }
});
...
app.createList({
  qStateName: stateName || '$',
  qDef: { qFieldDefs: [fieldName] },
  qInitialDataFetch: [{ qTop:0, qLeft:0, qWidth:1, qHeight:10000 }]
}).then(obj => obj.getLayout() /* collect S/L/XS states */);
```
Snapshot (what we export/import):
```
{
  "ts": "2025-03-10T14:30:00Z",
  "states": [
    {
      "state": "$",
      "fields": {
        "Region": { "text": ["Northeast"], "num": [] },
        "Product Group": { "text": ["Fresh Vegetables"], "num": [] }
      }
    }
  ]
}
```
3) Replaying selections
Clear target state, then select values. Prefer numbers when available; fall back to text:
```
app.clearAll(false, state);
...
field.selectValues(pack.num.map(n=>({qNumber:n})), false, false)
// fallback to qText
field.selectValues(pack.text.map(t=>({qText:String(t)})), false, false);
```
4) Auto-record with a quiet window
Avoid recording during replays to prevent ghost steps:
```
ui.replayQuietUntil = Date.now() + (layout.props.replayQuietMs || 1200);
if (Date.now() >= ui.replayQuietUntil && ui.autoOn) record();
```
5) Groups, ordering & persistence
Trails live in localStorage per app key. Groups look like { id, name, members:[stepId,…] }. Ordering is a simple seq integer; drag-and-drop reassigns seq inside the open list.

That’s Qlik Trail in a nutshell. It lets you hit record, name a few steps, and replay the story without hand-holding anyone through filters. Use Bookmarks to keep states, but Trail will help you keep tack of the sequence.

P.S: this extension is a work-in-progress experiment and not prod-ready, I'm planning to add more features to it and make it more stable in the future.

🖇 Link to download the extension: https://github.com/olim-dev/qlik-trail
Show Less
By Ouadie 2025-09-27 / 07:00 AM

2 8 606
Design

Qlik Cloud Analytics Enhancements

As we enter the last month of the year, let’s review some recent enhancements in Qlik Cloud Analytics visualizations and apps. On a continuous cycle, ... Show More

As we enter the last month of the year, let’s review some recent enhancements in Qlik Cloud Analytics visualizations and apps. On a continuous cycle, features are being added to improve usability, development and appearance. Let’s’ look at a few of them.

Straight Table

Let’s begin with the straight table. Now, when you create a straight table in an app, you will have access to column header actions, enabled by default. Users can quickly sort any field by clicking on the column header. The sort order (ascending or descending) will be indicated by the arrow. Users can also perform a search in a column by clicking the magnifying glass.

When the magnifying glass icon is clicked, the search menu is displayed as seen below.

If a cyclic dimension is being used in the straight table, users can cycle through the dimensions using the cyclic icon that is now visible in the column heading (see below).

When you have an existing straight table in an app, these new features will not be visible by default but can easily be enabled in the properties panel by going to Presentation > Accessibility and unchecking Increase accessibility.

Bar Chart

The bar chart now has a new feature that allows the developer to set a custom width of the bar when in continuous mode. Just last week, I put the bar chart below in continuous mode and the bars became very thin as seen below.

But now, there is this period drop down that allows developers to indicate the unit of the data values.

If I select Auto to automatically detect the period, the chart looks so much better.

Combo Chart

In a combo chart, a line can now be styled using area versus just a line, as displayed below.

Sheet Thumbnails

One of the coolest enhancements is the ability to auto-generate sheet thumbnails. What a time saver. From the sheet properties, simply click on the Generate thumbnail icon and the thumbnail will be automatically created. No more creating the sheet thumbnails manually by taking screenshots and uploading them and assigning them to the appropriate sheet. If you would like to use another image, that option is still available in the sheet properties.

From this To this in one click

Try out these new enhancements to make development and analysis faster and more efficient.

Thanks,

Jennell
Show Less

By Jennell_Yorkman 2025-12-05 / 11:48 AM

1 3 263
Japan

Qlik Cloud １１月の新機能

分析の新機能コンボチャートにおける線のエリアコンボチャートで線を使用する場合に、エリアを表示できるようになりました。これにより、単にトレンドを示すだけでなく、データの大きさを表現しやすくなります。連続軸の棒グラフの幅のカスタマイズ連続スケール（Continuous Axis）を使用す... Show More
分析の新機能

コンボチャートにおける線のエリア

コンボチャートで線を使用する場合に、エリアを表示できるようになりました。これにより、単にトレンドを示すだけでなく、データの大きさを表現しやすくなります。

連続軸の棒グラフの幅のカスタマイズ

連続スケール（Continuous Axis）を使用する棒グラフにおいて、棒の幅（太さ）をデータ単位に基づいて自由に設定できるようになり、視認性が大幅に改善されました。

シートサムネイルの自動生成機能

シートの内容を反映したサムネイル画像が自動生成されるようになり、手動設定なしで視覚的な判別が容易になりました。デフォルトの骨組み（スケルトン）アイコンの代わりに、実際のシート内容を反映したプレビューが表示されるため、中身が一目で分かります。手動でスクリーンショットを撮ってアップロードする作業が不要になります。視覚的なプレビューにより、目的のシートを素早く直感的に見つけることができます。

Table Recipeの機能強化

Table RecipeのフィルタリングとNull処理が強化され、さらに作成したレシピをData Flowへシームレスに変換できるようになり、拡張性が大幅に向上しました。
- フィルタリングの柔軟性: 複数の条件に対して「すべて(All) / いずれか(Any) / なし(None)」のロジックを適用可能になり、値のサジェスト機能も強化されました。
- Null/空文字の厳密化: Nullと空文字（Empty）を明確に区別し、それぞれの状況に応じた適切な処理（削除や埋め込み）を提案します。
- Data Flowへの昇格: Table RecipeからData Flowへワンクリックで変換・複製が可能になり、より高度なデータ処理パイプラインへの拡張が容易になりました。
データフロー：トラブルシューティングと生産性向上機能

データフローのUI/UXが強化され、エラー箇所の即時特定やショートカット操作が可能になり、開発・修正作業の効率が大幅に向上しました。

Qlik Automate のアップデート
- Qlik Automate コネクタが更新され、リロード処理のエラーハンドリングと帳票テンプレートAPIへのアクセスが可能になりました。
- Outlookコネクタを通じて、添付ファイル付きのメールを送信できるようになりました。Microsoft は 2026 年 3 月 1 日に Outlook の SMTP 認証を廃止する予定です。すべての Microsoft ユーザーは、この更新を適用して準備することを強くお勧めします。
- Qlik Reportingコネクタが拡張され、HTML形式でのレポート生成が可能になりました。これにより、レポートをファイルとして配布するだけでなく、メール本文への埋め込みなども容易になりました。
Qlik Analytics Migration Tool: 2025年11月リリース
- 安定性の強化: 主にバグ修正と安定性の改善に重点を置いたアップデートです。
- Qlik Cloud Governmentでも利用可能となりました。
- パフォーマンス向上: 移行プロセスの中核となるワークフローの処理性能が改善されました。
- 詳細情報: 具体的な修正内容を含む完全なリリースノートはQlik Communityで公開されています。
データ統合の新機能

新しい SQL 変換 UI

SQL開発者の生産性を最大化するため、エディタインターフェースが全面的に刷新され、コーディングからテスト実行までの操作性が大幅に向上しました。
- エディタの現代化: 作業領域の拡大、複数クエリの記述・選択実行、およびショートカットキー（実行、コメント、検索置換など）に対応しました。
- データセット支援: データセットの履歴バリアント表示、SELECT文の自動生成、およびパラメータの自動割り当て機能が追加されました。
- 実行可視性: 直近に実行したクエリの内容と、その完了にかかった所要時間を即座に確認できるようになりました。
Databricks でナレッジマートのサポートを開始

ナレッジマートタスクが Databricks Vector Store と Databricks LLMs をサポートし、エンドツーエンドの AI データパイプラインを Databricks 環境内で完結できるようになりました。
- Databricks対応: ベクトル格納先（Vector Store）および埋め込み用LLMとして、新たにDatabricksをサポートしました。
- RAG構築の自動化: 構造化・非構造化データの変換、ベクトル化、ロードまでの一連のプロセスを自動化します。
- エコシステムの拡張: 従来のSnowflakeに加え、ElasticSearch、OpenSearch、PineCone、OpenAI、Bedrockなど多様なAI基盤と連携可能です。
Pipelines のバージョン管理からプロジェクトのインポート

Qlik Talend Cloud上で、バージョン管理システムから直接プロジェクトのブランチをインポートすることが可能になりました。他の開発者のコードをレビューしたり、共同で作業を進める際の手間を削減し、開発(Dev)、品質検証(QA)、本番(Prod)といった異なるスペースやテナント間で、プロジェクトを安全に共有・移行することができます。

その他

管理者向けの新機能

同時自動化実行の導入

同じ自動化の実行を、複数同時に開始できるようになりました。各自動化の設定、およびアクティビティセンターの自動化セクションでグローバルに設定が可能です。デフォルトは10の設定となっております。

Webhook セキュリティの強化

Webhook機能においてセキュリティが強化され、ヘッダー値の暗号化とシークレットの保護が可能になりました。

新しい Direct Access gateway バージョン (1.7.8)

Databricks接続におけるOAuth認証のサポート強化と、プロセス分離時のポート設定の柔軟性が向上しました。

RESTコネクタとファイルコネクタの許可リスト設定のサポート

管理画面から、Direct Access gateway経由のRESTおよびFileコネクタに対するアクセス許可リスト（Allow Lists）を直接設定できるようになりました。

Qlik Cloudがフランスに進出

フランスに新たなクラウドリージョンを提供開始しました。世界で13番目のリージョンとなります。
Show Less
By Yuki_Suzuki 2025-12-05 / 01:20 AM

0 0 27
Japan

【12/17（水）15:00 開催】卸売業界必見！SAP データの利活用

多くの卸売企業が基幹システムとして利用している SAP。そこに格納されているデータを外部データなどと組み合わせてさまざまなビジネスシーンで広く活用することで、その価値は何倍にも高まります。一方で SAP データを簡単に解放することが難しいという現実もあります。本 Web セミナーでは、SAP データ... Show More

多くの卸売企業が基幹システムとして利用している SAP。そこに格納されているデータを外部データなどと組み合わせてさまざまなビジネスシーンで広く活用することで、その価値は何倍にも高まります。一方で SAP データを簡単に解放することが難しいという現実もあります。
本 Web セミナーでは、SAP データ価値を高める弊社ソリューションを、事例も交えご紹介します。

※ パソコン・タブレット・スマートフォンで、どこからでもご参加・ご視聴いただけます。

今すぐ申し込む

今すぐ申し込む
Show Less

By Qlik_JP_MKT2 2025-12-04 / 07:45 PM

0 0 34
Support Updates

Qlik Automate: 30-second interval deprecation January 12, 2026

Starting January 12, 2026, the 30-second interval option will no longer be available in the Qlik Automate scheduler. This update prepares Qlik Automa... Show More
Starting January 12, 2026, the 30-second interval option will no longer be available in the Qlik Automate scheduler.

This update prepares Qlik Automate for a future upgrade that will bring enhanced scheduling capabilities that are consistent with other Qlik products, including:
- Support for specific days and dates
- Configurable time windows
How will this affect me?

All automations using the 30-second interval will continue to work and run on the 30-second interval for now.

At a yet to be decided date, automations that still use a 30-second interval will be migrated to a 1-minute interval. Subscribe to this blog post to stay informed.

What actions do I need to take?

Please review your automations that use 30-second intervals to ensure they will function properly with a 1-minute interval.

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

Show Less
By Sonja_Bauernfeind 2025-12-04 / 08:00 AM

0 0 387
Design

Regular Expressions in Qlik: Finally Native

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 n... Show More
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.

The New Regex Functions

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().

🔗 Help Article

Replacing Old Patterns

Here's where regex saves time:
- Format validation: Replace nested Len(), Left(), and Mid() with a single pattern.
- Substring extraction: Skip the manual slicing; let the pattern do the work.
- 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.

Use Cases That Just Got Easier

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.

Example: Clean and Validate Phone Numbers

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:
1. Validate that it’s a proper 10-digit North American number
2. 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.

Final Thoughts
- Use regex where it adds value.
  For simple cases like Left() or Trim(), stick with built-in string functions.
- When you're working with inconsistent inputs, embedded formats, or anything that doesn’t follow clean rules, regex can save a lot of time.
- If you're applying regex across large datasets, especially in charts, it’s better to handle it in the load script where possible.
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.
Show Less
By Ouadie 2025-11-21 / 06:31 PM

2 3 534
Support Updates

Techspert Talks - Unleashing the Qlik Talend Cloud Dynamic Engine

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 ins... 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, December 10 Qlik will host another Techspert Talks session and this time we are looking at 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:
- Enabling seamless parity
- Scaling always-on deployment
- Expanding DevOps agility
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
By Troy_Raney 2025-12-04 / 04:46 AM

0 0 356
Community News

Qlik Community Scavenger Hunt Now Live!

Hi Qlik Community, We’re kicking off December with something fun, interactive, and built to bring the entire Community together. The Qlik Community Sc... Show More

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
Show Less

By calebjlee 2025-12-03 / 11:04 AM

0 1 62
Qlik Academic Program

Qlik Academic Program in Brazil

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 Academ... Show More

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
Show Less

By TalitaBM 2025-12-02 / 03:47 PM

0 0 45
Support Updates

Introducing Namespaces in Qlik Cloud APIs

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 unlo... Show More
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.

What to expect
- The new namespaced APIs will be introduced in parallel with the existing APIs.
- The existing APIs will be deprecated and removed after a minimum 12-month deprecation period from the notice of deprecation on the changelog (qlik.dev).
- No immediate action is needed. As each API is namespaced, a deprecation notice will be published with migration guides.
Key changes

REST
1. Removal of v1 from the path: v1 will be removed from the path to prepare for versioning support in the future.
2. Grouping resources by context: Related APIs will be grouped together under a namespace which indicates in which context the resources are applicable. For example:
  
  The analytics namespace for Analytics-specific resources such as apps, notes, and ODAGs apps.
  
  The core namespace for platform-wide resources such as users, groups, ip-policies, and roles.
3. Standardization of interfaces: The payloads for the new namespaced APIs will be standardized to be compliant with Qlik’s API design principles, meaning improved consistency of payloads, query parameters, and response formats between different APIs, irrespective of the context.
Events

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>.

Want to learn more?

Head to the API namespaces overview page for additional details and examples.

Thank you for choosing Qlik,
Qlik Support

Show Less
By Sonja_Bauernfeind 2025-12-02 / 08:00 AM

0 2 560
Support Updates

Reminder: Qlik Data Gateway - Direct Access versions 1.4 and 1.5 reaching End of...

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 Direc... Show More

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.

How will this affect me?

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.

How do I upgrade?

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.

What else do I need to keep in mind?

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.
Show Less

By Sonja_Bauernfeind 2025-12-01 / 08:00 AM

0 2 586
Support Updates

Qlik DataTransfer Deprecation Notice for Q1 2026

Qlik DataTransfer will be officially End-of-Life by the end of Q1 2026. It will be removed from the Product Downloads site later this year and will no... Show More
Qlik DataTransfer will be officially End-of-Life by the end of Q1 2026.

It will be removed from the Product Downloads site later this year and will no longer be available for new installations or upgrades. Qlik will provide support until April 30, 2026.

To ensure a smooth transition, we recommend you begin utilizing Qlik Data Gateway – Direct Access, the supported alternative.

Note that the initial release of Qlik DataTransfer (November 2024, version 10.4.0) will not work after June 24th, 2025. If you still need to use Qlik DataTransfer beyond June, upgrade to the Service Release version 10.4.4.

How do I get started with Qlik Data Gateway - Direct Access?

We have compiled a list of resources to assist you in adopting Qlik Data Gateway - Direct Access:
- Setup Guide: Qlik Data Gateway – Direct Access
- Walkthrough Video: Qlik Data Gateway – Direct Access
- Troubleshooting Video: STT - Troubleshooting Qlik Data Gateway - Direct Access
Additionally, for those needing feature parity with Qlik DataTransfer, we recommend pairing with the File Connector via Direct Access, REST Connector via Direct Access, and the generic ODBC Connector.

Further Resources:
- Connector Factory Blog: Connector Factory January and February 2025 Releases
- SaaS in 60: File Connector via Direct Access Data Gateway - SaaS in 60
We will share an update later this year with the exact deprecation and end-of-support dates.

For assistance, please contact Qlik Support. Questions on how to contact Qlik Support.

Thank you for choosing Qlik,
Qlik Support
Show Less
By Sonja_Bauernfeind 2025-05-06 / 08:00 AM

10 6 7230
Japan

【オンデマンド配信】自治体向け：自治体データと位置情報の組み合わせが地域課題を解決に導く

自治体が保有する多様なデータと位置情報を組み合わせることで、地域課題の可視化や住民サービスの高度化が可能になります。行政データ・地理空間情報・外部統計などを統合し、災害対応、観光振興、福祉支援などの分野でどのように価値を創出できるかを考えてみませんか。データ利活用のための分析ツールを利用したデモも行... Show More

自治体が保有する多様なデータと位置情報を組み合わせることで、地域課題の可視化や住民サービスの高度化が可能になります。行政データ・地理空間情報・外部統計などを統合し、災害対応、観光振興、福祉支援などの分野でどのように価値を創出できるかを考えてみませんか。データ利活用のための分析ツールを利用したデモも行いますので、実践的なアプローチも学べる内容となっています。

※ パソコン・タブレット・スマートフォンで、どこからでもご視聴いただけます。

今すぐ視聴する

今すぐ視聴する
Show Less

By Qlik_JP_MKT2 2025-11-27 / 06:16 AM

0 0 71
Qlik Academic Program

Kristu Jayanti University integrates Qlik Academic Program in its curriculum

Kristu Jayanti University in India prioritizes graduate employability by equipping students with data skills so that they are career ready. Founded in... Show More

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.

Recently, the University agreed to incorporate Qlik Sense into the revised University syllabus for Semester V and Semester VI of the BCA Analytics program.

They have leveraged the content from the Qlik Academic Program including Business Intelligence & Data Modeling and Analytics Platform Administration & Governance among others. Credits have been assigned to students for each semester once they complete the qualifications and certifications.

Its another milestone between Kristu Jayanti and the Qlik Academic Program. We are hopeful students are able to forward their career with this initiative.

To learn more about this program, visit: qlik.com/academicprogram and if you are curious to learn about how to leverage the content into your course/curriculum, email: academicprogram@qlik.com
Show Less

By Pankaj_Muthe 2025-11-27 / 04:43 AM

0 1 60
Support Updates

Qlik Dropbox connectors: Deprecation of long-lived access tokens

Hello Qlik admins and developers, Previously, the Dropbox API used only long-lived access tokens. These long-lived access tokens have been deprecated ... Show More
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.

What action do I need to take?

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:
- Qlik Sense: Client Managed and Qlik Cloud
  
  Dropbox file location connector
  
  Dropbox Metadata connector
- Qlik Web Connector Standalone
  
  Qlik Dropbox Connector
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.

What if I do not re-authenticate in time?

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.

Is there some way for me to identify the connections?

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.

How to re-authenticate in Qlik Sense: Client Managed and Qlik Cloud

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.

How to re-authenticate the Qlik Web Connector: Standalone

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.

Additional recommendations

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
Show Less
By Sonja_Bauernfeind 2025-07-31 / 08:05 AM

1 2 710
Support Updates

Deprecation Notice: Qlik Reporting block transition required for February 25, 20...

Several Qlik Reporting blocks will be deprecated on February 25th, 2026. Automation developers will notice the following blocks reflecting their depre... Show More
Several Qlik Reporting blocks will be deprecated on February 25th, 2026. Automation developers will notice the following blocks reflecting their deprecated status:
- Get Chart Image (Deprecated)
- Get PixelPerfect (Deprecated)
- Get Tabular Report (Deprecated)
What does this mean for me?

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.
- Refer to the API specifications Response 200 > application/JSON for results and reasons deprecation status.
- Any exception management logic will need to be adjusted in line with the API specifications as documented in Get report request outputs
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
By Sonja_Bauernfeind 2025-11-26 / 07:59 AM

0 2 601