Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi experts,
I have a bar chart and I want to sort the legend by specific order.
I need the specific color so I use the master item to set up the color palettes.
I found that I can use the following expression in the master item and it will show the order ascendingly.
Pick(Match(YOS_group, '<1 yr', '1-5 yrs', '6-10 yrs', '11-20 yrs', '21-30 yrs', '>30 yrs', 'NA'),
1,2,3,4,5,6,7)
However, the legend labels become the sequence.
I tried to use the reverse way to match the sequence and back to my original labels but failed.
Could you tell me how can I solve this problem? Thanks.
Hi Team,
I cannot see the Talend Academy full length Courses which included the Hands On Labs . Are there any updates going on?
Thanks,
Chirag
Team,
I already have a file named 'Company ID1.' When I tried to upload it again with updates, I suddenly started getting an error. I've never faced this issue before; it just started today. Can someone please help?
Thanks in advance!!!
Hi everyone,
I've googled but I cant understand how to find exclusion values in set analysis?
I have two tables, I concatenate them in one and used a flag ('table one'/' table two') so I could find some id which only one table has but I can't understand how to write it down
Business logic can be incorporated into Qlik's Insight Advisor. Doing so is the difference between relevant responses and accurate ones. It stands to reason that incorporating business logic into Qlik Answers would add similar value.
From a technical perspective, including well-defined business logic would improve user experience by lessening the impact of question phrasing, making it easier to ask the "right" question and improving answer consistency.
From a strategic perspective, assistants aware of business logic would generate answers that are more closely aligned with specific business objectives, needs, and regulatory requirements, making them more actionable and compliant.
The overall improvement to answers would contribute to a substantial efficiency gain for users.
Will this be possible in the future?
#QlikAnswers #BusinessLogic
Hello,
I would like to know how i can download an older version than the actual of Talend Studio (exemple, the current version is 2024-10, whereas, i want version 2024-03). Because, there is a new developer in the team, and we want to have the same version.
Thanks in advance.
Best regards.
Bérénice
We're attempting to replicate multiple Oracle tables in CDC and the task is suddenly failing. The log doesn't contain any warning, and the job is suspended due to 6 successive unexpected failures when we restart. Is there a way to identify what the issue is?
I have 2 tables: PRODUCTS and SALES. Each product can have zero or many sales, with each sale having a date, quantity, and value at the time of sale.
I want to create a sheet with filters so that I can show a table of the number and value of sales by product. I want to be able to show when a product has zero sales - this is rather important.
I also want to be able to apply filters to the products, such as brand.
Finally, I also want to be able to filter by date of sale but again showing all products that had zero sales in that time period.
I have tried the following measure
=SUM(sales_quantity)+SUM({1}0)
but while this gives me zeros for products without sales, it ignores all the filters.
I am having some issues getting the REST connector to pull the data I'm looking for on RingCentral. I've set up a REST application in the development console on ringcentral.com, and they provided the following:
The REST connector in Qlik, however, just has User ID and Password in the credentials area, so I am unsure how to proceed. Is there a way to use Client ID/Secret/JWT in the Qlik REST connector? Perhaps there are query parameters that I can use to pass this information to the API (cannot find this info on their site).
Thanks for any guidance!
Converting a hierarchical Bill of Materials (BOM) structure from the provided data
into a flattened format suitable for reporting in Qlik. The BOM hierarchy may contain an unknown
number of levels, and the structure should dynamically handle any depth. The final output must include
the lowest-level BOM component details and the Total Qty at the Lowest Level, which is calculated by
multiplying the quantities across all parent levels.
Requirements:
1. Dynamically flatten the BOM hierarchy regardless of the number of levels.
2. Include columns for all hierarchical levels found in the data.
3. The total quantity for each lowest-level component should be calculated by multiplying the
quantities from each parent level in the hierarchy.
Sample Data:
Items Table:
ItemID ItemName ItemGroupCode ItemGroup
1001 Motor MG001 Motors
1002 Shaft SG001 Shafts
1003 Gearbox GB001 Gearboxes
1004 Bearing BG001 Bearings
1005 Bolt BT001 Fasteners
1006 Washer WS001 Washers
1007 Nut NT001 Fasteners
1008 Pin PN001 Pins
BOM Hierarchy (Parent-Child Relations):
ParentItemID ChildItemID ChildItemQty
1001 1002 2
1001 1003 1
1003 1004 4
1003 1005 6
1005 1006 10
1005 1007 8
1007 1008 12
Output Format:
The flattened output should have the following structure. The number of BOM levels should adjust
dynamically based on the hierarchy in the data:
1. Parent Item ID
2. Parent Item Name
3. Parent Item Group Code
4. BOM Level 1 Code
5. BOM Level 1 Name
6. BOM Level 1 Item Group Code
7. BOM Level 1 Qty
8. BOM Level 2 Code
9. BOM Level 2 Name
10. BOM Level 2 Item Group Code
11. BOM Level 2 Qty
12. (Continue for additional levels as needed based on the hierarchy)
13. Lowest BOM Level Code
14. Lowest BOM Level Name
15. Lowest BOM Level Item Group Code
16. Total Qty at Lowest Level (Multiplied across all levels)
Additional Considerations:
• The Total Qty at Lowest Level must account for the multiplication of all parent quantities up to
the lowest level
Can anybody help me with that i tired but could get the result
Pencil in our most magical conference yet: 3 days of full immersion in data, analytics, and AI. May 13-15 | Orlando, FL
Fuel your data and AI journey with the right services, delivered by our experts.
With Qlik Answers™, get personalized, GenAI-driven answers from unstructured data, so you can make decisions with confidence. Learn how in our product roadmap keynote and demo.
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!