For example, let say i create a routine that will pretty print JSON on log

package routines;

import org.apache.log4j.*;
import routines.system.JSONObject;

public class PrettyPrintJSON {
  private static org.apache.log4j.Logger log = LogManager.getLogger(PrettyPrintJSON.class);

  public static void print(String jsonPayload, String description) {
    try {
      JSONObject json = new JSONObject(jsonPayload); // Convert text to object
      log.info(description + " JSON  : \n" + json.toString(4));
    } catch (Exception e) {
      e.printStackTrace();
    }
    return;
  }
}

So when I use this routine on Tjava or inside another routine that uses non JSON string

String json ="sorry I not JSON man!";
PrettyPrintJSON.print(json,"Wakanda create case payload");

Seem the job still keep continue running and exit with status 0.

I expecting it to stop or exits with status 1

I'm attempting to use the mSendMail() subroutine in VBScript to first check if Outlook is already running. If Outlook is running, the script will proceed with sending the email using the existing instance of Outlook. Otherwise, it will start Outlook before sending the email.

The script works correctly when executed manually in the QlikView macro editor. However, when I attempted to run it from the Task Scheduler, it did not recognize the already running instance of Outlook. Instead, it opened another instance and could not send the email.

I expected the Task Scheduler to recognize the running instance of Outlook.

Below is the code:

Sub mSendMail(pdfFilePath)
Dim objOutlk
Dim objMail
Const olMailItem = 0

' Check if Outlook is already running
On Error Resume Next
Set objOutlk = GetObject(, "Outlook.Application")
On Error GoTo 0

' If Outlook is not running, start it
If (objOutlk = "") Then
StartOutlook
' Wait for Outlook to start
ActiveDocument.GetApplication.Sleep 5000 ' Wait for 5 seconds for Outlook to start
' Create a new instance of Outlook application
Set objOutlk = CreateObject("Outlook.Application")
End If

' Create a new mail item
Set objMail = objOutlk.createitem(olMailItem)

' Recipient's email address
objMail.To = "example@yahoo.com"

' Subject of the email
objMail.Subject = "Testing " & Date()

' Body of the email
objMail.HTMLBody = "Body of the email, This is an automatic generated email from QlikView."

' Add attachment (use the generated PDF file)
objMail.Attachments.Add pdfFilePath

' Send the email
objMail.Send

' Release resources
Set objMail = Nothing
Set objOutlk = Nothing
End Sub

Sub StartOutlook()
Dim oShell
Set oShell = CreateObject("Wscript.Shell")
oShell.Run "cmd.exe /K ""C:\Program Files\Microsoft Office\root\Office16\OUTLOOK.EXE"" ", 0, False
End Sub

Please, what can I do?

Hello,

Someone can help me: I'm trying to paste the iframe on an html page of my domain, but trying to log in, this page always returns the error message "connection denied nametenant.eu.qlikcloud.it"

Is there any setting to set up?

In practice: I made the sheet public, I took the embedded, I pasted it on my web page www.dominio.it/qlik.html and I pop up the notice described.

Hi,

I have data like this and when we do the calculation like below it ends up with duplicates.

if(num([cal date])-num(today())>0 and confirmed='N',1,0) as "Review Eve"

expression: sum("Review Eve") gives duplicates

09-05-2024

Hi everyone

Due to security requirements, we need to change the Qlik logo on QlikSense when a user hits an error, such as error 400 or Error 404. We need to remove or change only the logo so that the application is unidentifiable. Could someone point to a direction I can take to accomplish this?

In QlikView, you can set a variable's value at the time the QVW is opened, by using the 'Set Variable' action in the 'OnOpen' trigger. 

I know that in Qlik Cloud, field selections can be set to default values when the app is opened by defining the field selections in a Default Bookmark, but how do you set a variable's default value when the Qlik Cloud app is opened? I can't find a way to set a variable's default value within the Default Bookmark config, so how else can this be done in Qlik Cloud, to provide an equivalent to QlikView's 'Set Variable' feature in the OnOpen trigger?

Hi, 

Some of our customers at Next Decision, (FR) ask if collaboration and versionning on a same sheet/chart will be available soon. 
Since it can be serialized in JSON, I think it's quite easy to implement it, isn't it ?

Kind regards

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