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: 
  • 249,760 members
  • 5,573 online
  • 2,032,197 posts
  • 152,998 Solutions

Welcome to Qlik Community

Recent Discussions

  • forum

    Visualization and Usability

    Last 12 months for each month in Backend script

    Hi Team, I want to display monthly analysis in bar chart where every month shows last 12months of sales. Want to create last 12months field  for every... Show More

    Hi Team,

    I want to display monthly analysis in bar chart where every month shows last 12months of sales. Want to create last 12months field  for every month in backend .
    example : Jan 2023,Feb 2023,March 2023,April 2023 these are my month dimension values in bar chart

    Jan 2023 means it has to show Feb 2022 to Jan 2023 sales sum

    Feb 2023 means it has to show March 2022 to Feb 2023 sales sum

    March 2023 means it has to show April  2022 to March 2023 sales sum

    April 2023 means it has to show May 2022 to April 2023 sales sum

    like that I want to show in bar chart.

    Please anyone help me to resolve this it is an urgent requirement in my project delivery.

    Regards,

    Anusha 

    Show Less
  • forum

    Qlik NPrinting

    NPrinting QlikEntity object caching hard limit?

    Hi,A customer is trying to build a QlikEntity Report from Qlik Sense on prem, but can't seem to find the object id in the list of the available object... Show More

    Hi,

    A customer is trying to build a QlikEntity Report from Qlik Sense on prem, but can't seem to find the object id in the list of the available objects.

    It looks like there is a hard limit on how many objects the interface can show in the drop down menu when creating the report, and we're not able to search for anything beyond the last value in the list.

    e.g. in the screenshot you can see the list ends with object id "8*******" something, but we know as a fact from the application interface that we have many object ids starting with "c****".

    francesco_menin_0-1746006655064.png

     

    Do you know of any such limitation? How can we work around this limit?

    francesco_menin_0-1746005486478.png

     

    Show Less
  • forum

    Qlik Replicate

    Suspended Tables (Databricks Target) due to "Transactional apply" Errors in "Bat...

    Hi everyone, I have a task in Qlik Replicate with target Databricks Lakehouse (Delta). Recently, many tables have been suspended due to the following ... Show More

    Hi everyone,

    I have a task in Qlik Replicate with target Databricks Lakehouse (Delta). Recently, many tables have been suspended due to the following errors:

    • "Performing 'update' operations in "Transactional apply" mode is not supported by Databricks Delta"
    • "Performing 'insert' operations in "Transactional apply" mode is not supported by Databricks Delta"
    • "Performing 'delete' operations in "Transactional apply" mode is not supported by Databricks Delta"

    The problem is that the task has always been set to "Batch optimized apply". Does anyone know why this is happening?

    Thank you in advance for any insights!

    Show Less
  • forum

    Management & Governance

    Obtain QMC information for tasks

    Hi.  Is there a way to get an export of the QMC tasks and the associated security.  So Task Name\App Name\Stream Name and all users or groups that hav... Show More

    Hi.  Is there a way to get an export of the QMC tasks and the associated security.  

    So Task Name\App Name\Stream Name and all users or groups that have access to the associated Stream.

    Thanks.

    Show Less
  • forum

    Visualization and Usability

    How to re-do a logic until satisfy the condition.

    Hello qlikers  I am trying to develop a planning model in script, currently i have certain constrains ... right now I have a table as below Item QT... Show More

    Hello qlikers 

    I am trying to develop a planning model in script, currently i have certain constrains ...

    right now I have a table as below

    Item QTY_on hand Ctime Plan Run time Available_time_Perday Optimized Run time
    Item-1 1718 0.5 576 288 1224 ?
    Item-2 1323 0.5 576 288 1224 ?

     

    now i want to calculate optimized run time through loop by using the below condition and logic

    Condition: sum (Current Optimized Run time) < Available_time_Perday 

    Logic to run : current Optimized Run time + Run time 

    stop condition: sum (Current Optimized Run time) > Available_time_Perday 

    and need to load the output in Optimized Run time column against respective Item

    Show Less
  • forum

    App Development

    Table Dimensions show top 10 only.

    Hi,I have a table with four dimensions, and I want to display only the Top 10 rows based on the largest values in one of those dimensions (let's call ... Show More

    Hi,

    I have a table with four dimensions, and I want to display only the Top 10 rows based on the largest values in one of those dimensions (let's call it Column X).

    My goal is to:

    • Sort the table by Column X (descending)

    • Show only the top 10 values by Column X

    • Keep the table dimensions-only (no visible measures)

    However, I’m running into a few issues:

    • The "Limitation" option is disabled when using only dimensions.

    • If I use Column X as a measure, it requires me to choose a dimension to group by, which doesn't give the correct granularity for my use case.

    • The only workaround I've found is to use Column X as both a dimension and a measure, then apply a limitation — but this displays Column X twice, and there’s no clean way to hide the extra column, which feels like a clumsy solution.

    To complicate things further, I plan to apply this approach in another table where I’ll also need to filter one of the dimensions beforehand, so I want a reusable and clean method.

    Is there a way to filter a table to the top N rows based on a dimension’s numeric value, without displaying the ranking field or duplicating columns?

    Thanks!

     

     

     
    Opens in new window
    PDF Download
    Word Download
    Excel Download
    PowerPoint Download
    Document Download
     
    Show Less
  • forum

    App Development

    4-4-5 Calendar

    Afternoon allWe have just changed our fiscal year to a 4-4-5 year where the start of the fiscal year is the last Monday in March unless 1st April is a... Show More

    Afternoon all

    We have just changed our fiscal year to a 4-4-5 year where the start of the fiscal year is the last Monday in March unless 1st April is a Monday then the start date is 1st April.

    I have been scouring the knowledge library and can't find an answer to how I can incorporate this into the autocalendar.

    I was hoping that getting this into the autocalendar would be the easiest way otherwise I will need to change all my apps.

    Any help would be greatly appreciated.

    Show Less
  • forum

    Talend Studio

    Upload file to qlik cloud in specific space

    Hello, i'm trying to upload a parquet file from talend studio into qlik cloud using the tQlikOuput component, i've succeded to upload it into my perso... Show More

    Hello, i'm trying to upload a parquet file from talend studio into qlik cloud using the tQlikOuput component, i've succeded to upload it into my personal space, but i need to use a different space, does anyone can give me any suggestion on how to achieve it if possible?

    Thanks, in advance,

    Vincenzo.

    Show Less
  • forum

    App Development

    Images missing after publishing on Qlik Cloud

    Hello,I'm publishing some apps in Qlik Cloud, (I'm using the functionality : right click on the Dev version in Shared Spaces / Publish). Sometimes ima... Show More

    Hello,

    I'm publishing some apps in Qlik Cloud, (I'm using the functionality : right click on the Dev version in Shared Spaces / Publish). Sometimes images are displayed in the Production Management Space, sometimes not ? 

    Can someone helps me to understand the logic ? 

    Regards

    Show Less
  • forum

    Visualization and Usability

    Sorting Dimension value when filters applied

    In my chart below I've applied filters in a table to only show data for a certain set of values.  This seems to throw off the sort (Max(Yearmonth) asc... Show More

    In my chart below I've applied filters in a table to only show data for a certain set of values.  This seems to throw off the sort (Max(Yearmonth) ascending). Any advice on how to either hide the Yearmonth values not showing data or how to force it to show the YearMonth in order is appreciated.

     

    Yearmonth is calculated from a date.

     

    orangebloss_0-1746015927727.png

     

    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!