Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Welcome to
Qlik Community!

cancel
Showing results for 
Search instead for 
Did you mean: 
  • 253,007 members
  • 4,953 online
  • 2,034,954 posts
  • 153,230 Solutions
Announcements
Qlik Launches Open Lakehouse and advanced agentic AI experience in Qlik Answers! | LEARN MORE

Welcome to Qlik Community

Recent Discussions

  • forum

    Qlik Replicate

    How to replicate Store Changes headers in target tables without changing field n...

    Hello everyone,I'm trying to replicate specific headers defined in the Store Changes option directly into the target tables in Snowflake, in addition ... Show More

    Hello everyone,

    I'm trying to replicate specific headers defined in the Store Changes option directly into the target tables in Snowflake, in addition to their presence in the __CT (Change Tables). Specifically, I’d like to have the Store Changes headers (e.g., header__change_seq, header__timestamp) added as new columns to the target tables. These new columns should have the same names of the headers defined for the Change Tables.

    I tried using Global Rules within the task to add these headers as new columns, referencing their values from the Expression Builder (e.g., $AR_H_TIMESTAMP). However, when the task starts, the tables are suspended because Qlik Replicate attempts to create the Change Tables with duplicate fields, as these headers are already part of the Change Tables structure.

    Is it possible, and if so, how, to filter out the Change Tables when applying Global Rules? This would allow the headers to be added as new columns exclusively to the target tables and not to the Change Tables.

    I’ve found a few workarounds, but they are not without issues. I’m listing them below for the sake of clarity:

    1st workaround: First, I disable the Global Rules. Then I start a Full Reload of the task with the “Keep old changes and store new changes in existing change table” option enabled in Store Changes. After that, I enable the Global Rules and start another Full Reload. In this case the headers are added to the target tables and no error is encountered for the Change Tables since they have been already created. 

    Problems:

    • At least Two full Reloads are needed.
    • The addition of new tables in the replication task requires careful management of the Global Rules and multiple table reloads.

    2nd workaround: First, I remove the headers from the Change Tables by unchecking them in the Store Changes tab. Then I enable the Global Rules for all tables (including the Change Tables).

    Problems:

    • The Change Tables are defined without primary key. This may impact the replication performance.
    • Tables cannot contain LOBs.

    I’m also adding that our setup involves an Oracle source database and a Snowflake target.

    Thank you in advance for your assistance.

    Show Less
  • forum

    App Development

    Data Transformation in Qliksense

    Hi Team,I need to transform the below data.Required Output:  Can you please help on transformation data in Qlik sense Script.
  • forum

    Mobile

    Critical issue since the last update

    Bonjour,Depuis la dernière mise à jour de l'application sur Android. Il est impossible de changer les filtres. Une erreur "Critical Issue" apparait. C... Show More

    Bonjour,

    Depuis la dernière mise à jour de l'application sur Android. Il est impossible de changer les filtres. Une erreur "Critical Issue" apparait. Celà rend l'application inutilisable :(. Est-ce qu'il existe une solution ? Ou une mise à jour est-elle prévue?

    Merci !

    Corentin

    Show Less
  • forum

    Management & Governance

    Migrating Qlik Sense to New Server

    Hi,We need to migrate Qlik Sense Enterprise (May 2025) from Server 2012 R2 to Server 2025.I found the support articles that have detailed instructions... Show More

    Hi,

    We need to migrate Qlik Sense Enterprise (May 2025) from Server 2012 R2 to Server 2025.

    I found the support articles that have detailed instructions but couple of questions.

    1. When I install Qlik Sense May 2025 to new server can I use the same licence temporarily on the new and old server before we shut down the old server?

    2. When I do the backup of Qlik Sense on the old server I understood it does backup of everything (repository database, Qlik Share folder, QMC settings etc). Is that correct?

    Show Less
  • forum

    Deployment Framework

    Secure call to root container LCGV

    Hello I need help figuring out how to accomplish the following:We have 2 root containers: RC1 and RC2Is there a way to prevent developers from other t... Show More

    Hello 

    I need help figuring out how to accomplish the following:

    We have 2 root containers: RC1 and RC2

    Is there a way to prevent developers from other than team1 to make DCGV calls to RC1?

    Show Less
  • forum

    QlikView App Dev

    Is there a 'Lastsortedvalue' type function?

    I have 3 fieldsClientMonthRevenueI'm trying to pull into a straight table a chart that will list the CLIENTS and show REVENUE for the latest month whe... Show More

    I have 3 fields

    Client

    Month

    Revenue

    I'm trying to pull into a straight table a chart that will list the CLIENTS and show REVENUE for the latest month where the client had revenues.

    Some clients don't have revenues in the latest month and instead of showing a blank, I'd like to show the monthly revenue for the latest month where it existed.

    firstsortedvalue does the trick for the earliest month, but is there a function for the latest month?

    Thanks in advance!

    Show Less
  • forum

    Qlik Automate

    Automation Stops premautrely

    I have being trying to setup automation for 2 application to be refreshed every 5 mins (Extract and UI), using Loop and every automation will run for ... Show More

    I have being trying to setup automation for 2 application to be refreshed every 5 mins (Extract and UI), using Loop and every automation will run for 4 hours as maximum execution time for an automation is 14400 seconds, so we are ending our automation run when Runtime goes beyond 14300 second, keeping 100 seconds, buffer for next run to be scheduled,
    But sometimes the automation stop premautrely, Like around 2 hr and 30 mins in or 47 min run, it got finished, 
    without throwing any error, and the condtion was still false for (Runtime >= 14300), so It woulnt have ended.
    In the DO Reload block I have tried both wait for reload to complete and Start reload and continue, as we need 48 reloads per 4 hours, Start reload and continue seems the best option. but when the reload gets queued, the Loops keep giving output Reload Ongoing, till its finished, but soemtimes, its just ends the automation on the Loop without throwing any error, or sometimes, it just end on Sleep block.
    I'm attaching screenshots and Automation Template for your reference, 
    I would really appreciate if someone can help me on this issue.

    sunny_ryuke_0-1748939623772.png

    sunny_ryuke_1-1748939660169.pngsunny_ryuke_2-1748939680894.png

     

     

    sunny_ryuke_0-1748938236472.png

    sunny_ryuke_2-1748938315463.pngsunny_ryuke_3-1748938340746.png

     

    sunny_ryuke_0-1748939833472.pngsunny_ryuke_1-1748939850544.png

     

    Show Less
  • forum

    Water Cooler

    Meet Brett, Our New Community Intern!

    We’re excited to welcome Brett to the Qlik Community team this summer! Brett is joining us as an IT Community Intern and will be working closely with... Show More

    image (2).png

    We’re excited to welcome Brett to the Qlik Community team this summer! Brett is joining us as an IT Community Intern and will be working closely with us to support engagement, manage content, and keep things running smoothly behind the scenes.

    He’s currently a senior at Penn State, where he studies Human-Centered Design and Development. Outside of the classroom, Brett enjoys skiing, playing basketball, making music on the piano, and watching movies. (Bonus fun fact: he can juggle!)

    You’ll see him around the Community this summer, so feel free to say hello and help us give him a warm welcome—we’re thrilled to have him on board! @Brett_Cunningham @Sue_Macaluso @Melissa_Potvin @Jamie_Gregory @nicole_ulloa @Tammy_Milsom

     

    Show Less
  • forum

    Visualization and Usability

    Qlik Sense - Background color expression not working as expected?

    Within Chart --> Table I am trying to highlight rows based on the content (string) like below table. By using following expression within "Background ... Show More

    Within Chart --> Table I am trying to highlight rows based on the content (string) like below table. By using following expression within "Background color expression"

    If(Product='Apple', Yellow(), If(Product='Samsung', Green(), If(Product='Google', Blue(), Red())))

    Mr_Pearl_1-1631764058491.png

     

    However, I get below output,

    Mr_Pearl_2-1631764123292.png

     

    If I use my calendar to display only August and July then I get below output,

    Mr_Pearl_3-1631764211896.png

     

    Meaning only the latest month is getting displayed with right colors. I don't know what am i missing here. Can someone please help. I tried using Pick and match functions but still getting same result.

     

    Show Less
  • forum

    Qlik Automate

    How can I update the expressions of objects on a Qlik Sense sheet using Qlik Aut...

    I have a Qlik Sense application with a template sheet that contains a series of table and chart objects. Each day, depending on certain conditions, I ... Show More

    I have a Qlik Sense application with a template sheet that contains a series of table and chart objects. Each day, depending on certain conditions, I need to duplicate this template sheet and update specific parameters within the expressions of each object. I’ve created an Automation process that successfully duplicates the template sheet, but I’m unsure how to modify the expressions of the objects within the new sheet or how to change the sheet’s show/hide condition. Do you have any suggestions or ideas on how to achieve this?

    Show Less
Leaderboard

Customer Story

Optimizing Food Relief with Qlik

Qlik empowers Foodbank Victoria with real-time data insights, optimizing food acquisition and distribution to deliver 25 million meals annually while reducing waste and costs across its statewide relief efforts.

Customer Story

Data-Driven Strategies Set To Fuel Growth

Qlik accelerates decision-making at Alpha Auto Group, enabling seamless data integration and automation across dealerships, cutting reporting times, and driving scalable business growth.

Customer Story

Revolutionizing aircraft production through Data Analytics

Qlik Data Integration transforms Airbus' aircraft production, leading to over 150 replication tasks and informing more efficient analysis.

Location and Language Groups

Choose a Group

Join one of our Location and Language groups. Find one that suits you today!

Collaborate

Healthcare User Group

Healthcare User Group

A private group is for healthcare organizations, partners, and Qlik healthcare staff to collaborate and share insights..

All are welcome

Japan Group

Japan

Qlik Communityの日本語のグループです。 Qlik製品に関する日本語資料のダウンロードや質問を日本語で投稿することができます。

Request to join

Brasil Group

Brazil

Welcome to the group for Brazil users. .All discussions will be in Portuguese.

open to all

Blogs

Community News

Hear from your Community team as they tell you about updates to the Qlik Community Platform and more!