Qlik Community

Welcome to Qlik Community

cancel
Showing results for 
Search instead for 
Did you mean: 
  • 163,458 members
  • 11,283 online
  • 1,716,818 posts
  • 129,345 Solutions
  • Announcements
    Now Live: Qlik Sense SaaS Simplified Authoring – Analytics Creation for Everyone: READ DETAILS

    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

      New to Qlik Sense

      if a certain field is null (-) insert "No value"

      Hi all,  In a straight table, for a specific column - Company  I have to insert "No value" if the value is null. I have tried 2 things, both didnt wor... Show More

      Hi all, 

      In a straight table, for a specific column - Company 

      I have to insert "No value" if the value is null.

      I have tried 2 things, both didnt work:

      1)  IF(IsNull([Company Name]),'No value',[Company Name] )

      2)  if(len([Company Name])<1,'No value',[Company Name]) 

      Feels like it worked for me in the past, no ideas whats wrong.

      In both cases the expression was valid but the column still shows "-"

      aheavy95_0-1660460649691.png

       



      Thanks

      Show Less
    • forum

      New to Qlik Sense

      What are the data requirements to build a map in Qlik sense?

      Hi,  I am new to Qlik sense and I am trying to show some data on map chart. What kind of data I need to have in order to to show some hospitals and nu... Show More

      Hi, 

      I am new to Qlik sense and I am trying to show some data on map chart. What kind of data I need to have in order to to show some hospitals and number of patients in these hosptials? Thanks in advance.  

      Show Less
    • forum

      App Development

      Recommended max number of measures and dimensions and widgets

      Hello, We have an application developed that contain a big data model with around 5 millions records in the different tables combined. The application... Show More

      Hello,

      We have an application developed that contain a big data model with around 5 millions records in the different tables combined.

      The application contains some complex measure and aggregations requested by requirements design.

      The sheets load fine when we have two widgets containing like a dozen of dimensions and a dozen of measures.

      However some end users insists on displaying all KPIs/Measures and all data in one single sheet. For example in one sheets we have:

      • 9 widgets:
        • 4 KPIs
        • 5 tables 
      • 21 dimensions
      • 51 measures, many contains complex aggregations

      The sheets becomes barely usable especially when no filter applied

      What is the standard recommendation for qliksense for a single sheet? how many widgets/dimensions/measure should we have a single sheet to not abuse the flexibility of self service?

      Thanks

      Elie

       

      Show Less
    • forum

      New to Qlik Sense

      Looking for a Qlik Sense Tutor

      Hi everyone! I'm building dashboards for HR Statistics in Qlik Sense. I've made some basic courses in qlik platform and took one Udemy course; howev... Show More

      Hi everyone! I'm building dashboards for HR Statistics in Qlik Sense. I've made some basic courses in qlik platform and took one Udemy course; however, there are some concepts are not clear enough and also I cannot find relevant information about how to do/build some formulas or calculations because mostly I just find sales examples which in my case are not very helpful.

      Right now I'm struggling with 2 main issues:

      1. I need to count how many employees where active in each month, each employee can have several hiring dates and attrition dates but I also have a fixed number of employees that need to be added to previous count.

      2. Holidays Dashboards: I need to build in the same app the availables holidays for each employee according to their country and it's legislation ( USA, Panama, Netherlands and Spain).

      I'm looking for someone who can guide me a bit better in master calendar, Set analysis and scripting in order to finish the dashboards I'm working at. If someone is interested in gaining some extra cash and help a lost soul in Qlik's world I'll be more than happy if you PM me.

      Thanks in advance and cheers.

      Show Less
    • forum

      Integration, Extension & APIs

      Data Loader Via JS

      hey , i am trying to load Data To all my app in qlikSense Desktop, i wrote the script  that loops through all the apps using GetDocList function, and ... Show More

      hey ,

      i am trying to load Data To all my app in qlikSense Desktop,

      i wrote the script  that loops through all the apps using GetDocList function, and i pass the app name a function That Load The Data via QlikSense JS API (every iteration) but i need to "Wait" for every doc\Doc to be loaded\Updated before the next iteration. can you help me???

      another thing i noticed is that if i have an  loadData Error it continues without displaying the error, hoe can i deal with "Load Data" Errors?

      Show Less
    • forum
    • forum

      New to Qlik Sense

      Calendar Dates

      My data has dates very very wrong extending to 8201 Year and now I can either remove all the data where Year is more +- current year, but I am thinkin... Show More

      My data has dates very very wrong extending to 8201 Year and now I can either remove all the data where Year is more +- current year, but I am thinking of making all the dates which are above a certain date like today+5year to be maximum of 31-12-2099 something like that in floor value, due to date being so out of range Date Picker isn't working and fields tags take it as numeric instead of date I have used floor everywhere for my date values.

      P.S. I have already tried advance settings they don't work either, while selecting dates in date picker it says no data available and dates are grey not black like normal.

      Show Less
    • forum

      App Development

      No unique identifiers in table

      Hey guys,  So I have a table that lists multiple product orders for multiple stores. The fields in the table include all kinds of information regardin... Show More

      Hey guys, 

      So I have a table that lists multiple product orders for multiple stores. The fields in the table include all kinds of information regarding the seller type, buyer type, product type, etc... However there is absolutely no unique IDs in this table. 

      This is an issue since I am trying to make a unique identifier for each overall store transaction (not for each individual product bought). I don't want to touch the data load editor.

      Is there a way for me to create a master item dimension that serves as a unique key for each transaction. I want to create a master item that combines multiple dimensions in order to create a unique identifier. How do I write this expression?

      Show Less
    • forum

      App Development

      Fuzzy matching of data

      Hello,   I have this 2 incomplete datasets and I  would like to assign ids to the first dataset from the second one using hte email field. Does Qlik p... Show More

      Hello,

       

      I have this 2 incomplete datasets and I  would like to assign ids to the first dataset from the second one using hte email field.

      Does Qlik provide any ability to perform fuzzy matching? I have millins of records to update and hope to use a Qlik to update some of the records.

      name  address
      ck,mar chicago
      asos asos paris
      p c paris

       

      id Email
      2345 manager@charleskmar.com
      6753 asosciate@chicagoassociate.com
      2831 pascal.c@pascalcarlos.com

       

      My Expectation:

      name  address id Email
      ck,mar chicago 2345 manager@charleskmar.com
      asos asos paris 6753 asosciate@chicagoassociate.com
      p c paris 2831 pascal.c@pascalcarlos.com

       

      Any ideas is welcomed.

      Show Less
    • forum

      New to Qlik Sense

      show number of rows in report

      Hi all I need to add to my report the number of rows that exist in it at any given time.  I was asked to place this counter on top of the report as a ... Show More

      Hi all

      I need to add to my report the number of rows that exist in it at any given time. 

      I was asked to place this counter on top of the report as a kpi (near the date time)

      any Ideas? 

      thanks

       

      aheavy95_1-1660203717100.png

       

      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