Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
The issue occurs intermittently, and re-running the process resolves it.
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.
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
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?
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
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 ?
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
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?
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.
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 Status
Artifacts: Build with generated JAR and POM files
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:
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!
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:
I've tried different approaches but none of them gave me the result in red.
Thank you for the support!
Data Flow simplifies, democratizes, and accelerates the last mile of data preparation for analytics, machine learning, and AI.
Attendees get two free certification exams included with their event registration (valued at $500).
Read how to embed AI-powered analytics to innovate, enhance customer satisfaction, and fuel business growth.
Browse our helpful how-to's to learn more about navigating Qlik Community and updating your profile.
Your journey awaits! Join us by Logging in and let the adventure begin.
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.
Nortera leads agricultural manufacturing analytics and automation with Qlik, reducing short-shipment rates and annual savings in water consumption.
Qlik Data Integration transforms Airbus' aircraft production, leading to over 150 replication tasks and informing more efficient analysis.
Join one of our Location and Language groups. Find one that suits you today!
A private group is for healthcare organizations, partners, and Qlik healthcare staff to collaborate and share insights..
Qlik Communityの日本語のグループです。 Qlik製品に関する日本語資料のダウンロードや質問を日本語で投稿することができます。
Welcome to the group for Brazil users. .All discussions will be in Portuguese.
Hear from your Community team as they tell you about updates to the Qlik Community Platform and more!