Qlik Community

Welcome to Qlik Community

cancel
Showing results for 
Search instead for 
Did you mean: 
  • 162,832 members
  • 9,215 online
  • 1,715,699 posts
  • 129,213 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

      App Development

      Create 1=1 relation with calendar to show non-utilization?

      I'm creating a vehicle utilization dashboard, but most importantly, need to show non-utilization. The data source only contains the dates that someone... Show More

      I'm creating a vehicle utilization dashboard, but most importantly, need to show non-utilization. The data source only contains the dates that someone signed in as using a vehicle, so currently the only "non-utilization" I can show is if someone signed in, but then didn't input mileage (as it'd be 0). I have a calendar table on another database (diff server) and thought I could create a 1=1 relationship so every vehicle would have 365 entries....and then all the "null values" would be my new "non-utilization" count. I've accomplished this before in SQL if they're on the same server, but I honestly have no idea how to do this in QLIK. 

      I loaded the vehicle usage data and then loaded the calendar separately. I named both date columns the same knowing QLIK will make a connection, but it doesn't actually give me the desired result. I am new to QLIK, so not super savvy with QLIK Script or how to accomplish this. Any help is appreciated! 

      Show Less
    • forum

      Qlik Replicate

      Replicate with 1:M

      Hi Gurus, I am trying to go from 1 table in source to Many tables on the target database. source is SQL and target is Oracle. What is the are some of ... Show More

      Hi Gurus,

      I am trying to go from 1 table in source to Many tables on the target database. source is SQL and target is Oracle. What is the are some of the patterns to achieve this? The table schemas are different b/w source and target.

      Thanks!

      -

      Show Less
    • forum

      New to Qlik Sense

      Count if the value repeats in a 24 hours interval

      Hello everybody!I have a question that probably has a very simple solution... as usual... I need to count how many times a value repeats within 24 hou... Show More

      Hello everybody!
      I have a question that probably has a very simple solution... as usual...

      I need to count how many times a value repeats within 24 hours.

      Normally, in Excel, a simple formula is enough.

      COUNTIF(Table[PHONE],[@PHONE],Table[DATE],"<"&[@DATE]+1)

      I tried everything in Load or SetAnalysis but without success.

      I can't do it in base because it's a REST API.

      Any idea?

      Show Less
    • forum

      Qlik Compose for Data Warehouses

      How to change schema name to which datamart is pointing to

      How to change schema name to which datamart is pointing to
    • 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
    • forum

      Qlik Replicate

      Configure Replicate task with Google Analytics as end point

      Hello, We are currently using Qlik replicate for SQL Server and AWS end points.  We have a BI team that needs Google Analytics data.  My question is w... Show More

      Hello,

      We are currently using Qlik replicate for SQL Server and AWS end points.  We have a BI team that needs Google Analytics data.

       My question is what is the best way to set up a Qlik Replicate task with and end point to connect and bring down Google Analytics data?

      Do we need to set up BigQuery with a custom query and then connect to that?

      I supposed we need to flatten the data first and then bring it into SQL Server?

       

      Just looking for ideas from anyone that has already done this type of project.  Thanks.

       

      Show Less
    • forum

      New to Qlik Sense

      migrate qlik sense application from windows server 2012 R2 STD to new server 201...

      hi Team    1 we are plan to migrate qlik sense application from windows server 2012 R2 STD to new server 2019 R2 STD  ,  is there any specific tool we... Show More

      hi Team 

       

      1 we are plan to migrate qlik sense application from windows server 2012 R2 STD to new server 2019 R2 STD  , 

      is there any specific tool we need to use for migration to keep our existing configuration on new server ? 

      product details : 

      qlik sense - 14.20.5 (old server)

      qlik nprinting - 21.14.4.0 (old server)

      2 what if we directly upgrade from 2012 R2 to  2019 R2 is there any configuration changes required after upgrade ?

      and is there any specific  file we need to backup ?

      Show Less
    • forum

      App Development

      Não aparece os dados quando colocamos a aplicação em publicação

      Boa Tarde! a aplicação no espaço pessoal funcional, mas quando publicamos em um espaço gerenciado, não aparece informações. 1. Espaço Pessoal. 2. Pub... Show More

      Boa Tarde!

      a aplicação no espaço pessoal funcional, mas quando publicamos em um espaço gerenciado, não aparece informações.

      1. Espaço Pessoal.

      eliasneif_0-1659987019339.png

      2. Publicado.

      eliasneif_1-1659987095842.png

       

      Desde já agradeço, 

      Show Less
    • forum

      Security & Governance

      Create CSR from the Qlik Sense

      Hello, I have installed Qlik Sense Enterprise on-premise in the customer environment. The customer wants me to generate CSR from Qlik sense but I don'... Show More

      Hello,

      I have installed Qlik Sense Enterprise on-premise in the customer environment. The customer wants me to generate CSR from Qlik sense but I don't know the steps on how to create the CSR from Qlik Sense. I tried looking at the community but unfortunately, the information is archived.


      I will appreciate it if anyone can share the steps to generate CSR from Qlik Sense.

       

      Thanks and Regards
      Vaibhav 

      Show Less
    • forum

      Deployment & Management

      High Availability (HA) for NPrinting and Geoanalytics

      Hi We need to achieve high availability in our deployment. For this we have installed QS on two servers and made them central node and failover node. ... Show More

      Hi

      We need to achieve high availability in our deployment. For this we have installed QS on two servers and made them central node and failover node. Along with this we had installed Postgres SQL on a different server there also we have installed Postgres SQL on two servers.

      Now we are also having NPrinting & GeoAnalytics in our deployment. We want to achieve HA in these two also. So I have installed both tools on two servers, but I am unable to get how to do data replication in both case of NPrinting and Geo Analytics. We have to setup such environment that in case one server of Nprinting fails so it will get transferred to another server and reports can be downloaded and same case with Geo Analytics, if one server of Geo analytics fails Map can populate from another server.

      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