Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I'm working on creating a report in Excel using NPrinting. I have a table with up and down arrows showing the increase/decrease in values based on 2 years. When trying to add the table in NPrinting Designer, unable to import the table with borders and alignment from the source. If I uncheck the 'Source Format' option, I'm able to import the table but lose the color codes for the up/down arrows. I tried using conditional formatting in Excel but the expression in Qlik Sense is too large to use in Excel. Is there any workaround for this issue? Please help.
Buen día comunidad
Requiero ayuda con lo siguiente, tengo dos tablas:
Historico: con el campo ID:[1,2,3,4,5]
Mes: ID[1,2,6,7,8]
No he podido hallar la forma de cruzar las dos tablas para obtener los registros no coincidentes, lo que deseo es saber mediante un script los registros de la tabla del Mes que no están en el Histórico
Could anyone help me identify what might be wrong with this code, as it's returning error 401 AUTH-1
All,
I am new to Qlik and wondering if this is possible to acheive in qlik sense.
Requirement:
sum consecutive rows in a pivot table and add it as another/new row.
Please see the attached for sample data reference.
For example in the attached qvf .. i want to sum MMR + NAT i.e 10000+670 and add the sum 10670 as a new row below it .
MMR
NAT
MMR+NAT
PC
TAR
ULP
I want to do this for multiple rows and the data set will be static data set .
Please let know if the requirement is not clear, appreciate any help or guidance on this.
Thank you,
RV
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!
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!