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.
The fall semester is just around the corner—sooner than many of us would like! As you begin planning for another academic year, we know how much time and effort goes into designing course content, creating assignments, and building assessments.
What if some of that work was already done for you?
With the Qlik Academic Program, you’ll have access to ready-made curriculum materials, including lesson plans, assignments, quizzes, and even exams—all designed to help students build real-world data skills. You can use our resources as-is or tailor them to fit the unique needs of your class.
And you don’t have to go it alone. We’re here to help you integrate Qlik into your course, introduce your students to the platform, and get everyone up and running before the semester begins. Whether you want a quick onboarding session or a full student workshop, we’ll support you every step of the way.
By incorporating Qlik into your classroom, you’re not just preparing your syllabus—you’re helping students gain valuable skills that translate directly to the job market.
Let us help take one thing off your plate this fall. Reach out now to get started, and let’s make this semester a little less stressful—and a lot more impactful.
Please reach to me directly to get on the schedule! https://www.linkedin.com/in/brittany-fournier-27694176/
To sign up for our Academic Program, please go to: https://www.qlik.com/us/company/academic-program
This month we would like to introduce you to Diogo Oliveira. Diogo is based out of Lisbon, Portugal and loves helping students unlock the powerful insights in Qlik products and understand how much more they can do with the tools.
1. How long have you been with Qlik?
Since June 2016, so a little over 9 years now.
2. How did you become an instructor?
I’ve always enjoyed technology, but even more than that, I’ve always loved helping people understand how things work. Early in my career, I worked in various technical roles, from consulting to solution development and implementation, and that’s when I realized that my favorite part of every project was explaining complex ideas in a way that made sense to others. At Qlik, that passion found the perfect home, and I transitioned from consultancy role to technical training. Becoming an instructor felt like a very natural step, it combined my love of technology with my drive to help people grow their skills and confidence.
3. What do you love about teaching Qlik courses?
I love seeing that moment when someone realizes how much more they can do with Qlik than they ever thought possible. It never gets old to see those “aha!” moments happen, and to help people understand the tool better. Plus, the variety keeps it fun, every class is different, and I always learn something new too.
4. How has the new platform helped you in leading your courses?
The new platform has made everything smoother, for both the students and me. It’s easier to manage content, share resources, and keep everyone engaged. I love that it gives learners more flexibility to practice and explore on their own, too.
5. What are your favorite features on the new platform?
I really like how intuitive and clean the interface is; it just makes everything easier to find and use. Plus, with virtual machines embedded right into the content, students don’t have to juggle multiple tools. It’s a true one-stop shop for learning, making hands-on practice way more seamless and convenient.
6. What is your favorite course to teach?
I really enjoy teaching the Data Modeling Training. It’s where students build a strong foundation by mastering how data fits together, which is key to unlocking powerful insights in Qlik. This course allows students to truly understand the Qlik engine and how data associations impact the way you do your data modeling. I love seeing students connect the dots and gain confidence in shaping their data for analysis. With that said, there are some new trainings about to be released that look quite interesting and could potentially dethrone the “King”.
Check out one of Diogo’s informative Live Instructor Webinars; available for both the AMER and EMEA regions, and register. We know you'll be back for more!
Happy Learning!

Enable working with data just like in Excel with no learning curve. From editable tables and advanced formulas to formatting, validation, pivoting, and charting — everything happens right inside your Qlik Sense apps.

Integrating Excel-like spreadsheets lets users interact with data without switching tools or context. This drives faster decisions, smoother collaboration, and higher dashboard adoption.

Teams tired of handling export-to-Excel requests, and anyone looking to bring familiar spreadsheet workflows into their Qlik Sense apps.

Powered by the Spreadsheets extension for Qlik Sense, this app uses fictional data to illustrate its key capabilities in action. From natively importing Excel templates and adding sparklines to running AI-driven transformations and predictive models.
🔗 >> VIEW LIVE OR DOWNLOAD QVF <<
📝🎥 How to Create an Excel-Style Spreadsheet in Qlik
📝🎥 How to Import an Excel Template into Qlik
What if you could learn throughout the whole year, with total flexibility and no worries about budget?
Introducing the Qlik Public Instructor-led Passport – a yearly subscription that gives you unlimited access to all public live courses led by expert instructors.
For 12 months, you can join any course, even repeat sessions whenever you want. Plus, each month we launch new and exclusive learning experiences, designed to help you grow step by step.
Some of these experiences will be unique and temporary, created for specific moments or emerging needs.
Once they’re over, they might not come back — and only Passport holders will have access!
We know that mastering a tool or skill doesn’t happen in just one session. That’s why the Passport offers something different:
✅ Structured learning to build a solid mental map
✅ Live sessions with experts to answer your questions
✅ Time to practice, repeat, and go deeper
✅ Access to exclusive content — before it’s gone
Perfect for small teams with multi-role leaders, who need complete, ongoing training without going over budget.
👉 Get your Passport today and make the most of every opportunity — before it’s gone!
Tip: Log in to see prices in your local currency.
We’re thrilled to welcome two outstanding contributors into the Qlik Community MVP Program, @seanbruton and @QFabian!
The MVP title isn’t just a badge, it’s a recognition of consistent passion, deep knowledge, and a commitment to lifting others up across the Qlik Community. Sean and Fabian embody all of that and more. Whether it’s answering questions, sparking meaningful conversations, or sharing hard-earned insights, they’ve shown an incredible dedication that hasn’t gone unnoticed.
Both Sean and Fabian were previously honored as Featured Members, and their journey has only continued upward since then. Their impact on the Community is undeniable, and we’re excited to officially recognize them as Qlik Community MVPs.
Please join us in celebrating Sean and Fabian as they join a global network of Qlik power users and changemakers. We can’t wait to see how they continue to inspire and innovate, welcome to the MVP family!
Your Qlik Community Managers,
Melissa, Sue, Jamie, Nicole, Tammy, Caleb and Brett
@Melissa_Potvin @Sue_Macaluso @Jamie_Gregory @nicole_ulloa @Tammy_Milsom @Brett_Cunningham
Enhancements have been made to the line chart plugin feature that allows point and lines to be added to the line chart. These enhancements include features such as labels for points and lines, placement options for labels, and point symbol, size and color styling options. In the chart below, there is a line chart showing the daily page views for a site over time. Notice the point annotations for the highest and lowest daily page views days.
Let’s look at how these were created and the new features that are now available. Points and lines can be added to a line chart from the properties panel under Add-ons > Shapes.
The shape options that can be added are point and line. To add a point for the highest daily page views, a dimension value needs to be entered. It can be hard-coded, or it can be an expression. In this example, I used an expression to show the highest day in the current year. Measure input is set to measure index and the index is set to 0 to use the first measure in the line chart. Shown below are the styling options now available to use. Star was the symbol selected from the list of 7 options (circle, cross, diamond, saltire, square, star and triangle). The point color and outline are a color that stands out in the chart.
The same procedure was followed to add the symbol for the lowest daily page views. The expression was modified as well as the symbol and symbol color. The Colored background was checked to give a dark background to the label to make it easier to read.
Notice how these annotations highlight aspects about the line chart that may be significant or that the developer wants to point out. Let’s add a line to this chart to see what it looks like. To add a line to this chart that connects these points, a new line shape needs to be added with the value or expression for the line endpoints. Like the points, the line can be colored, and the line thickness, type and curve can also be styled.
These shapes do not replace the reference lines or dimension reference lines that can be added to a line chart. They can still be added to a line chart. The shapes feature should be used to add context to a line chart to enable better understanding. Check out Qlik Help to learn more.
Thanks,
Jennell
Qlik Replicate May 2025 General Availability Release
New and Enhanced Endpoints
Snowflake
We continue to strengthen our strategic, technical, and commercial partnership with Snowflake, earning the award of Snowflake’s 2025 Data Integration Partner of the Year.
⚠️ Note: You can still use the existing standalone endpoints for cloud-specific Snowflake targets without disruption. We recommend using the unified Snowflake Target endpoint for new tasks. In future releases, we will be providing an automated process to migrate your existing tasks, with cloud-specific endpoints, into the unified Snowflake Target endpoint. ⚠️
Databricks
SAP Endpoint Enhancements
Qlik has deep domain knowledge and expertise with the SAP ecosystem and remains committed in helping our customers empower their SAP data by offering flexibility and a wide breadth of endpoints and solutions to cater for different scenarios in your SAP environments.
IBM Mainframe
Amazon
Kafka
MongoDB
Newly Supported Endpoint and Driver Versions:
Qlik Replicate continuously updates its compatibility. This release adds support for the latest versions of MariaDB, MySQL, PostgreSQL, IBM DB2 for LUW, IBM DB2 for z/OS, and Teradata Database ODBC Driver. This ensures that customers can leverage the newest features and security updates of their source and target databases while maintaining seamless data replication.
Qlik Replicate Server Enhancements
Qlik Enterprise Manager May 2025 Enhancements
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 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”.
Artificial intelligence is making headlines everywhere. It can write essays, summarize articles, and generate images in seconds. For students, educators, and researchers, this opens up exciting possibilities.
However, with these new tools comes a new challenge: how do we know if what AI gives us is actually true?
AI doesn’t understand facts, it just predicts what sounds right based on patterns. This means it can sometimes produce false or misleading information. Experts call this “AI hallucination.”
It’s not just about mistakes; bias is also a major issue. AI bias happens when the data used to train a model includes unfair patterns, like stereotypes or unbalanced information. AI can accidentally repeat and even strengthen these biases because it learns from what’s already out there. That’s why it’s so important to stop and ask: Where did this data come from? Who’s included and who’s missing?
Data literacy and critical thinking matter more than ever, because recognizing these issues takes more than just trusting the tech.
In fact, a recent article from MIT reminds us that while AI can support decisions, it shouldn’t replace human judgment. We still need people to ask questions, check sources, and notice when something seems off. AI can speed up the process, but it’s people who make sense of the output. (When AI Gets It Wrong: Addressing AI Hallucinations and Bias - MIT Sloan Teaching & Learning Technologies
The good news? You don’t have to figure it all out alone. The Qlik Academic Program is here to help you to build the skills that matter most today.
Through the program, you’ll get:
Everything in the Qlik Academic Program is built to help you explore data, ask better questions, and grow your skills, whether you're teaching or learning.
So, whether you're a student getting ready for your future, a professor bringing data into your classroom, or a university driving innovation, this program is here for you.
Because while AI is powerful, real progress happens when people know how to think with data.
Learn more and join for free: Qlik Academic Program: Creating a Data-Literate World
第5回データソン開催と合わせてはじめたこの Viz for Deck、ひとまず今回で最終回です。最後は前回長文にもかかわらず書ききれなかったテーブルのおかわり編で締めたいと思います。
こんなかわいいテーブルを作ってみました!じゃ~んっ!
なんと、これストレートテーブルですよ!
メディアライブラリに格納した画像と、SVGを使って表現しています。こんなシンプルなデータで作ってみました。
テーブルの軸は[星座]、ソート順は[ID]です。
2つ目の項目は[ID]、ラベルは「=' '」としています。そして表記を「画像」、画像の設定を「URLを追加」とし、画像URLに、メディアライブラリのアドレスを指定しています。サイズは高さに合わせています。
メディアライブラリの各画像のアドレスの求め方ですが、Chrome 使用の場合をご紹介します。画像を追加できるところ(シート背景やサムネイルなど)からメディアライブラリを開いてください。そして該当の画像を選択した状態でファンクションキーの12を押して、ブラウザのDevToolsを開きます。そして、「Select an element」の矢印をクリックして画像のプレビューをクリックすると、Elementタブでアドレスを見ることができます。
アドレス部分で右クリックし、「Copy」>「Copy element」をクリックするとクリップボードにコピーされます。この「/api/v1」以降を画像URLの欄に貼り付けます。このままでは固定ですので、最後のファイル名を可変にします。今回はファイル名の最後をIDと一致させているので、下記のように指定して、軸のIDに伴って対応する画像が表示されるように設定します。
メディアライブラリの画像はAPIを使って求めることも可能です。QlikTips: URL による画像の設定 をご参照ください。
続いて棒グラフの列です。ここはメジャーとして下記のSVG(スケーラブルベクターグラフィックス)を使った数式を設定しています。
高さ20、幅103 の領域に、長方形 (rect) を描きます。幅は[ラッキー度]とし、高さは20です。塗りつぶしは[色]の色を使用します。
ラベルは表示されないように「=' '」としています。表記は「画像」、画像の設定は「ラベルを追加」、「サイズは縮小/拡大して合わせる」にしています。(いったん、「高さに合わせる」にして中央表示にしないと画像が表示されない場合があります。)
水瓶座の人ごめんなさい。ダミーデータです。
お楽しみいただけましたでしょうか?それではまたいつかどこかで!
Happy Dueling !
** 過去の記事 **
Hello Qlik Automate users and admins,
A series of changes have been identified across various GitLab APIs due to the deprecation of specific fields. For more information, see REST API deprecations (docs.gitlab.com).
As of the release of this post, GitLab has no official release date for API v5, and development has not yet started as of version 18.0.
merged_by: In the Merge Request API, the merged_by field has been deprecated and replaced with merge_user. The following block response will be affected:
merge_status: The merge_status field in the Merge Request API is deprecated and replaced with detailed_merge_status. The following block response will be affected:
default_branch_protection: The default_branch_protection field will be replaced with the default_branch_protection_defaults field. For more information, see default_branch_protection API field (docs.gitlab.com). The following block response will be affected:
Below you will find examples of responses with the deprecated (red) and new (green) fields.
[
{
"id": 1,
"iid": 1,
"project_id": 3,
"title": "test1",
"description": "fixed login page css paddings",
"state": "merged",
"imported": false,
"imported_from": "none",
"merged_by": {
"id": --,
"name": "--",
"username": "--",
"state": "active",
"avatar_url": "https://gitlab.example.com/--",
"web_url": "https://gitlab.com/--"
},
"merge_user": {
"id": --,
"name": "--",
"username": "--",
"state": "active",
"avatar_url": "https://gitlab.example.com/--",
"web_url": "https://gitlab.com/--"
},
"merged_at": "2018-09-07T11:16:17.520Z",
"merge_after": "2018-09-07T11:16:00.000Z",
"merge_when_pipeline_succeeds": true,
"merge_status": "can_be_merged",
"detailed_merge_status": "not_open"
}
]
{
"id": 96,
"web_url": "https://gitlab.example.com/--",
"name": "test-1",
"path": "test-1",
"description": "",
"math_rendering_limits_enabled": true,
"lock_math_rendering_limits_enabled": false,
"default_branch": null,
"default_branch_protection": 2,
"default_branch_protection_defaults": {
"allowed_to_push": [
{
"access_level": 40
}
],
"allow_force_push": false,
"allowed_to_merge": [
{
"access_level": 40
}
],
"developer_can_initial_push": false
},
"avatar_url": null
}
All the above blocks referencing these deprecated fields in the other block should be updated with the new fields.
If you have any questions, we're happy to assist. Reply to this blog post or take similar queries to the Qlik Application Automation forum.
Thank you for choosing Qlik,
Qlik Support

Qlik can be fun to use. Together with Inphinity Forms it can even be used to create/edit data, which are immediately loaded back into data model and evaluated.

The main goal of the app was to promote Qlik, Inphinity and Emark. The app attracted tens of participants from among Emark customers, but also general public.

Anybody with at least some interest in European football and data.

Inphinity Forms was used as data entry tool to manage list of matches, and collect bets from participants. Supporting statistics were loaded from ESPN website via REST API.
Don't miss our latest Q&A with Qlik! Pull up a chair and chat with our panel of experts to help you get the most out of your Qlik experience.
Hello Qlik Community,
We’re cruising through July and hope you’re enjoying the season—whether that means some time outdoors or diving into data! Today’s release brings a handful of updates to the Qlik Community that we’re excited to share:
Refreshed Header Design
We’ve made some updates to the Community header. The navigation menu has been moved to the left side of the screen, and the order of items has been reorganized. Greenway has been removed from the header and can be located in the Resource page. We removed the search icon at the top of the page so make sure to search with the main search bar. See the new layout and formatting changes below.
Before:
After:
Affiliate Badges are Live
Introducing our new affiliate badges! Members of our Luminary & Partner Ambassador Affiliate Program will receive their respective badges for all to see.
SearchUnify Maintenance
We completed some behind-the-scenes updates to SearchUnify, the engine that powers Community search. Talend has been added as a new content source, and usability improvements were made to help surface more relevant results and streamline the overall search experience.
Updated Sizing for Qlik Community Apps
We’ve adjusted the sizing of Qlik apps across the Community to ensure they render more cleanly across different devices. Whether you’re on desktop or mobile, the apps are now easier to view and interact with.
That’s all for now—thanks as always for being part of the Qlik Community. We’ll be back soon with more updates.
Your Qlik Community Managers,
Melissa, Sue, Jamie, Nicole, Tammy, Caleb and Brett
@Melissa_Potvin @Sue_Macaluso @Jamie_Gregory @nicole_ulloa @Tammy_Milsom @calebjlee @Brett_Cunningham

Getting Data Open using API. Predective Grafics using Insight Advisor Data since 2002 until now

Predective Grafics using Insight Advisor, showing how will be the future tax revenues

Finantial area is using to predict the future tax revenues

Getting data using API the automatic way. Finantial area is using to predict the future tax revenues
Hello Qlik Talend admins,
Qlik is updating the Qlik Talend Nexus repository. The changes are rolled out in a phased approach.
The changes will be rolled out in a phased approach. The first phase was deployed on July 16th, 2025.
The second phase will go into effect on January 26th, 2026.
The impact is minimal.
Qlik Talend Studio:
Qlik Talend Administration Center
For more information on how to handle missing JAR files, see Update to Qlik Talend Nexus repository: downloading and installing missing JARs.
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

Detailed Hunt Analysis: You can see a complete summary of each hunt, including its duration, location (like "Baruta"), total XP gained, and XP per hour, allowing you to evaluate the efficiency of your sessions. Loot and Financial Management: The dashboard details the total value of loot obtained in a hunt and the value spent, providing a clear view of the financial balance of your adventures (profit or loss). For instance, it's possible to identify significant items in the loot value. Monster Monitoring: You can track which monsters were encountered and the quantity of each during your hunts, helping to identify areas with higher creature concentrations. Item Tracking: The detailed log allows you to specifically see what was dropped, the quantity, and the individual value of each item, such as armors, potions, or gold coins.

It helped even more with my fun!

Roles/titles of users: There are no business roles or titles, as it is for personal use. Where it's displayed: It is likely displayed on the user's personal computer or on devices where they access Qlik for their gaming statistics. Usage frequency and importance to business: There are no business usage metrics or importance to a business, as the purpose is purely for leisure and personal tracking of in-game achievements.

There are no business usage metrics or importance to a business
Hello Qlik Automate admins and users,
The Run Conversational Task block in the Hugging Face connector has been deprecated and removed from Qlik Automate.
The block was removed due to Model Unavailability. The API used no longer supports any available models for execution under the conversational task.
You will no longer see the Run Conversational Task block in the Hugging Face connector.
Check Your Existing Workflows.
Review any workflows and automations that include the Run Conversational Task block and remove the block from the automation to prevent an execution error.
If you have any questions, we're happy to assist. Reply to this blog post or take similar queries to the Qlik Application Automation forum.
Thank you for choosing Qlik,
Qlik Support
テーブルって地味って思っていませんか?テーブルって、他のチャートと比べて文字や数字の羅列になりがちで華がないよなあなどと思っている人もいるのではないでしょうか?今回はテーブルを華やかにするアイデアをお伝えします。長文ですけど、下にいくほど面白いので最後まで読んでくださいね!
インジケーターやミニチャートはご存じですよね?ただ数字を表示するだけでなく、これらを使用すると直感的に理解しやすくなったり、さらに追加の情報を盛り込み、リッチな表現にすることができます。
下の図は特別なテクニックは全く使用していません。
1.インジケーター(アイコン)を利用しています。限度を1000000とし、上回る場合は緑の旗アイコン、下回る場合は赤の三角アイコンを表示しています。アイコンとともに値を表示するかしないか、値にもアイコンと同じ色を設定するかどうか、インジケーターの位置も調整できます。
2.ミニチャートを利用しています。テーブルの主軸は取引先ですが、その軸毎にさらに年月度を軸として、各月の値をミニチャートの棒グラフで表現しています。色もこまやかに指定することができます。
3.こちらもミニチャートですが、棒ではなく点線を表示しています。
4.ミニチャートのスパーク線を表示しています。
5.前月との差をミニチャートの正負で表示しています。負の場合は赤、正の色は青を指定しています。
ランキングによって絵文字を出すのはどうでしょう?ちょっと楽しくなります。簡単な数式で実現できます。
正と負の表現をアレンジしたのが下の図です。
利益率がマイナスの場合は左側に赤い棒と記号、正の場合は右側に青い棒を表示しています。
式を解説します。
まず、利益率が 0 以上の場合、空白を11回繰り返した後、縦棒「|」を1文字表示します。その後ハイフォン 「-」を繰り返すのですが、商品名ごとに求めた利益率の絶対値が最も大きい値に対する当行の利益率の比率を求め、それを整数に四捨五入した数の30倍の「-」を繰り返します。何倍にするかは線が適当な長さになるように決めます。そしてそのあとに「●」を表示します。
利益率が 0 未満の場合は、縦棒「|」の位置を12文字目に合わせるために、最大利益率に対する比率分の長さを10から減算して空白を繰り返したのち「●」を表示します。そして比率分の数の「-」を繰り返して「|」を表示します。
最後に利益率の値を1文字の空白後に表示します。色はテキストカラー表現に設定します。
マークを変えればこんな楽しい図にもできます。
だいぶ長くなっちゃいましたが最後にピボットテーブルを利用した、グループ別のウォーターフォールをご紹介します。
さきほどと同様のテクニックで商品区分別の最大値に対する各行に比率を求めて「■」を繰り返し表示します。1軸目の商品区分の行でない場合のみ、最初に空白を置いています。
テーブルもアイデア次第でビジュいい感じに盛れますね!
Happy Dueling !
** 過去の記事 **
The old saying, GIGO-garbage in, garbage out, stays relevant even today with the world of fast evolving technologies. In particular, the world of data-AI is no different. Your AI projects are majorly impacted by the quality of data and therefore data has to be "ready" for AI. What might be relevant for one particular AI project might not be relevant to another. Getting your AI project to deliver the right outcomes is dependent on the processes brought to the table with the data in question.
To learn more about how data can be ready for an AI project and what are the steps involved, read this article by Gartner: https://www.gartner.com/en/articles/ai-ready-data
To learn data analytics including free training and certifications, visit qlik.com/academicprogram
The Qlik Academic Program is being leveraged for getting trained in cutting edge data analytics technologies by more than 3300 universities and educational institutions worldwide.
It’s the 4th of July, so while real fireworks fill the sky, I’m flipping my tenant into a star-spangled skin, and I'll switch it back to default first thing Monday.
The holiday example is just a demo, what matters is that this is a repeatable pattern you can reuse for product launches, partner take-overs, dark-mode roll-outs or any scheduled swap.
How it works:
|
|
What it controls |
Think of it as… |
|
Brands API |
Logo, favicon, browser titles |
Signage |
|
Themes API |
Colors, fonts, object styling |
Paint |
|
Qlik Automate (Platform Ops connector) |
Timed / event-driven swaps |
Light switch |
1. Brands API refresher:
Key endpoints (all under /api/v1/brands) qlik.dev
POST /brands
POST /brands/{id}/actions/activate
POST /brands/{id}/actions/deactivate
GET /brands/active
2. Themes API at a glance:
3. The Automation glue:
Multiple connectors including the Platform Operations connector ship ready-made blocks, so anyone with Automate access can schedule branding swaps.
P.S (Not Tested): To switch an app's theme using Automate may require an externally hosted piece of code that uses the Engine API to swap the theme, as I was not able to do this via the existing blocks in Automate (yet).
Fourth-of-July Demo:
1/ Build the theme
patriotic-theme.qext
{
"type": "theme",
"name": "Patriotic-July-4",
"description": "Red-white-blue palette for Independence Day"
}
theme.json
Simple theme to get started:
{
"type": "theme",
"name": "Patriotic-July-4",
"properties": {
"color": {
"primary" : "#3C3B6E",
"accent" : "#B22234",
"background": "#FFFFFF"
},
"palettes": {
"data": [
{
"name": "Stars-and-Stripes",
"colors": ["#B22234", "#3C3B6E", "#FFFFFF"]
}
]
},
"object": {
"title": { "color": "@accent", "fontSize": "18px" },
"axis" : { "color": "@primary" }
}
}
}
- Zip the theme files into patriotic-theme.zip
- Then you can upload it to your tenant, or simply use qlik-cli to do that:
qlik theme create \
--file patriotic-theme.zip \
--name "Patriotic-July-4" \
--description "Red-white-blue holiday palette"
More on Qlik CLI here.
2/ Create & activate the brand
Docs/Tutorial: https://qlik.dev/manage/platform-operations/brand-a-tenant/
2.1/ Create a new brand
qlik brand create \
--name "Holiday Brand" \
--description "Independence-Day wrapper" \
--file-logo ./assets/logo-july4.png \
--file-favIcon ./assets/favicon-july4.ico
Response:
{
"active": false,
"createdAt": "2025-07-03T20:30:36.000Z",
"createdBy": "HdEcP-DYgrNwhQ6x2kw6CfidciVcoyz4",
"description": "Independence-Day wrapper",
"files": [
{
"contentType": "image/x-icon",
"eTag": "\"9feeaa2531d7ba38bef8e3198017188b\"",
"id": "favIcon",
"path": "/api/v1/brands/6866e86ca2aba070cf814c5f/files/favIcon"
},
{
"contentType": "image/png",
"eTag": "\"848074eaa51cb8997aacaa6b04d01a9a\"",
"id": "logo",
"path": "/api/v1/brands/6866e86ca2aba070cf814c5f/files/logo"
}
],
"id": "6866e86ca2aba070cf814c5f",
"name": "Holiday Brand",
"updatedAt": "2025-07-03T20:30:36.000Z",
"updatedBy": "HdEcP-DYgrNwhQ6x2kw6CfidciVcoyz4"
}
2.2/ Activate the brand
export BRAND_ID=6866e86ca2aba070cf814c5f
qlik brand activate $BRAND_ID
Response:
{
"active": true,
"createdAt": "2025-07-03T20:30:36.000Z",
"createdBy": "HdEcP-DYgrNwhQ6x2kw6CfidciVcoyz4",
"description": "Independence-Day wrapper",
"files": [
{
"contentType": "image/x-icon",
"eTag": "\"9feeaa2531d7ba38bef8e3198017188b\"",
"id": "favIcon",
"path": "/api/v1/brands/6866e86ca2aba070cf814c5f/files/favIcon"
},
{
"contentType": "image/png",
"eTag": "\"848074eaa51cb8997aacaa6b04d01a9a\"",
"id": "logo",
"path": "/api/v1/brands/6866e86ca2aba070cf814c5f/files/logo"
}
],
"id": "6866e86ca2aba070cf814c5f",
"name": "Holiday Brand",
"updatedAt": "2025-07-03T20:32:10.203Z",
"updatedBy": "HdEcP-DYgrNwhQ6x2kw6CfidciVcoyz4"
}
(Under the hood: POST /brands, then …/actions/activate.) qlik.dev
3/ Schedule with Qlik Automate
|
Block |
Settings |
|
Start (Scheduled run mode) |
2025-07-04 00:00 tenant time |
|
Activate Brand (Qlik Platform Operations) |
Brand = Holiday Brand |
|
List Items (Qlik Platform Operations) |
with Filter List condition: meta.tags's name equals "holiday-mode" |
|
(Not Tested) For Each Item → Call externally hosted EngineAPI code using Call URL block |
Your endpoint that receives appID and themeID and swaps the theme |
|
Send Slack Message |
“Patriotic Mode ON” |
To revert back:
Duplicate the flow → change trigger to 2025-07-06 00:00 → swap to "Deactivate Brand"→ patch apps back to "Sense Classic" (or default theme).
Some use cases beyond the Holiday:
|
|
Brands API |
Themes API |
Automate trigger |
|
Quarterly refresh |
Same brand |
Four seasonal themes |
Calendar |
|
Partner co-branding |
One brand per partner |
Partner-specific palette |
Tenant-creation webhook |
|
Dark-mode toggle |
Two brands (light/dark logo) |
Light & dark themes |
User button |
|
A/B color testing |
One brand |
Theme A vs Theme B |
Hourly schedule + metric logging |
Keep logo & favicon changes in brand, color tweaks in theme, and let Automate decide when it happens. Also, remember that the brands affect the whole tenant, so make sure to preview in a sandbox tenant.
Happy Independence Day .. and happy theming!