Recent Discussions
-
Unable to sort by measure in bar chart with multiple dimensions, how can I add t...
I would prefer to sort by the measure value, but that does not seem to be an option when using multiple dimensions. How can I filter this by the top... Show MoreI would prefer to sort by the measure value, but that does not seem to be an option when using multiple dimensions.
How can I filter this by the top 20 (for this example).
Sum(
{<CustomerID = {"=Count(DISTINCT Make) > 1"}>} SalesPrice
)My use case is that I want to see the total sales price for customers who have more than one of the selected makes.
I have attached my demo app. The chart I am using is on the Question 0225 sheet.
-
Problem with "sum" with dimension
Hello, I have folowing columns: ORDER INSTRUCTION 100 PALLETS: 10EUR; 05EUR-N; 01OWA; 00OWA-N; 00CHEP; 00MAX; 00LOM 110 PALLETS: 00EUR; 05EU... Show MoreHello,
I have folowing columns:
ORDER INSTRUCTION 100 PALLETS: 10EUR; 05EUR-N; 01OWA; 00OWA-N; 00CHEP; 00MAX; 00LOM 110 PALLETS: 00EUR; 05EUR-N; 01OWA; 00OWA-N; 00CHEP; 00MAX; 00LOM 120 PALLETS: 06EUR; 03EUR-N; 01OWA; 00OWA-N; 00CHEP; 00MAX; 00LOM 130 PALLETS: 06EUR; 05EUR-N; 01OWA; 00OWA-N; 00CHEP; 00MAX; 00LOM I prepared sum for each order with following dimetion
=num(textbetween(INSTRUCTION,'S:','EUR')
+
textbetween(INSTRUCTION,'EUR;','EUR-N')
+
textbetween(INSTRUCTION,'EUR-N;','OWA')
+
textbetween(INSTRUCTION,'OWA;','OWA-N')
+
textbetween(INSTRUCTION,'OWA-N;','CHEP')
+
textbetween(INSTRUCTION,'CHEP;','MAX')
+
textbetween(INSTRUCTION,'MAX;','LOM'))so, I recieved following table in dimention
ORDER TOTAL 100 16 110 6 120 10 130 12 I have to prepare table with total qty of pallets. I mean that that result shold be:
ORDER TOTAL 4 44 I do not have any problems with ORDERS. But I cannot recieve TOTAL from above tabel. I try to creat master item but it's not visible in measure.
Could you please help me?
-
Mashup conflicts with bootstrap
When building a mashup and bringing it into react. I have created a basic react app using create-react-app and was able to fully integrate with qlikse... Show MoreWhen building a mashup and bringing it into react. I have created a basic react app using create-react-app and was able to fully integrate with qliksense using mashups. However bringing it into my actual product, bootstrap is having conflicts. I have to bring in my own bootstrap for my product and when i try to use qliks require it brings in bootstrap so there are conflicts.
Environment Context: Qliksense Enterprise Nov 2024, behind SSO using OIDC through keycloak.
here is some context for my basic react app:
Index.html:<!DOCTYPE html> <html lang="en"> <head> <meta charset="utf-8" /> <link rel="icon" href="%PUBLIC_URL%/favicon.ico" /> <meta name="viewport" content="width=device-width, initial-scale=1" /> <meta name="theme-color" content="#000000" /> <meta name="description" content="Web site created using create-react-app" /> <link rel="apple-touch-icon" href="%PUBLIC_URL%/logo192.png" /> <!-- manifest.json provides metadata used when your web app is installed on a user's mobile device or desktop. See https://developers.google.com/web/fundamentals/web-app-manifest/ --> <link rel="manifest" href="%PUBLIC_URL%/manifest.json" /> <link rel="stylesheet" href="https://%QLIK_SERVER_IP%/%QLIK_OIDC%/resources/autogenerated/qlik-styles.css"> <!-- <link rel="stylesheet" href="Examples.css"> --> <!-- Notice the use of %PUBLIC_URL% in the tags above. It will be replaced with the URL of the `public` folder during the build. Only files inside the `public` folder can be referenced from the HTML. Unlike "/favicon.ico" or "favicon.ico", "%PUBLIC_URL%/favicon.ico" will work correctly both with client-side routing and a non-root public URL. Learn how to configure a non-root public URL by running `npm run build`. --> <title>React App</title> <script src="https://%QLIK_SERVER_IP%/%QLIK_OIDC%/resources/assets/external/requirejs/require.js"></script> </head> <body> <noscript>You need to enable JavaScript to run this app.</noscript> <div id="root"></div> <div> <!-- This HTML file is a template. If you open it directly in the browser, you will see an empty page. You can add webfonts, meta tags, or analytics to this file. The build step will place the bundled scripts into the <body> tag. To begin the development, run `npm start` or `yarn start`. To create a production bundle, use `npm run build` or `yarn build`. --> </body> </html>
Segment of App.js:if (typeof window.require === "undefined") { console.error("Qlik is not loaded"); return; } var config = { host: QLIK_SERVER_IP, prefix: "/QLIK_SSO/", port: "443", isSecure: true, }; const baseUrl = (config.isSecure ? "https://" : "http://") + config.host + (config.port ? ":" + config.port : "") + config.prefix + "resources"; window.require.config({ baseUrl: baseUrl, }); console.log("base url", baseUrl); window.require(["js/qlik"], function (qlik) { console.log("qlik library loaded", qlik); var appDS = qlik.openApp(APP_ID, config); }
Then here is when i am importing into my product:
index html:<!DOCTYPE html> <html lang="en"> <head> <meta charset="UTF-8"> <meta name="viewport" content="width=device-width, initial-scale=1.0"> <link rel="stylesheet" href="../assets/css/bootstrap.min.css"> <link rel="stylesheet" href="../assets/css/line-awesome.min.css"> <link rel="stylesheet" href="../assets/css/main.css"> <link rel="stylesheet" href="https://%QLIK_SERVER_IP%/%QLIK_SSO%/resources/autogenerated/qlik-styles.css"> <style> #table-card { height: 48vh; overflow-y: auto; } </style> <script src="https://%QLIK_SERVER_IP%/%QLIK_SSO%/resources/assets/external/requirejs/require.js"></script> <script src="../assets/js/bootstrap.bundle.min.js"></script> <script src="../assets/js/main.js"></script> <script src="../assets/js/qlik-setup.js"></script> </head>
The app.js is the same as my dev environment. The error occurs when i try to do the window.require.config({}).
Some ideas or solutions i would love some help with:Is it possible to override qlik's bootstrap (it could break things but that can be handled in our product)
is it possible to have qliks visualizations be separated out using different bootstraps?
is it possible to make my qlik a deliverable and have it be separated out similar to the previous question?
im trying to avoid any iframe usage
Any other information needed and i can give it.
-
How to learn making the frond end to the backend (in data load editor)
Hi Everyone!! I’ve developed an application and using valuelist function and pick match with it to create my dimensions and wrt that I’ve created meas... Show MoreHi Everyone!!
I’ve developed an application and using valuelist function and pick match with it to create my dimensions and wrt that I’ve created measure for each subfield.
eg -
dimension measure
A - sum({< account=‘123’>}Sales)
B - sum({< account=‘786’, segment <> ‘67’>}Sales)
C - sum({< account={‘999’,’456’}, segment=‘12’>}Return)
And so on. I’ve created almost 100 + dimensions with different calculation and stored it in variable. Due to this it is taking more than 2 minutes to show the chart.
I need to calculate it in the backend so that it will fast in the front end.
Important thing is all the fields which are there in my set are coming from different tables.
How can i achieve the result in backend…
Your input will be very helpful for me.
Thanks in advance…. -
How to check for digits next to commas in strings
Hi Everyone 🙂I'm kind of lost😅So i have names of products in my table.Let's say this is my table: tab1:LOAD * INLINE [Name'DEER WITH FUZZ, 235X60X26... Show MoreHi Everyone 🙂
I'm kind of lost😅
So i have names of products in my table.
Let's say this is my table:tab1:
LOAD * INLINE [
Name
'DEER WITH FUZZ, 235X60X265MM, WHITE COLOUR, 2 ASSORTED COLOURS, HANGTA',
'Glue, color.happy GOSPO',
'FIGURe LED 8,5CM AcRYL MIX WZ',
'animal SOLAR, MO',
'candle ceramic tree 6,',
'DOUCHET.3JETS+FLEX1,75M+BA,1P',
'DECOR ALU CLOTUREO 178x41,,1P',
'CAA AUTO REPARANTE 27,5'' SV,1P',
'PNEU 16X1,75 47/305 BMX,1P',
'Dog ceramic BIG',
'ribbon JUTY 6,3CM X 2,7M NAT',
'RIBBON 21CM 19,5G,'
];I know names are strange but what I need is to find names with commas except those names where commas are surrounded with digits, for example 34,13.
i want to look for names where commas (if used) are not commas showing decimal places.
If there are a lot of commas and each of them has digits(so it's a number) it's okay
SO:FIGURe LED 8,5CM AcRYL MIX WZ okay, one comma with digits on its left and right
ribbon JUTY 6,3CM X 2,7M NAT okay, since both commas has digits on its left and right
RIBBON 21CM 19,5G, not okay since there is a comma which purpose isn't to show decimal places --> not surrounded with digits
animal SOLAR, MO not okay, comma not surrounded with digits
Dog ceramic BIG okay, no commasI tried something like this in chart:
=If(
SubstringCount(Text(Name), ',') = 0,
'No commas',
If(
SubstringCount(Text(Name), ',') = 1 and
IsNum(Mid(Text(Name), FindOneOf(Text(Name), ',') - 1, 1)) and
IsNum(Mid(Text(Name), FindOneOf(Text(Name), ',') + 1, 1)),
'Only one comma and it has digits',
'The rest'
)
)
BUT it only check for first comma,
i didn't know how to write it differently
i guess it can not be done in chart.
How to do this in load script?i tried doing something with
SubStringCount(Name, ',')
and
if ((isNum(Mid(Name, (Index(Name, ',') - 1), 1))) =-1 and (isNum(Mid(Name, (Index(Name, ',') + 1), 1))) = -1 , 'okay', '-')
But i don't know how to do it. Do I have to use IterNo() or what? -
How can I use an existing field to filter a SQL query in QlikView?
Hi, I have a huge table with millions of rows/registers and dozens of columns/fields, one of them being NAME. Due to the size of this table, I want to... Show MoreHi, I have a huge table with millions of rows/registers and dozens of columns/fields, one of them being NAME. Due to the size of this table, I want to load only the rows/registers corresponding to a given set of names, I managed to create a table TabNames, with a column/field also named NAME, containing the desired names to be loaded, and wanted to do someting like this:
FullTab:
LOAD (...)
SELECT *
FROM MY TABLE
WHERE NAME in TabNames;or
FullTab:
LOAD (...)
SELECT *
FROM MY TABLE
WHERE EXISTS (NAME);or even
FullTab:
LOAD (...)
SELECT *
FROM MY TABLE
WHERE NAME IN (
LOAD DISTINCT NME_ADVPARTEATIVA
FROM TabNames);But nothing worked. How can I do this load?
-
Qlik Sense Windows health check for external load balancer
There are several articles in Community about how to setup load balancing for a Qlik Sense Enterprise on Windows cluster, (e.g. https://community.qlik... Show MoreThere are several articles in Community about how to setup load balancing for a Qlik Sense Enterprise on Windows cluster, (e.g. https://community.qlik.com/t5/Official-Support-Articles/Load-Balancing-in-Qlik-Sense-Enterprise-on-Windows/ta-p/1715174). They focus on the setup of the nodes in Qlik cluster itself, but not how the upstream hardware load balancer (e.g. Citrix Netscaler) can decide in a failover situation where to route a https/wss client to.
The normal setup in a simple two-nodes environment is like this, although there are more Windows Services involved on each node, but to understand we only look at Proxy and Engine.
The hardware loadbalancer has to make sure that users do not need to know the machine names (DNS host names) of the nodes themselves, but only something generic such as qlik.company.com ...
The hardware loadbalancer, despite of its name, does not load balance between the engines - and it shouldn't. Such rules are setup on the proxy itself, and any proxy can route to any engine (decide where to open a given app based on many possible configurations).
But if the central node goes down, the hardware load balancer needs to re-route the traffic to the remaining node. The only thing the users will see is a short session disconnect, if their session was to an app on the lost node.
We want to avoid again, that the client needs to know the hostname of the backup node, but continues to work on qlik.company.com
What does the load-balancer need to check to decide if the central node is alive or not? There can be enterprise solutions that check Windows Services, but it can be simply a REST call to this endpoint:
/engine/healthcheck
But wait a minute, if you try to reach this endpoint, which gives a nice report about qlik's engine health in JSON format, you'd need to be logged in first. And even then, how to make sure, that the healthcheck you want to reach, is not load-balanced to the backup node and returns a misleading health status?
By configuring new virtual proxies, one for each node. The essential part of the configuration is:
- name it like the machine itself
- give it a distinctive cookie name
- set it to "Always anonymous access"
- set it to loadbalance only to one node (the one in the name)
- under Proxies link it to only that same node
- white-list the hostname of the node so the http request gets accepted later
Central Node for example
Backup Node (in my example is called Scheduler) likewise
Now you can call two individual endpoints like this:
- https://centralqlik.company.com/load-central/engine/healthcheck
- https://backupqlik.company.com/load-scheduler/engine/healthcheck
Put the name of the virtual proxy between your hostname (... .com/) and /engine/healthcheck.
Each one will, without authentication, report the health state of the respective node with more information (e.g. saturated: true/false) that can be of use.
-
Necesito crear tabla de empleados y su informacion
Hola, estoy teniendo problemas al intentar obtener la información de los subordinados al seleccionar un manager en mi tabla. Al seleccionar un manager... Show MoreHola, estoy teniendo problemas al intentar obtener la información de los subordinados al seleccionar un manager en mi tabla.
Al seleccionar un manager, me están apareciendo también los datos del propio manager, cuando solo quiero ver los subordinados directos e indirectos.
Creo que hay algo mal con las relaciones o filtros entre las tablas que están haciendo que también se incluya al manager.
¿Alguien ha tenido un problema similar o sabe cómo solucionarlo?
Esto es como quiero que se vea
person number /birth date /direct manager/worker_name
1 15/08/2026 Miguel ñu
2 16/08/2026 Miguel carlos
3 17/08/2026 Miguel cesar
4 18/08/2026 Miguel lolo
5 19/08/2026 Manuel koke
6 20/08/2026 Manuel lele
7 21/08/2026 Manuel eres
8 22/08/2026 luz sergio
9 23/08/2026 luz fer
10 24/08/2026 luz oscarEsto es como se ve
person number/ birth date/ direct manager/worker_name
1 14/08/2026 Miguel ñu
1 14/08/2026 Miguel carlos
1 14/08/2026 Miguel cesar
1 14/08/2026 Miguel lolo
5 19/08/2026 Manuel koke
5 19/08/2026 Manuel lele
5 19/08/2026 Manuel eres
6 22/08/2026 luz sergio
6 22/08/2026 luz fer
6 22/08/2026 luz oscarEs decir cuando selecciono el manager, todos los workers debajo de el, pero la informacion me sale de los direct manager.
Saludos y muchas gracias
-
connecting to Athena from Qlik cloud ( underlying data is Parquet)
I am trying to connect to AWS Athena table using direct access gateway. My query is running quite slow opp :Select * FROM Table the underlying data ... Show MoreI am trying to connect to AWS Athena table using direct access gateway.
My query is running quite slow
opp :
Select * FROM Tablethe underlying data is stored in parquet .
What can I do to make it faster.
-
Is Oracle 12 supported on QR November 2024?
Hi, Can Oracle 12 be used reliably on QR Nov 2024, or other versions where the documentation doesn't explicitly state that it is supported? We have a ... Show MoreHi,
Can Oracle 12 be used reliably on QR Nov 2024, or other versions where the documentation doesn't explicitly state that it is supported? We have a client that has upgraded their lower environments to QR Nov 2024 and they are using Oracle 12 as the source with no issues.
Regards,
Mohammed