Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Install Enigma JS:
npm install enigma.js
Bring it into your file:
import enigma from "enigma.js";
import schema from "enigma.js/schemas/12.612.0.json";
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>");
Install Nebula JS:
npm install @nebula.js/stardust
Bring in the "embed" function:
import { embed } from "@nebula.js/stardust";
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/
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!
Dear All,
I have recently installed Qliksense Feb 2024 version.
After installng I unable to start Qlik Logging servcies and getting below error.
I would appreciate if you coud have any suggestion on this ?
Best Regards,
Arunesh
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?
I want to hide the contents of a dashboard until two filters are selected:
Filter 1: Standard Type
Filter 2: Standard Version
Once these are both selected the dashboard should display. Is there a way to do this?
Thanks
Mark
Wondering about Qlik Talend Data Integration Sessions? There are 11, in addition to all of the Data & Analytics. So meet us in Orlando, June 3 -5.
Browse our helpful how-to's to learn more about navigating Qlik Community and updating your profile.
Join us on April 24th at 10 AM ET for the next Do More with Qlik webinar focusing on Qlik’s Data Integration & Quality solutions.
Your journey awaits! Join us by Logging in and let the adventure begin.
Qlik enables a frictionless migration to AWS cloud by Empresas SB, a group of Chilean health and beauty retail companies employing 10,000 people with 600 points of sale.
Qlik Luminary Stephanie Robinson of JBS USA, the US arm of the global food company employing 70,000 in the US, and over 270,000 people worldwide.
Join one of our Location and Language groups. Find one that suits you today!
A private group is for healthcare organizations, partners, and Qlik healthcare staff to collaborate and share insights..
Qlik Communityの日本語のグループです。 Qlik製品に関する日本語資料のダウンロードや質問を日本語で投稿することができます。
Welcome to the group for Brazil users. .All discussions will be in Portuguese.
Hear from your Community team as they tell you about updates to the Qlik Community Platform and more!