Qlik Community

Welcome to Qlik Community

cancel
Showing results for 
Search instead for 
Did you mean: 
  • 162,977 members
  • 10,002 online
  • 1,715,917 posts
  • 129,236 Solutions
  • Announcements
    Coming Aug. 9: New Simplified Authoring for Qlik Sense SaaS – For Details, CLICK HERE

    Welcome to Qlik Community

    FOR NEW MEMBERS

    Everything you need to make your Qlik Community experience valuable.

    SEARCH KNOWLEDGE BASE

    Explore official Support and member created content.

    ASK PRODUCT QUESTIONS

    Submit questions to product experts and participate in conversations.

    Analytics

    Forums for Qlik Analytic 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 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.

    Support

    Chat with us, search Knowledge, open a Case, read the latest Updates Blog, find Release Notes, and learn about our Programs.

    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.

    Qlik Academic Program

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

    Community Sitemap

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

    Recent Discussions

    • No Boards Found
    • forum

      Reporting Service

      Sum If Expression

      Hey Qlik-Member, I'm currently stuck with data visualization. Following I'll describe my problem: =If([PC_Mapping*]='00000001850999011200' or [PC_Mapp... Show More

      Hey Qlik-Member,

      I'm currently stuck with data visualization. Following I'll describe my problem:

      =If([PC_Mapping*]='00000001850999011200' or [PC_Mapping*]='00000001850999011201',(Sum({<Cost_Center = {'1940146024','1940146026','1940146084'}>} Cost_Center_Amount), [Sum(Cost_Center_Amount)]))

       

      If the Profit Center = 00000001850999011200, 00000001850999011201 then I need the Summation of Cost_Center_Amount by the Cost Centers = 1940146024, 1940146026,1940146084 and for all other Profit Center I need the Summation of Cost_Center_Amount by all Cost Centers.

       

      I hope you understand my problem and can help me.

       

      Thanks in advance.

       

      Best regard

      Josh

       

      Show Less
    • forum

      New to Qlik Sense

      combine three tables

      How to combine as one table I have three tables table1: product apple;apple1;apple@ ball;ball@;ball@2 pen table2: Product1 apple ca... Show More

      How to combine as one table

      I have three tables

      table1:

      product
      apple;apple1;apple@
      ball;ball@;ball@2
      pen

      table2:

      Product1
      apple
      cap
      pencil

       

      table3:

      product2
      apple
      chaco
      pencil

       

      I want output like below

      All
      apple;apple1;apple@
      ball;ball@;ball@2
      cap
      chaco
      pen
      pencil
      Show Less
    • forum

      Qlik NPrinting Discussions

      REST API OnDemandRequest : Retrieve charts from NPrinting report with multiple c...

      I am using a REST API to retrieve info from a report provided by NPrinting. Through this request I am also passing some filter info to extract info fr... Show More

      I am using a REST API to retrieve info from a report provided by NPrinting. Through this request I am also passing some filter info to extract info from only one customer.

      This works great if the Nprinting report aquires its info only one source / connectionId.

      However, the NPrinting report contains info from different sources provided by different connectorId's  .

      Retrieving both these charts from this report by REST , will apply my filter to the first connector, but will NOT apply this to the second chart info ; all customer info will be extracted unfiltered. 

      {

          "type""report",

          "config": {

              "reportId""123-465",

              "outputFormat""pdf"

          },

          "filters": {

              "initialBookmark""",

              "additionalFilters ": []

          },

          "connectionId": "654-321",

          "selections": [

              {

                  "fieldName": "RELATIE_ID",

                  "selectedCount": 1,

                  "selectedValues": [

                      "1234"

                  ],

                  "isNumeric": false

              }

          ]

      }

       

      Can I retrieve info from a current Nprinting report that has more than one different connectionId 's ? Adding twice "connectionId": "654-321" is a failure,

      The field to be filtered (RELATIE_ID) is the same for both charts.

      The only info that I can find is Qlik NPrinting API − OnDemandRequest - Qlik | Help and here the connection is only a string and not an array .

      Show Less
    • forum

      Qlik NPrinting Discussions

      Custom Grand total issue in Pivot tables with Dynamic Data

      Hi All, I have a pivot table in QlikSense with 2 dimension(Country and City) and one measure with expression (A/B).I have converted Pivot table to str... Show More

      Hi All, 
      I have a pivot table in QlikSense with 2 dimension(Country and City) and one measure with expression (A/B).
      I have converted Pivot table to straight table and using Excel Pivot option for designing the structure w.r.tPivot table in QS, I Need to show Grand total in Pivot table in NPrinting , but its not matching with QS total which we enabled total feature from presentation tab. As per my analysis ,NP total simply doing the summation of final output (A/B) of measure values across each dimention values instead of calculating sum (A) and SUm (B) at overall level and doing the division . 

      To handle this , i have created variable with expression in QS for showing grand total by not using excels grand total , but since data is dynamic, i am unable to find the position for placing this and also we are dealing with 2 dimensions in pivot.

      ISU A B Exp in QS: A/B  
      QS Total 440 190 2.315789474 (Expected output)
      A 100 20 5  
      B 140 70 2  
      C 200 100 2  
          Grand Total in NP 9 (i.e 5+2+2)

      Please help

      @Lech_Miszkiewicz  @Ruggero_Piccoli 

      Show Less
    • forum

      New to Qlik Sense

      Group dates into 2 week blocks

      Hi,  I am wondering how I can take a plain date field and set it up in a table or filter so that the dates are filtered into Pay Periods (2-week group... Show More

      Hi, 

      I am wondering how I can take a plain date field and set it up in a table or filter so that the dates are filtered into Pay Periods (2-week groupings)? Appreciate any help!

      Show Less
    • forum

      New to Qlik Sense

      COUNT Of Products for Three date Tables. E.g., Create Date, Fix Date and Close D...

      I want to show the count of Machine ID on these Dates seperately and show them on a line graph.  
    • forum

      Qlik Education Discussions

      Problem with totals

      Hello, I am an amateur, and I am approaching qlikview, I  am having a problem with the totals. The data is calculated with a simple sum(). As you can... Show More

      Hello,

      I am an amateur, and I am approaching qlikview, I  am having a problem with the totals.

      Hitman1981_0-1660060097749.png

      The data is calculated with a simple sum().

      As you can see in the image there is a sum problem, the strange thing is that the total is right, while the lines are wrong, because there are products that are added both in the first line and in the second row. 

      what I ask, if it is possible to repartition the total in the rows in percentage and never exceeding the "CARICATO" column.

      I apologize in advance for my basic level English. 

       

      Show Less
    • forum

      QlikView Integrations

      QlikView license

      Hi everyone who's reading this! I have simple question but cannot find anything online about this. We have two QlikView environments, one test environ... Show More

      Hi everyone who's reading this!

      I have simple question but cannot find anything online about this.

      We have two QlikView environments, one test environment and one production environment.

      In the test environment we are able to change Max number of simultaneous QlikView engines for distribution. 

      In the live environment we are unable to change the Max number of simultaneous QlikView engines for distrubiton.

      On the test and production environment we have different licenses, the test environment has NUMBER_OF_CLUSER_NODES.;2;; and the production environment has NUMBER_OF_CLUSER_NODES;1;;. 

      Mika_2000_0-1659949603736.png

      The test environment.

      Mika_2000_2-1659949651029.png

      The production environment.

       

      If this is an license issue is there a workaround to upscale the Max Simultaneous Engines?

      Thanks in advance! 

      Show Less
    • forum

      New to Qlik Sense

      Nested if + wildmatch

      Hi,   I have struggle with this calculated field I need to make. In first case i need to mark all rows that contains "TBC" in field Customer PO as "DU... Show More

      Hi,

       

      I have struggle with this calculated field I need to make.

      In first case i need to mark all rows that contains "TBC" in field Customer PO as "DUMMY-COMMITED"

      In secon case i need to mar all rows that contains "DUMMY" as "DUMMY"

      Rest should be marked as "COMMITED"

      Is there any expression that should solve this?

      l(If(WildMatch([Customer PO],'TBC'),'DUMMY-COMMITED',(IF(WildMatch([Customer Code],'DUMMY'),'DUMMY','COMMITED'))))

      Show Less
    • forum

      Brasil

      Busca Lat e Long - Api Geocode Qlik Sense

      Boa tarde Estou buscando por endereços a Lat e Long  na api  da google ( Geocode ), alguns me trazem o resultado esperado outras não retornam os dados... Show More

      Boa tarde

      Estou buscando por endereços a Lat e Long  na api  da google ( Geocode ), alguns me trazem o resultado esperado outras não retornam os dados. 

      Vou mandar alguns print do script e o resultado.

      Se alguém conseguir me orientar como solucionar, Agradeço!

      Show Less

    Blogs

    Community News

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

    Blogs

    Qlik Academic Program Blog

    Read the latest blog around the Qlik Academic Program.

    Blogs

    Qlik Product Innovation Blog

    If you want to know what's new across all of the products in our growing Qlik product portfolio.

    Blogs

    Support Updates Blog

    Get the latest Support information about end-of-product support, new service releases, and general support topics.

    Blogs

    Qlik Design Blog

    Read all about Qlik solutions: scripting, data modeling, visual design, extensions, best practices and more.

    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

    Events and Webinars

    QlikWorld Tour

    Discover your data swagger at a city near you.

    Find your city

    Events and Webinars

    Qlik and Qlik Community Hosted Events

    Subscribe to our Events and Webinar page so you do not miss an event opportunity!

    choose and register

    Event

    Welcome to Qlik

    Join the "Welcome to Qlik" webinar and learn about the Qlik Ecosystem, such as Qlik Community, Learning, and Help.

    On-Demand

    Events

    Upcoming Events and Webinars

    There is more than one way to find upcoming events, look on the right side of any Qlik Community forum!

    Upcoming