What some resources that have helped you develop your data modeling? I purchased a few Qlik tutorials on Udemy but find that the complexities of real world business application is hard to transfer. Just looking to the community for some advice on this and what has helped you regarding data modeling.

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
  

I'm facing a problem with a combo chart.
I want to show the maximum and the minimum value of a measure (only two highlighters), but minimum highlighter appears repeatedly in every month and far from the line.

Can someone help me, please?

MEASURE (line): count(distinct Chave_Contrato)

HIGHLIGHTERS
Max: =if(count(distinct Chave_Contrato)=max(total aggr(count(distinct Chave_Contrato),[Mês Ano Registro Contrato])),count(distinct Chave_Contrato),0)
Min: =if(count(distinct Chave_Contrato)=min(total aggr(count(distinct Chave_Contrato),[Mês Ano Registro Contrato])),count(distinct Chave_Contrato),0)

Thanks!

Hi all.

I have three tables which are linked through a common id (Management.id).

These are:

- Management table

- Details table; and

- Evidence table

When an item is deleted from the Management table in our front end we set a parameter [is deleted] to 1 and this is stored in the Management table (but none of the others).

When I join the tables through the Management.id I am loading up all of the data, but I only want to load up the records which have not been deleted.

- below is a cut down extract of the load script.

[tech_organizational_controls_management]:
LOAD
	[id] AS [Management.Management_id],
	[SOA_Version],
        [is_Deleted],
	[created_at],
	[updated_at],
	[standard_id];
SELECT id,
	`SOA_Version`,
	`is_Deleted`,
	`created_at`,
	`updated_at`,
	`standard_id`
FROM `xxxxxxx`.`tech_organizational_controls_management`;



[tech_organizational_control_details]:
LOAD
	[id] AS [control_details.id],
	[control_owner] as [Control Owner],
	[reason_control] as [Rationale],
	[control_implement] as [Implemented],
	[version_id] as [Details.Management.id],
	[object_id],
SELECT id,
	`control_owner`,
	`reason_control`,
	`control_implement`,
	`version_id`,
	`object_id`,

FROM `xxxxxxxxx`.`tech_organizational_control_details`;

[tech_organizational_controls_evidence]:
LOAD
	[id] AS [evidence.id],
	[evidence_type_value] as [Evidence Type],
	[evidence_type] AS [Evidence Category],
	[version_id] AS [Evidence.Management.id],

SELECT id,
	`evidence_type_value`,
	`evidence_type`,
	`version_id`,
FROM `xxxxxxxx`.`tech_organizational_controls_evidence`;

What is my best approach?

Thanks

Mark

I'm encountering an error while reloading the application Automation Monitoring app. It is used to work properly, but for the past8 days, i have been getting this error. Could you please help me to understand the issue?

stuck on this ...at a bar chart, want to show inactive customers with no sales during the past three month.

let's say I have time range as "Saledate = {">=$(=addmonths(Monthstart((vSaleMaxDate)),-3))<=$(=addmonths(Monthend((vSaleMaxDate)),-1))"}"

How do I add this into below so that I could have the set expression to have those customers who do not have any sales during the saledate period? 

sum({<[Customer Name]={"=sum([Sales]) = 0"}>} [Sales])

or maybe there is a better alternative without using any of these...

Hello, 

Is it possible to add section access to a data gateway so that when I access the tables in SQL Server the connector is pulling from, i can see all data, but another user with a professional license would only have access to certain data?