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.

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!