Hello,

I have a data set of 1.3 million rows. For a lot of the visuals I require a long table so when i create a long table it produces 153 million rows. The widgets have a hard time loading that much data especially when the widget is using the long table. the long table gives me what im looking for in the visuals but the widget loading is really bad, Is there any other options that has the same functionality of the long table? 

Dear gurus 

There are so many similar posts in here but try to understand it may takes some time. Hence i decide to post it here using my table.

I have 2 tables - Staff and Form_Submission. Both table contains column 'Name' and 'UserIds'

In the load editor how am i suppose to write the script so that i want to know which staff in table Staff has never submit a form. I saw lots of example using Not Exist. Just hope that someone can help me by using my scenario here . TQ ! 

Hi Community,

I'm currently working with Oracle 19c as a source, and I've some tables without primary keys. Need to configure a task for a full load with Change Data Capture (CDC). How should I proceed in managing the absence of primary keys in this scenario? Your guidance on handling this situation would be greatly appreciated.

Regards,

Pranita 

Hello Everyone, I am new to Qlick and use trial version since yesterday. Following tutorial, it is requested to select "auto ML experiment" from the "Add New" drop down menu. But, This field is missing. I am wondering whether this is because I am using a trial version of Qlick...?

Does someone know about it ?

Thank you for your help

Hi all,

i have the following two tables:

Contracts:

Risks:

I am seeking a way to transform the two table into one table with the following structure:

Result:

Of course the Contract table contains multiple ContractIDs with different periods. I am aiming for a result table that contains for every given Valid_From / Valid_To the information whether any of the possible risks is included.

Thanks in advance for some help here!

Hi All,

We were trying to upgrade our QlikSense enterprise version from August 2022 to February 2024. 

Steps:

 - All services related to QlikSense were stopped (PostgreSQL was running).

- Installed Feb 2024 version, Installation window was success. Pls see below screen. 

- Clicked on Finish.

All the Services which was stopped before the installation was running post this installation. But we were not able to launch/use/ QlikSense. 

The Server was not reachable post installation. we captured details from the logs folder and restored the Windows server version with the snapshot. 

Please suggest what might be the issues due to which the the server was not reachable post installation. 

Thanks in advance. 

Hey everyone, I figured out how to display charts and insights from a Qlik app on my React website using Enigma JS & Nebula JS. 

This will come in handy, especially if you're working with a client-managed setup, as embedded links and the Capability API support might be a bit lacking.

Now, here's the catch - this method works like a charm for Qlik's stack charts, but if you're jazzing up your charts with extensions like VizLib, you might hit a roadblock. Check out the supported chart types here.

First up, let's connect to your app with Enigma JS

1. Install Enigma JS:

   npm install enigma.js
   

2. Bring it into your file:

   import enigma from "enigma.js";
   import schema from "enigma.js/schemas/12.612.0.json";
   

3. Time to connect to your Qlik App:

   const session = enigma.create({
     schema,
     createSocket: (url) => {
       const socket = new WebSocket(url);
       socket.addEventListener("error", (event) => {
         setError(new Error("WebSocket error"));
         console.error("WebSocket error:", event);
       });
       return socket;
     },
     url: "<ADD THE APP URL HERE>",
   });
   
   const global = await session.open();
   const app = await global.openDoc("<ADD THE DOC ID HERE>");
   

Moving on to Nebula JS for chart renderings:

1. Install Nebula JS:

   npm install @nebula.js/stardust
   

2. Bring in the "embed" function:

   import { embed } from "@nebula.js/stardust";
   

3. Let's dive into a Pie Chart:

    

   a. Get the sn-pie-chart:

   npm i @nebula.js/sn-pie-chart
   

   b. Import it:

   import snPieChart from "@nebula.js/sn-pie-chart";
   

   c. Now, time to put that pie chart on display:

   const pieChartNebula = embed(app, {
     types: [
       {
         name: "piechart",
         load: () => Promise.resolve(snPieChart),
       },
     ],
   });
   
   pieChartNebula.render({
     element: document.getElementById("pie-chart"),
     id: "<ADD THE PIE CHART'S OBJECT ID>",
   });
   

I wouldn't exactly call this the top-notch method. If you happen to have any other ideas that might work better, I'd be super grateful if you could share them with me!

To know more about Nebula JS APIs - https://qlik.dev/apis/javascript/nebula-js/ 

Connect with Me
  

Before I start:

Talend Open Studio for Data Integration v8.0.1.20211109_1610

Windows 10

Java 17.0.8.7-hotspot

jtds driver

I am trying to Guess Schema for a tDBInput (Microsoft SQL Server) component. I get the missing library dialog, but there is no way to download the missing jar file.

I have a good connection to the internet as I am able to download and install other libraries. Just this one fails. Not even sure why I am getting this dialog on v8.0 as it does not happen with v7.3.