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:

• Client ID
• Secret
• JWT credential
• URL to query

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