Qlik Community

Ask a Question

Welcome to Qlik Community

cancel
Showing results for 
Search instead for 
Did you mean: 
3,641 online
Announcements
Support Cases coming to Qlik Community Oct. 4! Start chats, open cases, explore resources. Prep for the big move: READ DETAILS

Data Analytics

Forums for Qlik Data Analytics solutions. Ask questions, join discussions, find solutions, and access documentation and resources.

Data Integration

Forums for Qlik Data Integration solutions. Ask questions, join discussions, find solutions, and access documentation and resources

Qlik Academic Program

Qlik gives qualified university students, educators, and researchers free Qlik software and resources to prepare students for the data-driven workplace.

Qlik Gallery

Share your best Qlik apps and discuss impacts with peers! Show your work and get recognized for innovative uses of Qlik technologies.

Ideation

Participate in Qlik Technical Previews, submit ideas, and review documentation.

Events

Learn about upcoming Qlik related events, webinars and local meetups.

Groups

Join a Group that is right for you and get more out of your collaborations. Some groups are closed. Closed Groups require approval to view and participate.

About

Get started on Qlik Community, find How-To documents, and join general non-product related discussions.

Blogs

Hear directly from Qlik employees in our ten unique blogs.

Qlik Resources

Direct links to other resources within the Qlik ecosystem. We suggest you bookmark this page.

Support

Access Support programs, Knowledge Base, Updates blog, and Release Notes.

Community Sitemap

Here you will find a list of all the Qlik Community forums.

Recent Discussions

  • No Boards Found
  • forum

    New to Qlik Sense

    Set Analysis - Uniques

    I have a set analysis formula counting Sales from “Germany” as follows:(Count({<[Country]={‘Germany}>} Sales))I would like to however only consider th... Show More

    I have a set analysis formula counting Sales from “Germany” as follows:

    (Count({<[Country]={‘Germany}>} Sales))

    I would like to however only consider the uniques of a third column called “Submissions”. The current selection double counts Submissions.

    How might I go about removing all duplicates of a third column / submissions column?

    Show Less
  • forum

    New to Qlik Sense

    How to create a link table for 3 three tables

    I have 3 tables Customers, Accounts and Transactions.  What is the best way to create a link table between them as I'm not to sure how to go about thi... Show More

    I have 3 tables Customers, Accounts and Transactions.  What is the best way to create a link table between them as I'm not to sure how to go about this with the load script. Hopefully this makes sense. Sample in excel was created

    The specific links:

    -SourcePartyType = 'C' & SourcePartyID = CustID

    -DestPartyType = 'C' & DestPartyID = CustID

    • However if the SourcePartyType ='A' & SourcePartyID = AcctID --> PrimaryAcctID = CustID. Same link for DestPartyType.

     Sometimes a transaction can be made by a combination of the 2. Eg customer made a deposit to an acct 

    Any guidance would be great thanks

    Show Less
  • forum

    App Development

    Using calculated cell from above

    Hey All!I need your help with the data set (as an example I put it in excel): What I need is to fetch during of calculation for field "Purge" the file... Show More

    Hey All!

    I need your help with the data set (as an example I put it in excel):

    Przemyslaw_Rybacki_0-1632248611635.png

     

    What I need is to fetch during of calculation for field "Purge" the fileds above calculated (for example cell D10).

    Is there function in Qlik Sense which let me to do it? 

    I know that above() works only in table/chart, but is there an option to do it in my script?

    Gr

     

     

    Show Less
  • forum

    New to Qlik Sense

    Maximum Object to be placed inside Qlik Sense Container

    Hi Friends,What is the maximum number of charts to be placed inside the Qlik sense Container?Any Limits on container charts?
  • forum

    Integration, Extension & APIs

    Building a JavaScript array by paging through HyperCube pages in AngularJS exten...

    Hi All,Hoping for some help with building a big JavaScript object from a HyperCube that goes to more than 10000 cells.It's a straightforward AngularJS... Show More

    Hi All,

    Hoping for some help with building a big JavaScript object from a HyperCube that goes to more than 10000 cells.

    It's a straightforward AngularJS extension, and I've found the article for retrieving extra data here: https://help.qlik.com/en-US/sense-developer/May2021/Subsystems/Extensions/Content/Sense_Extensions/Howtos/get-additional-data.htm

    The issue I have is that I don't really want to call my paint function for every page of the HyperCube. What I actually want to do is build a chunky JavaScript array of all the data that I can then operate on to use in my template.

    Basically, at the end of the day, I'm trying to work out the best method to loop through all pages of the huge HyperCube in a single execution of paint so that I can modify the structure of the data to suit the needs of the extension.

    I've added comments to the code here to better explain what I'm trying to achieve.

    define([
      "qlik",
      "jquery",
      "text!./style.css",
      "text!./template.html",
    ], function (qlik$cssContenttemplate) {
      "use strict";
      $("<style>").html(cssContent).appendTo("head");
      return {
        template: template,
        initialProperties: {
          qHyperCubeDef: {
            qDimensions: [],
            qMeasures: [],
            qInitialDataFetch: [
              {
                qWidth: 20,
                qHeight: 500,
              },
            ],
          },
        },
        definition: {
          type: "items",
          component: "accordion",
          items: {
            dimensions: {
              uses: "dimensions",
              min: 6,
              max: 6,
            },
            measures: {
              uses: "measures",
              min: 0,
              max: 14,
            },
            sorting: {
              uses: "sorting",
            },
            settings: {
              uses: "settings",
            },
          },
        },
        support: {
          snapshot: true,
          export: true,
          exportData: true,
        },

        paint: function ($elementlayout) {
     
        //this block is from the above link
          var lastrow = 0me = this;
          var resultTable = [];
          this.backendApi.eachDataRow(function (rownumrow) {
            lastrow = rownum;
            resultTable.push(row); //can push each row into my table and that does work ok, but requires a repaint for every iteration and means that I can't operate on the output table because of the delay in promises returning
            
          });

          if (this.backendApi.getRowCount() > lastrow + 1) {
            var requestPage = [
              {
                qTop: lastrow + 1,
                qLeft: 0,
                qWidth: 20
                qHeight: Math.min(500this.backendApi.getRowCount() - lastrow),
              },
            ];
            this.backendApi.getData(requestPage).then(function (dataPages) {
              me.paint($element);
            });
          }

      
        console.log("resultTable"resultTable); //I want to wait for the completed dataset (so, wait for the promises to return) when the paint gets called. 
        
      },
        controller: ["$scope"function ($scope) {

        }],
      };
    });
     
     
    Any help would be appreciated!
     
    Show Less
  • forum

    App Development

    How to calculate formulas stored in a column?

    Imagine you have a data island table with two columns, e.g. "Metric" and "Function". The function column contains a syntactically correct formula per ... Show More

    Imagine you have a data island table with two columns, e.g. "Metric" and "Function". The function column contains a syntactically correct formula per metric which calculates its result over the remaining tables of the data model. Then create a table object in the UI and have Metric as dimension and the expression "$(=[Function])" as measure column. The output is an empty measure column unless I select one of the metrics in the dimension columns, then Qlik Sense Enterprise SaaS shows the correct result for the chosen metric. How do I need to formulate the expression so that it calculates the results for all rows right away? An empty sample QVF using the data model generated by hitting CTRL-0-0 in the load editor is attached

    Show Less
  • forum

    Integration, Extension & APIs

    Qliksense and predictive analytics integration

    How to do Qliksense and predictive analytics integration
  • forum

    QlikView App Dev

    Let's start a potentially controversial political discussion using Set Analysis

    Hello Qlik Community,Using set analysis to try and see whether Population or CO2 Per capita is the real trigger for our current excessive level of CO2... Show More

    Hello Qlik Community,

    Using set analysis to try and see whether Population or CO2 Per capita is the real trigger for our current excessive level of CO2 output via a "What If" using Set analysis, possible values P() and AGGR and Linest_M in the script.

    Attached video explaining the app and logic and also the QVW application.

    What are your thoughts?

    Kr,

    Cheenu

    Show Less
  • forum

    App Development

    Show current year data in filter pane qliksense

    Hello All,I have below field where the data is commencing from 2010 till now. My requirement is i have to show the data only for current year in this ... Show More

    Hello All,

    I have below field where the data is commencing from 2010 till now. 

    Aspiring_Developer_0-1632214788617.png

    My requirement is i have to show the data only for current year in this filter pane i.e it should show the dates starting from jan 2021 till the maximum. I don't know how to restrict this in filter pane.

     

    @Kushal_Chawda 

    Can anyone please help ?

    Thanks in advance

    Show Less
  • forum

    New to Qlik Sense

    Use of Calendar Table and Link Table in ETL

    Where should I make a calendar table in ETL?Following different examples I have observed people are creating it in Transformation Layer, but why , why... Show More

    Where should I make a calendar table in ETL?

    Following different examples I have observed people are creating it in Transformation Layer, but why , why not in Loading ?

    Use of Link Table: 

    Making LinkTable following two stages, first loading fields from Table 1 and concatenating with Table 2 and then making keys out of it and this Link Table is created in Loading , after some research I have come to know it saves RAM, if it is made in Transformation Extra Storage space would be consumed as it is loaded again in LinkTable.

    Someone with sufficient knowledge on these topics according to best practices, please throw some light.

    Show Less

Get Started On Community

Start Here Get Started On Community

Top Participants

Blogs

Product Innovation Blog

Learn about what's new across all of the products in our growing Qlik product portfolio.

Blogs

Qlik Community Manager Blog

Hear from the Qlik Community team about the latest platform enhancements and other topics.

Blogs

Support Updates Blog

Important and useful support information about end-of-product support, new service releases, and general support topics.

German Group

Deutsche User Group

German speaking - This group makes it easier to collaborate in your local language.

Request to join

Brazil Group

Brazil

This group for Brazil users. All discussions are in Portuguese.

open to all

Industry Group

Public Sector Group

This is a open Group for the Public Sector

All are welcome

Events

Espresso Webinars - From Data Integration to Analytics in Action

These webinars get straight to the point, they are strong, short, and with immediate effect – like an espresso.

Upcoming and On-Demand

Events

Talk to Experts Tuesday

You’ve got questions? We’ve got answers! Talk to Experts is a live Q&A Webinar series! Join and ask your questions about Qlik Sense Enterprise, Client Managed.

June 29, 2021 10AM EST

Events

Cloud Data and Analytics Tour

Ready to steer your business towards data-informed growth? Our Cloud Data & Analytics Tour is the perfect place to start your journey.

Choose your Region