Hi Qlik Community

I need to enrich a column, lets call it value.

"Value" has a corresponding ID column.

In my main table I have a table if IDs and values but some values are blank.

In a second table I have the same columns but values that are missing from the main table.

How do I enrich my main table with the missing values from the second table?

//Casper

Hello

In my Datamodel there is a calendar, linked to the fact table, as usual…:

Now, the measure in the table below has a set analysis which selects the dates above April 20^th

The field “DataMovSettimana” contains the week, it is calculated in the script as Week(DataMov).

As you can see, the current selection is DataMovSettimana=18.

Then, as expected, the result is the intersection of the set analysis and the current selections, thus showing only dates pertaining to week 18.

So, the result of the table below is the expected one.

Then, I remove the dimension “DataMovSettimana” from the table, without modifying anything in the selections, and the result is shown below:

As you can see, the measure total value is different as it apparently disregards the selection of the week. Moreover, the espression “week(DataMov)” is not calculated for the dates excluded in the set analysis.

Then, I remove one of the selections (not the week). Now the result is correct….

Moreover, how this can be explained?

In order to debug it, I made a copy of the date fields, both in the fact table and in the calendar table

This is the result. Does it make sense? Anyway, it is a workaround for me in order to get correct results.

I guess there is some datamodel issue but I am running out of ideas to throubleshoot it.

Any suggestion?

Hi,

I need help to create this table in Qlik Sense. The Row A and B are coming from source, and I need to derive the row (highlighted in yellow) in Qlik using measure expression. Below the highlighted rows in yellow are the excel formula to drive the row-wise calculation.

I need to do it in the table (chart) only, not in the script. Thank you for your time and support in advanced! 

Thanks,

SK

I aim to retrieve all the data from our Freshdesk ticketing system. However, I've encountered a limitation with the API, which only permits a maximum of 100 data entries per page.

As we have over 1,000 contacts to gather and store in our database, I'm currently facing a challenge in looping back to the tRESTClient to fetch the next set of data and appending it to my CSV file.

Here's my current setup: tRESTClient -> tXMLMap -> tLogRow -> tFileOutputDelimited. My end goal is to be able to fetch all the contact details and store it to our MySQL DB. 

I am very new at using Talend so any guidance on how to proceed would be greatly appreciated.

Hello I am using a student account, Im the tenant and I have all privileges. Even that I have already consent the generation of API Keys and also I have given me the role of developer.  

When I try to generate an API key it throws me a message saying that the content im trying to acces is restricted or not accesible.

Hello, 

Recently SAP has announced change in their Terms & Co which does not permit (although no hard stop yet) SAP connection type: ODP through RFC. 

Are there any plans for upgrades of SAP connector ?  Or it is already using different connection type and therefore its "future-proof" ? 

Thank you in advance, 

Hello, 

When I make the configuration of the mail,
I have this Error message

and there is the log message

"Failed to send e-mail message to xx@xx.com ERROR: System.Net.Sockets.SocketException (0x80004005): A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond 52.98.227.162:995↓↓ at System.Net.Sockets.Socket.DoConnect(EndPoint endPointSnapshot, SocketAddress socketAddress)↓↓ at System.Net.Sockets.Socket.Connect(EndPoint remoteEP)↓↓ at System.Net.Sockets.Socket.Connect(IPAddress address, Int32 port)↓↓ at MailKit.Net.Smtp.SmtpClient.Connect(String host, Int32 port, SecureSocketOptions options, CancellationToken cancellationToken)↓↓ at Qlik.NPrinting.Repo.Service.MailService.<SendEmailAsync>d__4.MoveNext() in C:\Jws\release-may2023-cw4ys0k9S\server\NPrinting\src\Repo\Service\MailService.cs:line 73"
Can you help me please?


PS:There is proxy installed in the Virtual Machine.