Qlik Community

Welcome to Qlik Community

cancel
Showing results for 
Search instead for 
Did you mean: 
  • 158,445 members
  • 11,494 online
  • 1,709,410 posts
  • 128,360 Solutions
  • Announcements
    IMPORTANT security patches for GeoAnalytics Server available to download: 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

      App Development

      Find correlation between nominal data and a measure

      Hello friends, I want to find the correlation between certain criteria of our products and sales. For example our products have a certain size, color ... Show More

      Hello friends,

      I want to find the correlation between certain criteria of our products and sales. For example our products have a certain size, color and material. I want to know which of these attributes correlate strongly with sales and which don't. Is that possible to do within Qlik Sense?

      Thank you.

      Show Less
    • forum

      QlikView App Dev

      Book: Qlik Sense: Advanced Data Visualization for Your Organization

      New book published by Packt - Qlik Sense: Advanced Data Visualization for Your Organization in December 2017 authored by Dr. Christopher Ilacqua et al... Show More

      New book published by Packt - Qlik Sense: Advanced Data Visualization for Your Organization in December 2017 authored by Dr. Christopher Ilacqua et al.


      Qlik Sense is powerful and creative visual analytics software that allows users to discover data, explore it, and dig out meaningful insights in order to make a profit and make decisions for your business. This course begins by introducing you to the features and functions of the most modern edition of Qlik Sense so you get to grips with the application.


      Qlik Sense Advanced Data Visualization for Your Organization.png


      The course will teach you how to administer the data architecture in Qlik Sense, enabling you to customize your own Qlik Sense application for your business intelligence needs. It also contains numerous recipes to help you overcome challenging situations while creating fully featured desktop applications in Qlik Sense. It explains how to combine Rattle and Qlik Sense Desktop to apply predictive analytics to your data to develop real-world interactive data applications. The course includes premium content from three of our most popular books:


      • Learning Qlik Sense: The Official Guide Second Edition
      • Qlik Sense Cookbook
      • Predictive Analytics using Rattle and Qlik Sense


      What You Will Learn:

      • Build simple visualization models with Rattle and Qlik Sense Desktop
      • Get to grips with the life cycle and new visualization functions of a Qlik Sense application
      • Discover simple ways to examine data and get it ready for analysis
      • Visualize your data with Qlik Sense's engaging and informative graphs
      • Build efficient and responsive Associative Models
      • Optimize Qlik Sense for sales, human resources, and demographic data discovery
      • Explore various tips and tricks of navigation for the Qlik Sense® front end
      • Develop creative extensions for your Qlik Sense® dashboard


      Author Bio:


      Dr. Christopher Ilacqua


      Dr. Christopher Ilacqua is the research director of product validation at Qlik®. He has been working with leading customers and partners in the US for more than 3 years garnering feedback on Qlik Sense. Chris has over 25 years of experience in the field of planning and business intelligence, and he has established himself as a leading expert by advising, designing, and implementing hundreds of planning and business intelligence applications.


      His research interests focus on big data, data governance, mobile BI, SaaS, business collaboration, and cloud-based solutions.


      Show Less
    • forum

      New to Qlik Sense

      How to calculate % value between 2 time period with same weekday condition ?

      Hi All, i have a data - pre pandemic and post pandemic. I have pre calculated weekday averages for pre pandemic period. For eg Monday avg = 14, Tuesda... Show More

      Hi All,

      i have a data - pre pandemic and post pandemic. I have pre calculated weekday averages for pre pandemic period.

      For eg Monday avg = 14, Tuesday avg = 13.....Friday =10 etc

      Now, i want formula to pick up the value of latest date from data  then pull the pre pandemic value for same weekday by checking  condition if the weekday of the latest date is equal pre pandemic weekday avg

      Lets say today is friday and value is 3,  pre pandemic avg for friday is 10 as per pre calculated field. The final output should be 3 by 10 which is 30%

      Attaching the sample data for reference

      pal25_1-1656664715203.png

       

       

      Show Less
    • forum

      New to Qlik Sense

      How to get the weekday name for the latest date. ?

      Hi All,   I am new to Qlik. Can anyone help with the formula to get the weekday name for the latest date the data.  Also, i want to use this calculate... Show More

      Hi All,

       

      I am new to Qlik. Can anyone help with the formula to get the weekday name for the latest date the data. 

      Also, i want to use this calculated latest weekday to compare with another existing weekday field in order to fetch a value. How can i use this in that expression / set analysis.

      Any help would be appreciated 

      Show Less
    • forum

      Connectivity & Data Prep

      How can I use Qlik Sense for Advanced Analytics with Python

      Hey All,  I've been trying lately to connect Qlik sense to a Python SSE. I've tried the following link https://github.com/nabeel-oz/qlik-py-tools But ... Show More

      Hey All, 

      I've been trying lately to connect Qlik sense to a Python SSE. I've tried the following link

      https://github.com/nabeel-oz/qlik-py-tools

      But kept getting errors while installation.

      Has anyone lately tried another method to apply forecasting in qlik?

      Thanks

      Show Less
    • forum

      New to Qlik Sense

      Future of Qliksense/Qlikview?

      This is my first job and I have started working in Qlikview/Qliksense, but seeing the job market I don't think that the future in this technology is g... Show More

      This is my first job and I have started working in Qlikview/Qliksense, but seeing the job market I don't think that the future in this technology is good? What should I do, what all visualisation tools should I pick up?

      Show Less
    • forum

      New to Qlik Sense

      MasterCalendar

      Hi all   I want to load my script from datebas but my master calendar doesnt work ok. This appears: This is my mastercalendar script:   How can l so... Show More

      Hi all

       

      I want to load my script from datebas but my master calendar doesnt work ok. This appears:

      fdoflogtz1_0-1656706329339.png

      This is my mastercalendar script:

      fdoflogtz1_1-1656706361322.png

       

      How can l solve it? 

      Hope can help me, thanks

       

      Show Less
    • forum

      App Development

      Interesting Query: Order must deliver as per FIFO method

      Hi all, I have 2 data set, they don't have any PK. 1. Orders data:These are the orders being placed by customer. 2. ShopperStock:Stock detail of each... Show More

      Hi all,

      I have 2 data set, they don't have any PK.

      1. Orders data:
      These are the orders being placed by customer.

      Anku_0-1656826210269.jpeg

      2. ShopperStock:
      Stock detail of each outlet

      Anku_1-1656826252219.jpeg

       

      Desired Outcome:
      If multiple similar orders are in queue for a specific shop then it must deliver them according to the order placed, if not then it's an error/ red flag.
      I have attached .qvf & excel for better understanding.

      Please assist. Thank you.

       

      Show Less
    • forum

      New to Qlik Sense

      Use dimension field value in formula's set analysis in chart

      hi! I have the following task - count only those clients, who were active in current month AND made their first order in the same month.  In particula... Show More

      hi!

      I have the following task - count only those clients, who were active in current month AND made their first order in the same month.  In particular, i need to build a formula where current month is compared with the 1st purchase month. 

      This is simplified example, as i have a lot of clients and periods in my original datamodel.

      I know set analysis is calculated once per chart disregarding dimension value per row, but maybe there is a workaround?

      Thank you!

      count( {< Client = p(<Month = 1stPurchase >) >} Client ) 

       

      ziabobaz_1-1656763937160.png

       

       

       

      Show Less
    • forum

      QlikView Administration

      Help in a script

      Hello everyone, Im a begineer in qlikview. I have 2 tables, in the table 1 I have Policy ID and two different endorsement IDs, in the other table I ha... Show More

      Hello everyone, Im a begineer in qlikview. I have 2 tables, in the table 1 I have Policy ID and two different endorsement IDs, in the other table I have Policy ID and just one endorsement ID. How can I search for the policies that are in the table 1 but aren’t in the table 2. Using the combinations of Policy and enforsement.

      Thanks!!

      Show Less

    Get Started On Community

    Start Here Get Started On Community

    Top Participants

    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

    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