Hello everyone,  

I have a problem with RangeSum, I want to hide the red line from June to December 2024, this part of the fold does not make any sense in the chart. How do I hide it? Thank you!

Additionally，Grey and black lines need to show data for 12 months of the year.

The measure used for the red line: RangeSum(Above(SUM({<Year={2024}>}QTY),0,RowNo()))

Hello all,

I am trying to regroup some date.

As you can see my original field is Activities_Cannib_Eventtime is in the format 'MM/DD/YY hh:mm:ss'.

I want to have one field for one date. Actually I am having several date with a different timeline for the same date.

How could I only take one date for each date ?

For example : I want to have only one time 7/29/2016 in the last column 

I already used distinct but didn't work [Distinct(date(Activities_Cannib_Eventtime)]

Hi

We are trying to integrate data using Talend Studio from SAP via odata API (tOdatainput component)  but we get an 400 Bad Request error because it seems that Talend is calling a version 4 of the odata which is not active in SAP and we should be calling version 2 instead. We are trying to find in Talend Studio where the odata API version is selected but we cannot find it. Do you know how it can be done?

Rafael

Hi all,

i'm trying to login to qlik using a JWT token but when i try to post to https://horsadev.eu.qlikcloud.com/login/jwt-session with the the web integration id and the bearer token i get the following error.

the token is made up like this:

user details: name sub and email are the exactly like the console.

any idea of what can go wrong here?

thanks,

Loris

Bonjour à tous,

J'aimerai avoir une aide afin de gérer un Job qui doit durer plusieurs jours. J'interroge des tables de ma base MSSQL contenant dans des champs de contenu XML que je remets donc en forme etc.
Le problème est que tous les soirs nous avons une maintenance sur le serveur MSSQL de 21h à 2h environ. Cela entraine l'arrêt de mon Job, j'ai donc l'impossibilité d'aller jusqu'au bout.

Voici le message que j'obtiens :

Démarrage du Job Prod_B_Extract_Contenu_XML_2023_1 à 11:09 02/05/2024.
[statistics] connecting to socket on port 4035
[statistics] connected
Exception in component tDBInput_1 (Prod_B_Extract_Contenu_XML_2023_1)
java.sql.SQLException: Invalid state, the Connection object is closed.
	at net.sourceforge.jtds.jdbc.TdsCore.checkOpen(TdsCore.java:481)
	at net.sourceforge.jtds.jdbc.TdsCore.clearResponseQueue(TdsCore.java:767)
	at net.sourceforge.jtds.jdbc.JtdsStatement.reset(JtdsStatement.java:722)
	at net.sourceforge.jtds.jdbc.JtdsStatement.close(JtdsStatement.java:966)
	at easily_xml_specialites.prod_b_extract_contenu_xml_2023_1_0_1.Prod_B_Extract_Contenu_XML_2023_1.tDBInput_1Process(Prod_B_Extract_Contenu_XML_2023_1.java:2559)
	at easily_xml_specialites.prod_b_extract_contenu_xml_2023_1_0_1.Prod_B_Extract_Contenu_XML_2023_1.runJobInTOS(Prod_B_Extract_Contenu_XML_2023_1.java:4586)
	at easily_xml_specialites.prod_b_extract_contenu_xml_2023_1_0_1.Prod_B_Extract_Contenu_XML_2023_1.main(Prod_B_Extract_Contenu_XML_2023_1.java:4377)
[statistics] disconnected
 
Job Prod_B_Extract_Contenu_XML_2023_1 terminé à 21:54 02/05/2024. [Code de sortie  = 1]

J'ai bien essayé de mettre le code suivant dans un des mes composants tJava (dans la capture, tJava_5), mais rien n'y fait car une déconnexion à la base MSSQL a lieu, ce qui interrompt donc le Job.

LocalTime currentTime = LocalTime.now();
LocalTime startTime = LocalTime.parse("21:00");
LocalTime endTime = LocalTime.parse("02:00");
if (!currentTime.isBefore(startTime) && currentTime.isBefore(endTime)) {
    long sleepTime = java.time.Duration.between(currentTime, endTime).toMillis();
    Thread.sleep(sleepTime);
}

Je vous joint une capture d'écran de mon Job.

Pourriez-vous m'aider à trouver une solution à ce problème ? Merci à tous par avance.

Hello,

We have Qlik Sense Enterprise installed on a Windows VM. Each day of the work week, the VM automatically stop at 19:00. Each morning, we start manually the VM and the Qlik services are set to start automatically when the VM starts. Since the 15/04/2024, when we start the VM, the Qlik services stopped working properly. When the qlik services starts, its make the VM very slow and unnable to access. It takes around 1 hour for the VM to be accessible again. Once the VM is accessible, i'm able to access it and restart properly the Qlik services and then it starts working properly.

I've try starting every Qlik services in different order to identify the one causing the crash and i've found that it is the Qlik Scheduler Service. 

By waiting for the VM to be accessible, we are able to solve the problem but it is not very convenient since we have to wait some time and more than that, we would like to understand why the Qlik services stopped working properly. Before the 15/04/2024, everything was working fine.

Hello,

i have a pivot table and when I select a cell, Qlik only show the value of the two dimensions who are impacted by the cell.

What must I do to be able to select a cell and in the same time show all the pivot table and the value.

thanks for helping

Hi ,

I need to parse and load DB a pipe delimited file having data in the below structure using Talend.

Col1|Col2|Col3

"abc|111"|100|"zzz"

"xyz|222"|200|"yyy"

• Text fields are enclosed in double quotes.
• Few text columns contain the delimiter inside them.

I am using dynamic schema as there are are multiple files with different schemas.(but all files follow the above rules).

Issue : It is note able to parse the entire content inside double quotes (abc|111) as single field.

Please help.

Thanks

I have the following where I'm parsing raw files into a dbTable then I want to iterate to a second sub with a tForeach

See attached example screenshot

When I try to connect the tForeach2 to the Raw transactions I get an error

Thanks for any help