Skip to main content

Welcome to
Qlik Community!

cancel
Showing results for 
Search instead for 
Did you mean: 
  • 242,736 members
  • 5,335 online
  • 2,025,878 posts
  • 152,400 Solutions
Announcements
New: No-code data prep in Qlik Cloud Analytics™ TAKE A TOUR

Welcome to Qlik Community

Recent Discussions

  • forum

    Qlik NPrinting

    Nprinting powerpoint template - Intermittently missing chart colors/text blurred...

    Hello Everyone, Has anyone came across with this issue as per the image attached? Here is our current configuration -  Nprinting - Feb 2024 SR3 Qlik S... Show More

    Hello Everyone,

    Has anyone came across with this issue as per the image attached?

    Here is our current configuration - 

    Nprinting - Feb 2024 SR3

    Qlik Sense - May 2024 Patch 6

    1. The issue occurs intermittently, and re-running the process resolves it.

    2. When the Cycle field contains 100 values, only the initial few reports are affected. The number of impacted reports varies across incidents but is typically fewer than 25. I suspect this might be a synchronization issue between Sense and NPrinting, where the theme is not applied immediately when report generation starts, but everything functions correctly after the first few reports.

    3. Meta data reload is executed before the task runs. Both the meta data reload and tasks are triggered from the Qlik Sense trigger app using APIs.

    Please let me know if you need further details. Any assistance on this would be greatly appreciated.

    @Frank_S  @Lech_Miszkiewicz @Ruggero_Piccoli 

     

    Show Less
  • forum

    Visualization and Usability

    Min of AVG in Expression

    Hello together, I have the following data: Supplier Part ScaleQuantity OrderDate OrderQuantity 78268 98763 1 01.01.2024 328 78268 98763 50 01.0... Show More

    Hello together,

    I have the following data:

    Supplier Part ScaleQuantity OrderDate OrderQuantity
    78268 98763 1 01.01.2024 328
    78268 98763 50 01.01.2024 328
    78268 98763 100 01.01.2024 328
    78268 98763 500 01.01.2024 328
    78268 98763 1 23.04.2024 409
    78268 98763 50 23.04.2024 409
    78268 98763 100 23.04.2024 409
    78268 98763 500 23.04.2024 409
    78268 98763 1 16.08.2024 73
    78268 98763 50 16.08.2024 73
    78268 98763 100 16.08.2024 73
    78268 98763 500 16.08.2024 73

     

    OrderQuantity is repeated in the table for each ScaleQuantity.

    Target:
    I have to find out which scale quantity matches the order quantity and by what percentage the order quantity differs from the scale quantity.

    Procedure:
    Step 1:
    ScaleQuantity - Average of OrderQuantity
    Like: ScaleQuality - AVG(OrderQuantity)

    Step 2:
    Take anything >0
    Like: If(ScaleQuality - AVG(OrderQuantity) >0, ScaleQuality - AVG(OrderQuantity), Null())

    Step 3:
    Take the lowest value (min)
    Like: Min(If(ScaleQuality - AVG(OrderQuantity) >0, ScaleQuality - AVG(OrderQuantity), Null()))

    Because I have to select a time period afterwards, I unfortunately cannot create this in the script and have to write it in the expression.

    Result:

    Supplier Part ScaleQuantity OrderDate OrderQuantity
    78268 98763 500 01.01.2024 328
    78268 98763 500 23.04.2024 409
    78268 98763 100 16.08.2024 73

     

    Can you help me how I can implement this?

    Show Less
  • forum

    Administering and Monitoring

    Espace Disk /opt repository issue

    Hi Team, We have an issue on Talend Data intégration V7 server on the directory /opt . The espace disk is too hight and we don't know how to opitmise ... Show More

    Hi Team,

    We have an issue on Talend Data intégration V7 server on the directory /opt . The espace disk is too hight and we don't know how to opitmise and get some space. I checked the folder that take a lot of space and i found this one 

    ycham006_0-1736959293358.png

    But i don't know the files stored in this directories and i don't know if there are a system file witch we can't delete. Can you help us please ?

     

    Show Less
  • forum

    Application Automation

    Audit Events data in Qlik Cloud

    Hi, Is there a way to get the audit events data via api calls and store that data into qvd? also, for each api request its retreving only first 200 li... Show More

    Hi,

    Is there a way to get the audit events data via api calls and store that data into qvd?

    also, for each api request its retreving only first 200 lines of data.is there a way to fecth more lines of data /

     

    Regards,

    Raju

    Show Less
  • forum

    Connectivity & Data Prep

    Returning data based on Max Value

    Hi all, I'm porting some QV documents to QS, and we have an automated QV task that dumps a chart to a .qvd   As I understand it, this functionality do... Show More

    Hi all,

    I'm porting some QV documents to QS, and we have an automated QV task that dumps a chart to a .qvd

     

    As I understand it, this functionality doesn't exist in QS, and so I need to do it within the load script and store the table as a qvd (I presume)

     

    The try and describe the issue, we produce our products across various sites, and I need to ascertain when & where it was last produced.

    e.g for the below table:

    Product Location ProdDate
    1234 London 20241112
    5555 Paris 20241112
    1234 Paris 20250101

     

    My output should appear to be like:

    Product LastProduced LastProduceDate
    5555 Paris 20241112
    1234 Paris 20250101

     

    In QV, our table just has

    Product

    LastProduced = FirstSortedValue(distinct Company,-[Date])

    LastProducedDate = date(Max (Date),'YYYYMMDD')

     

    However, when done in a load script, I get a row for "London" and one for "Paris"

     

    Any ideas on how I can achieve this?

     

    Show Less
  • forum

    New! Qlik Answers

    Restrict number of displayed rows in a table

    Hi, I have a table with several columns (such as customer name, address, item, etc.). The table is sorted by sales amount from highest to lowest. I wa... Show More

    Hi,

    I have a table with several columns (such as customer name, address, item, etc.). The table is sorted by sales amount from highest to lowest. I want to limit the number of rows displayed to only first 10 rows. 

    I did not find anywhere in the table preferences any option that allows the above restriction to be implemented.

    How can I solve this request ?

    Thanks.

    Show Less
  • forum

    Deployment

    🚀 Accelerate Talend Job Automation with Devozy.AI: One-Click Deployment & Monit...

     Accelerate Talend Job Automation with Devozy.AI: One-Click Deployment & Monitoring Request a Demo and experience seamless Talend job automation!https... Show More

     Accelerate Talend Job Automation with Devozy.AI: One-Click Deployment & Monitoring

    Request a Demo and experience seamless Talend job automation!
    https://devozy.ai/request-demo.html

    Tired of the manual hassle of managing Talend jobs? Devozy.AI takes the complexity out of the process by automating deployments, tracking changes, and providing real-time insights — all with a single click! Transform your job management experience with streamlined efficiency and smart automation.

    🔹 Key Features & Benefits
    🏗 1. Parent-Child Relationship & Auto-Deployment
    ✔ Smart Dependency Mapping – Automatically detects parent-child jobs
    ✔ One-Click Deployment – Deploying a parent job triggers all child jobs
    ✔ Visual Insights – View job dependencies in a clear workflow

    🎯 2. One-Click Deployment for Modified Jobs
    ✔ Auto-Detects Changes – Highlights recently updated jobs
    ✔ Instant Deployment – Deploy in one click
    ✔ Version Control – Rollback to previous versions anytime

    📤 3. Promote Artifacts & Workspaces with Ease
    ✔ Move Artifacts & Workspaces – Transfer resources seamlessly
    ✔ Task-Based Promotion – Promote tasks individually without deploying the full workflow
    ✔ Environment Support – Enable structured movement between DEV → QA → UAT → PROD

    📊 4. Real-Time Insights & Monitoring
    ✔ Live Dashboard – Track job execution & logs
    ✔ Performance Analytics – View execution time, success rate
    ✔ Alerts & Notifications – Get instant updates via Slack, Teams, Email

    🔄 5. Multi-Project & Multi-Account Support
    ✔ Manage Multiple Accounts – Seamlessly handle multiple Talend projects
    ✔ Parallel Builds & Deployments – Execute jobs faster across different environments
    ✔ Centralized Control – Unified platform to monitor all builds & jobs

    🚀 Why Choose Devozy.AI?
    100% Automation
    Error-Free Execution
    Multi-Cloud Support (AWS, Azure, GCP)
    Cost & Time Efficient

    🔹 Start automating your Talend Jobs today! Request a Demo https://devozy.ai/request-demo.html🚀
    🔥 See Devozy.AI's Talend Job Automation in Action!

    Detailed Stage View with Execution StatusDetailed Stage View with Execution StatusArtifacts: Build with generated JAR and POM filesArtifacts: Build with generated JAR and POM files

    Show Less
  • forum

    App Development

    Hyperlink in the New Pivot Table wont work

    adding the URL ist no Problem but i cant open the URL. Instead qlik filters on the Value.   does anybody else has this problem?
  • forum

    Visualization and Usability

    FilterPane Search Color in Qlik Cloud

    Hi, I've recently encountered an issue with the background color of the search input in the filter panes. A couple of months ago, I noticed that the c... Show More

    Hi,

    I've recently encountered an issue with the background color of the search input in the filter panes. A couple of months ago, I noticed that the color of the search input was dark gray, which doesn't fit my custom theme.

    I tried adding the following CSS expression to the .css file in my custom theme, but it isn't working:

    .search{
        background: white !important;
    }
     

    Interestingly, when I add the same expression in the Multi KPI object, it works as expected.

    I would appreciate any help or suggestions to resolve this issue.

    Thanks!

    Show Less
  • forum

    Application Automation

    Coding in Qlik - Retrieve latest value of the previous year if value has not bee...

    Hello everyone, I would like to ask for your help. I have a table with the following fields: Item Code, Date of update, Value, Year. I have to calcula... Show More

    Hello everyone, I would like to ask for your help. I have a table with the following fields: Item Code, Date of update, Value, Year.

    I have to calculate the latest value of "Value" field for each year;

    If  the value is not updated, I must take the latest value of the previous year. I've already calculated the latest value for each year using lastvalue () and group by.

    I'm having troubles in the "creation" of the year if the value has not been updated in that year, peeking the latest value of the previous year.

    I attach an example:

    Cla10_0-1738922632896.png

     

    I've tried different approaches but none of them gave me the result in red.

    Thank you for the support! 

    Show Less
Leaderboard

Customer Story

Accelerating Decision-Making with Qlik Insights

Qlik enhances decision-making with high-speed insights, as Mayborn Group integrates data from various functions across their global operations, gaining a competitive edge in the childcare industry.

Customer Story

Efficiency in Agriculture: Nortera's Qlik Triumph

Nortera leads agricultural manufacturing analytics and automation with Qlik, reducing short-shipment rates and annual savings in water consumption.

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!