Skip to main content

Welcome to
Qlik Community!

cancel
Showing results for 
Search instead for 
Did you mean: 
  • 242,762 members
  • 2,489 online
  • 2,025,902 posts
  • 152,405 Solutions
Announcements
Get Ready. A New Qlik Learning Experience is Coming February 17! LEARN MORE

Welcome to Qlik Community

Recent Discussions

  • forum

    Application Automation

    Create and Update a file in the Space:DataFiles area for use in Qlik Sense Load ...

    I am going to connect to an API via an automation since there is a connector avialable but then I want to send the data I  retreive into a DataFile in... Show More

    I am going to connect to an API via an automation since there is a connector avialable but then I want to send the data I  retreive into a DataFile in a Space where Qlik Sense can pick it up and use it in a dashboard. The blocks around dataFiles are very confusing and none of them seem to have the content field where I can put the data itself.

     

    Any clarifications or advice on the Datafile blocks are welcome. I have done some scripting on Qlik-Cli to upload data files from a local machine but this is all cloud and the blocks don't seem to fit with the way the qlik-Cli worked.

     

    Thanks

    Show Less
  • forum

    Component Development

    OpenSearch Components/ Tips on Talend to Opensearch connections

    I am wondering if there is any plan for an equivalent of elastic search components for OpenSearch.Also, I am very new to talend, so if there are any t... Show More

    I am wondering if there is any plan for an equivalent of elastic search components for OpenSearch.

    Also, I am very new to talend, so if there are any tips for creating custom connections to a database, I am all ears!

    Show Less
  • forum

    App Development

    Double Clicking To Create Chart & Lazy Search Result Display from HUB

    1.  DOUBLE CLICK  I always promote Qlik Sense as one of the best-in-class data analytic tool that designed by software engineers that always put end u... Show More

    1.  DOUBLE CLICK 

    I always promote Qlik Sense as one of the best-in-class data analytic tool that designed by software engineers that always put end user in mind - ease of use.  

    There are not many tools allow end users or developers to create a chart within a minute by just 'double clicking)' (of course, provided, all master item dimension and measure have been set accordingly.).

    To create a chart, all users need to know is 3 things: Dimension, Measure, Chart Type.  Then, next thing to do is to stay focus on the property panel in Right.  the rest is just double clicking.

    Not anymore.    

    Now, whenever we double click a field or master item (where an active object is in chart), QS NO LONGER will add the selected item into the active chart, but to create another NEW object!  

    drag and drop is just not the same.  plus, now time could be spent in deleting object that we created by accident.

    The feature that referring in this post is, when in edit mode of a sheet,

    1.  Double clik any chart

    2.  At field or master item, double click one  Dimension/measure - that dimension/meausre will actually going to be added into the selected chart, NOT creating ANOTHER new filter or table or new object.  or if the chart already has dimension or measure, it will ask if we need to replace or color by etc.

    TTIDW_3-1738990762387.png

     

    2.  LAZY SEARCH RESULT DISPLAY

    This is about the search result display page from hub, when it displays the results, it just shows the minimum possible columns info with matched criteria. 

    TTIDW_0-1738989368186.png

    The current search result really show not much value but a liability to some or most who might constantly do the search then forgot abt need to go to catalogue if we have too many app with same name in many spaces.  Below is your search display from catalogue section.

    TTIDW_2-1738990071159.png

     The catalogue page is good, but still not good enough:

    1.  if possible, let us choose the column to display, if not, pls at least have:

    a. app size

    b.  user view

    c.  owner

    d.  enable column sorting by clicking on column

    Apply your search result design page across the entire app should be consistency.  

     

    Show Less
  • forum

    App Development

    Qlik desktop suddenly refuses to export sheet or other visualization objects

    Hi, I'm working on an app that will allow users to be able to export an entire sheet or an individual chart/table as printable pdf files. The feature ... Show More

    Hi,

    I'm working on an app that will allow users to be able to export an entire sheet or an individual chart/table as printable pdf files. The feature used to work properly before, but now it seems bugged. Each time I try to use this feature, it gives me such a message 'An error occurred during export. Please try again'. And of course, when I try again it produces the same message anyway. It has been this way since yesterday, and the issue persisted right now.

     

    Does anyone know what happens to my Qliksense? It seems to be affecting other apps as well, so I doubt it has to do with a change I made for the app I am working on. Moreover, I cannot seem to find the location of the log files for Qlik desktop, this does not help with the situation either, please let me know where the log files are located for this kind of export sheet errors if there are more details I can look up, thanks. 

    ol_dev_0-1738789352236.png

     

    Show Less
  • forum

    App Development

    Table 1 data into Table 2 as dimension

    Hello there, I have two tables, which have no relationship, but I need to add info from one table into the other as a dimension. These are my input ta... Show More

    Hello there,

    I have two tables, which have no relationship, but I need to add info from one table into the other as a dimension.

    These are my input tables:

    DEMONIO_AZUL_0-1738960868613.png

    and

    DEMONIO_AZUL_1-1738960913607.png

    And this is the desired output table:

    DEMONIO_AZUL_2-1738960972304.png

    The input tables come from different "owners" and have more records, I just need to know how to create the [Desired Output]: at the load script.

    If it were only one project, I would have added this:

    'NBU' as [Project Acronym]

    when loading [Systems Data]:

    But since this value [Acronym] can be variable and it comes from a file, I need to read it from [Project Data]: and "append" it to [Systems Data]: somehow. However, since there is no field that can provide a link between the two input tables, no JOIN works.

    Any ideas will be appreciated!

    Thank you!

     

    Show Less
  • forum

    Deployment & Management

    License access;Result=403;ResultText=Error: Access denied for Qlik Windows Servi...

    I keep seeing this error in the Qlik License Monitor Dashboard. There are apparently no issues with the Qlik environment, i.e. Tasks are run, Apps are... Show More

    I keep seeing this error in the Qlik License Monitor Dashboard.

    There are apparently no issues with the Qlik environment, i.e. Tasks are run, Apps are refreshed etc. but the logfile errors persist.

    The only pattern seems to be the error occurs around the same time within each hour which suggests a scheduled task may be at fault but I see/get no errors in the task list. (The Service Account has a Professional License allocated to it)

    AndyC_0-1738918914703.png

    Any ideas?

     

     

    Show Less
  • forum

    App Development

    Grand Total and custom sub total not changed by app filter

    Hi Qlik Community, We have a requirement where we need to design an app in such a way that Grand Total and custom sub total not changed by app filters... Show More

    Hi Qlik Community,

    We have a requirement where we need to design an app in such a way that Grand Total and custom sub total not changed by app filters. For example,  I have below hierarchy, 

    Region----->State----->Store

    By Default this is how app would look like 

    manish_gupta_1-1738888089515.png

    Now when someone select a state from State filter, it would change the data in table including subtotal and grand total, like below 

    manish_gupta_2-1738888259109.png

    But we have requirement that subtotal for level above the selected filter shouldn't change and show the data as below 

    manish_gupta_3-1738888337982.png

     

    I am looking for ideas to implement this solution. Also we have more then 20+ KPIs so any solution which is easy to implement, flexible and extendable would be great for maintenance purpose. 

     

    Thank you

     

     

     

     

     

     

     

     

    Show Less
  • forum

    App Development

    Problems with order and accumulated in tables

    Hello everyone. I would like to ask for your help with a very important topic: I want to create a cumulative total in a table. The problem I have is t... Show More

    Hello everyone.

    I would like to ask for your help with a very important topic: I want to create a cumulative total in a table. The problem I have is that when I perform the cumulative calculation, the RowNo() function distorts a column that should be sorted in descending order.

    Now I am going to show you a table that is working.

    DeanW_0-1738957736864.png

    You can see that I have a table of quantity sorted in descending order, your participation and the cumulative participation all in percentages.
    Quantity: Sum({<%Flag_Invoice={1}>} QUANTITY * If(IsNull(MENGE.STPO), 1, MENGE.STPO) * Sign)

    Cumulative %Participation:
    Sum({<%Flag_Flag_Invoice={1}>} QUANTITY * If(IsNull(MENGE.STPO), 1, MENGE.STPO) * Sign)
    /
    Sum(TOTAL{<%Flag_Invoice={1}>} QUANTITY * If(If(IsNull(MENGE.STPO), 1, MENGE.STPO) * Sign)

    %Accum:
    RangeSum(Above($(v%_Accumulated_Quantity),0,RowNo(TOTAL)))

    Being the variable $(v%_Accumulated_Cant) equal to %Accum Share I did it this way just to make it look neater.

    BUT!
    When I add an extra dimension, my quantity gets messed up and doesn't look right.

    DeanW_1-1738958066659.png

    NOTES:
    In the sort tab I set the first dimension to sort by expression and the rest I unsorted the sorts and it didn't work either.

    DeanW_2-1738958106926.png

    What can you do!

    Please!!!

     

    Regards

     

     

     

     

    Show Less
  • forum

    Connectivity & Data Prep

    How to list all ad accounts linked to a google ads account using a GAQL query (G...

    Hello, I would like to ask for your help.  I am trying to bring data from a GAQL query, in order to list all ad accounts linked to my Google ads accou... Show More

    Hello, I would like to ask for your help. 

    I am trying to bring data from a GAQL query, in order to list all ad accounts linked to my Google ads account. However, it is noted that to perform a GAQL query using the Google Ads API, it is necessary to inform an ad account id (example: customers/1234567890), which limits the search to a single account. In that case, how could this general listing be made?

    *(I note that in the api interface itself, such functionality is presented in the accounts part, but limiting the choice to only 1 account as well).

     

    The GAQL search query from that part would be this one correct, but how would this listing be done?

    SELECT   

      customer_client.client_customer, 

      customer_client.id, 

      customer_client.level, 

      customer_client.manager, 

      customer_client.status, 

      customer_client.time_zone, 

      customer_client.descriptive_name 

    FROM customer_client

     

    Thank you for your attention!

    Show Less
  • forum

    Integration, Extension & APIs

    How to obtain CSRF token from Qlik Cloud

    Hi all, I’m currently migrating a mashup from Qlik On-Premise to Qlik Cloud. My mashup uses Enigma.js and Nebula.js for visualizations, but I’m runnin... Show More

    Hi all,

    I’m currently migrating a mashup from Qlik On-Premise to Qlik Cloud.

    My mashup uses Enigma.js and Nebula.js for visualizations, but I’m running into issues while trying to obtain the CSRF token. I’ve tried two different approaches:

    1. Qlik Cloud with standard Identity Provider and frontend with Keycloak as Identity Provider

    Here’s the scenario:

    • The frontend authenticates users through Keycloak.
    • The frontend calls a Node.js API, passing the Qlik userId as parameter, and retrieves a web token via OAuth impersonation.
    • After obtaining the web token, the frontend calls a separate Node.js API to retrieve the CSRF token. However, this results in a 404 error ("token not found").

    2. Qlik Cloud with Keycloak as Identity Provider

    In this scenario:

    • The frontend authenticates users through Keycloak.
    • The frontend calls a Node.js API, passing the Keycloak session token to obtain the CSRF token. Unfortunately, I’m still getting the same 404 error.

    I suspect the issue might be that the /api/v1/csrf-token endpoint isn’t designed to issue a CSRF token when a web token is used as an authorization bearer token. The documentation includes an example with an API key, but that solution isn’t feasible in my case because multiple users need access to the mashup.

     

    Can anyone offer some guidance on this?

    Thanks for the support!

    Cristian

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

Customer Story

Efficiency in Agriculture: Nortera's Qlik Triumph

Nortera leads agricultural manufacturing analytics and automation with Qlik, reducing short-shipment rates and annual savings in water consumption.

Customer Story

Revolutionizing aircraft production through Data Analytics

Qlik Data Integration transforms Airbus' aircraft production, leading to over 150 replication tasks and informing more efficient analysis.

Location and Language Groups

Choose a Group

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

Collaborate

Healthcare User Group

Healthcare User Group

A private group is for healthcare organizations, partners, and Qlik healthcare staff to collaborate and share insights..

All are welcome

Japan Group

Japan

Qlik Communityの日本語のグループです。 Qlik製品に関する日本語資料のダウンロードや質問を日本語で投稿することができます。

Request to join

Brasil Group

Brazil

Welcome to the group for Brazil users. .All discussions will be in Portuguese.

open to all

Blogs

Community News

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