Skip to main content

Welcome to
Qlik Community!

cancel
Showing results for 
Search instead for 
Did you mean: 
  • 244,281 members
  • 4,354 online
  • 2,027,571 posts
  • 152,553 Solutions
Announcements
Qlik Insider: Product Roadmap Edition on Feb 26, 1 PM ET: REGISTER TODAY

Welcome to Qlik Community

Recent Discussions

  • No Boards Found
  • forum

    App Development

    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 More

    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 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.

     

    Show Less
    Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
  • forum

    Visualization and Usability

    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 More

    Hello, 

    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? 

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

    Show Less
    Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
  • forum

    App Development

    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 More

    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 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.

    Show Less
    Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
  • forum

    App Development

    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 More

    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 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….

    Show Less
    Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
  • forum

    App Development

    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 More

    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, 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 commas

     

    I 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?

    Show Less
    Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
  • forum

    Design and Development

    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 More

    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 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?

    Show Less
    Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
  • forum

    Security & Governance

    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 More

    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.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 ... 

    ChristofSchwarz_0-1740673091802.png

    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.

    ChristofSchwarz_1-1740673361378.png

    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

    ChristofSchwarz_0-1740674478205.png

    Backup Node (in my example is called Scheduler) likewise

    ChristofSchwarz_1-1740674786995.png

     

    Now you can call two individual endpoints like this:

    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. 

    ChristofSchwarz_2-1740675255042.png

     

    Show Less
    Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
  • forum

    Español

    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 More

    Hola, 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 oscar

    Esto 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 oscar

     

    Es decir cuando selecciono el manager, todos los workers debajo de el, pero la informacion me sale de los direct manager.

    Saludos y muchas gracias

     

    Show Less
    Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
  • forum

    Connectivity & Data Prep

    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 More

    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 is stored in parquet .

    What can I do to make it faster.

    Show Less
    Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
  • forum

    Qlik Replicate

    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 More

    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 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

    Show Less
    Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Weekly Leaderboard

Customer Story

Accelerating Decision-Making with Qlik Insights

Qlik enhances decision-making with high-speed insights, as Mayborn Group integrates data from various functions across their global operations, gaining a competitive edge in the childcare industry.

Location and Language Groups

Choose a Group

Join one of our Location and Language groups. Find one that suits you today!

Collaborate

Blogs

Community News

Hear from your Community team as they tell you about updates to the Qlik Community Platform and more!