Qlik Community

Blogs

Hear directly from Qlik employees in our eight unique blogs. Check out the new Architecture Deep Dive Blog!

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

Updates for Qlik Community offerings, announcements and changes.

All about product and Qlik solutions: scripting, data modeling, visual design, extensions, best practices, etc.

This forum was created for professors and students using Qlik within academia.

On this forum you can access and follow the latest updates of our courses and programs with the Qlik Education team.

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

Information on all new product releases, connectors, beta programs, and technical product information.

Deep dives into specific back-end technologies which allow for the extension of Qlik to fit the needs of the enterprise.

Recent Blog Posts

  • Image Not found
    Qlik Design Blog

    New Series - Qlik Sense and Salesforce Working Together

    Hi guys -   I'm pleased to present to you a new video series that shows you how Qlik Sense and Salesforce work together.     With so many companies running multiple business systems, Qlik offers an alternative to data consolidation confusion by relating information within Salesforce and other enterprise systems for seamless visual analysis, dashboards and reports. Qlik can easily be accessed within Salesforce as a custom tab o... Show More

    Hi guys -

     

    I'm pleased to present to you a new video series that shows you how Qlik Sense and Salesforce work together.  

     

    With so many companies running multiple business systems, Qlik offers an alternative to data consolidation confusion by relating information within Salesforce and other enterprise systems for seamless visual analysis, dashboards and reports. Qlik can easily be accessed within Salesforce as a custom tab or as embedded Qlik graphs, tables, and charts within other Salesforce tabs. Alternatively, Salesforce data can be immediately integrated into a Qlik application via a native data connector to provide an unparalleled view into your business’ entire data. 

     

    Please take a few minutes to watch and learn. Enjoy!

     

    Regards,

    Mike Tarallo
    Qlik


    Follow me https://twitter.com/mtarallo - for instant Qlik updates and insights!

     

    Part 1:  Introduction

     

    Part 2:  Embedded Analytics Use Case Demo


    Part 3:  Qlik Sense Client & Other Features 

    Resources:

    Show Less
  • Image Not found
  • Image Not found
    Qlik Product Innovation Blog

    Announcing Qlik Sense® Business!

        As part of our ongoing SaaS product roadmap, we are excited to announce the launch of Qlik Sense Business, our newest SaaS offering designed to help groups and teams collaborate on analytics and make faster data-driven decisions. Is this the same as Qlik Sense Cloud Business? No, and it’s not just a name change, either. Qlik Sense Business is a new, enhanced offering with more capabilities that groups and teams can use to build an... Show More

     

     

    As part of our ongoing SaaS product roadmap, we are excited to announce the launch of Qlik Sense Business, our newest SaaS offering designed to help groups and teams collaborate on analytics and make faster data-driven decisions.


    Is this the same as Qlik Sense Cloud Business?

    No, and it’s not just a name change, either. Qlik Sense Business is a new, enhanced offering with more capabilities that groups and teams can use to build and share apps for greater discoveries.
    Qlik Sense Business runs on Qlik Cloud Services, our cloud-native, Kubernetes-based SaaS platform that also hosts Qlik Sense Enterprise.  Qlik Sense Business users will now benefit from the same speed, performance, and availability as our enterprise SaaS users. Additionally, Qlik Sense Business also shares the same enhanced and redesigned user interface, cloud hub, and management console as Qlik Sense Enterprise on Qlik Cloud Services.

    Qlik Sense Business users benefit from:

    •  Full Qlik Sense analytics capabilities, including the Associative Engine
    •  All of Qlik’s latest augmented intelligence capabilities, including insight suggestions
    •  Drag-and-drop app creation and fully interactive apps
    •  A personal space to create your own content and share with anyone you wish
    •  Five shared spaces where your team members can do-develop and share apps
    •  Direct data connectivity to over 40 data sources
    •  Automated data refreshes


    The global roll out of Qlik Sense Business is underway. Be one of the first by to start your 30-day trial now. You will be able to create your tenant in minutes, and begin creating and sharing apps immediately – all without any downloads or installations. 

    If you’re ever ready for more enterprise features – additional governance, API integrations and more data capacity – you can easily upgrade to Qlik Sense Enterprise on Qlik Cloud Services at any time.

    Currently a Qlik Sense Cloud Business user?

    Stay tuned for upcoming details next months. We’ll tell you how you can migrate from Qlik Sense Cloud Business and subscribe to Qlik Sense Business. You’ll also be eligible for a limited-time offer savings when you migrate your existing cloud subscription.

    Show Less
  • qlik-community-blogs.jpg
    Qlik Design Blog

    Introducing the Qlik Scalability Tool

    Hello Qlik Community, in this post our guest blogger and Principal Enterprise Architect, Marcus Spitzmiller, joins us again to introduce the Qlik Scalability Tool and the brief video series he created that addresses it. Marcus is a member of the Qlik Enterprise Architecture team focusing on enterprise deployments and best practices.  His areas of expertise include scalability and performance, deployment best practices, integration, and secur... Show More

    marcus.png
    Hello Qlik Community, in this post our guest blogger and Principal Enterprise Architect, Marcus Spitzmiller, joins us again to introduce the Qlik Scalability Tool and the brief video series he created that addresses it. Marcus is a member of the Qlik Enterprise Architecture team focusing on enterprise deployments and best practices.  His areas of expertise include scalability and performance, deployment best practices, integration, and security.

    Qlik Scalability Tool


    The Qlik Scalability Tool (https://community.qlik.com/docs/DOC-8878) is a tool for easy creation, execution and analysis of load and performance tests.  Our friends in Qlik's Scalability Labs in Lund, Sweden created this tool, and the reason I like it is because it already “knows” about how Qlik Sense works. It is aware of the concepts like the Hub, sheets, list boxes, and of course, charts, so creating test scripts that simulate users interacting Qlik Sense is easy.  In fact, it is the same tool we used to benchmark servers in these documents:

    How it Works


    The Scalability Tool works by simulating virtual users making selections in a Qlik Sense application.  The Scalability Tool itself captures results into log files, as does Qlik Sense along with performance counter information, and that information is loaded into a Qlik application (https://community.qlik.com/docs/DOC-15451) used to review and analyze.  In the Qlik application, you can see things like CPU and RAM utilization, response times, and much more.

    Video Series

    I created a three part video series (https://community.qlik.com/docs/DOC-16750) to help you get started so you can learn more and see it in action.

    Please remember that this is more of a jump start and it isn’t intended to be comprehensive. The documentation that comes along with the Scalability Tool does that.

    Enjoy.

    Marcus Spitzmiller

    Master Principal Enterprise Architect, Qlik

    Show Less
  • Image Not found
    Qlik Design Blog

    It's Time to Transition your Qlik Sense® Cloud Business Account

    It’s time! In August we announced Qlik Sense Cloud Business will transition to Qlik Sense Business. Now, Qlik Sense Cloud users can begin to migrate content and users to Qlik Sense Business with a Qlik Sense Business Subscription. The video above and attached PDF can guide you through that process.   Qlik Sense Business, Qlik’s newest SaaS offering, brings the power of Qlik’s third-generation analytics platform to groups, teams, and busin... Show More


    It’s time! In August we announced Qlik Sense Cloud Business will transition to Qlik Sense Business. Now, Qlik Sense Cloud users can begin to migrate content and users to Qlik Sense Business with a Qlik Sense Business Subscription. The video above and attached PDF can guide you through that process.

     

    Qlik Sense Business, Qlik’s newest SaaS offering, brings the power of Qlik’s third-generation analytics platform to groups, teams, and businesses that want to quickly get started operationalizing analytics and making data-driven decisions. All users get unmatched analytical power, with unique associative exploration and search, AI-powered insight suggestions, and app creation and data prep.  Qlik Sense Business is built on the same cloud-native architecture and highly-scalable cloud service as Qlik Sense Enterprise, ensuring the same consistent, seamless, and powerful experience for all users of cloud editions of Qlik Sense.

    All Qlik Sense Cloud users (Business and Basic) must migrate their content to Qlik Sense Business by December 15, 2019, or it will be lost.

    Here's what you need to know to prepare:

    Qlik Sense Cloud Business Customers on Annual Subscriptions

    You will receive two emails this week guiding you to set up Qlik Sense Business. The first email will explain the product change and how to set up Qlik Sense Business.  The second email will include a unique link to set up Qlik Sense Business.  Once you complete the set up process, Qlik Sense Business will be automatically configured to the same number of users and renewal date as your existing Qlik Sense Cloud Business subscription.  You can then begin moving content and adding users to complete the migration. In addition to receiving Qlik Sense Business at no additional charge for the duration of their current subscription term, customers will also receive a 50% discount on their first renewal of Qlik Sense Business.

    You’ll have access to both Qlik Sense Cloud Business and Qlik Sense Business through December 15, 2019 to ensure ample time to smoothly transition your content and users.

    If you didn’t receive your set-up email or the link in the email expired, please log a support case.

    Qlik Sense Cloud Business Customers on Month-to-Month Subscriptions and Qlik Sense Cloud Basic Customers

    Next month you will receive emails with information about how to sign up for a Qlik Sense Business free trial and a limited time offer for 50% off your first annual subscription of Qlik Sense Business (month-to-month subscriptions will not be available). Be sure to follow the instructions in that email to ensure you receive the discount.

    Once you sign up for a Qlik Sense Business subscription, you will also have access to both Qlik Sense Cloud Business and Qlik Sense Basic through December 15, 2019 to ensure ample time to smoothly transition your content and users.

    To learn more about how to use Qlik Sense Business, visit our Help website, and if you have questions about the transition process, post them down below.

     

     

    Show Less
  • Image Not found
  • qlik-community-blogs.jpg
    Qlik Product Innovation Blog

    Qlik DataMarket: CMS Package for Healthcare

    Qlik DataMarket happily announces the availability of CMS Provider Performance, a new Healthcare Topical package. The 1st of 5 Healthcare topical packages expected over the next 4 months.The CMS Provider Performance data package will allow healthcare providers in the US to analyze their performance as measured by patient outcomes both physical and psychological.  This data increases the transparency of hospital care and helps to establish ba... Show More

    Qlik DataMarket happily announces the availability of CMS Provider Performance, a new Healthcare Topical package. The 1st of 5 Healthcare topical packages expected over the next 4 months.


    Screen Shot 2017-09-14 at 12.59.48.pngScreen Shot 2017-09-14 at 12.58.06.png


    The CMS Provider Performance data package will allow healthcare providers in the US to analyze their performance as measured by patient outcomes both physical and psychological.  This data increases the transparency of hospital care and helps to establish baselines for quality improvement effort across the US care provider community.  Using the data customers will get performance benchmarks for treatment of various illnesses and see how they compare to others in their peer-group, city, state or nationally.

    It currently consists of three datasets.

    • Readmissions & Deaths shows, in a standardized manner, how the treatments to ailments compare across US hospitals, using data from the Center for Medicare & Medicaid Services (CMS). The data is updated annually (July)
    • Hospital Readmissions Reduction Program tracks the US Government’s program where payments for services are linked to the quality of hospital care. The data is updated annually.
    • Medicare Health Outcomes Survey (HOS), the first patient-reported outcomes measure used in Medicare managed care. Through the HOS, Medicare have gathered reliable and clinically meaningful health status data from the Medicare Advantage program to use in quality improvement activities, pay for performance, program oversight, public reporting, and to improve health.


    Today, each U.S. hospital needs to report this information but gets little use of the information in return.  Now, using this dataset, customers can ask such questions as:

    • How do my readmission rates for CABG compare to in-state hospitals?
    • What demographic groups are affected by Hypertension and what's the emotional and physical impact on a patient's accomplishments and activities?
    • What's the national readmission rate for those who receive a knee replacement procedure?

    Typically this data is hard to find and difficult to integrate into existing data models.  However, we curate the data for you and make sure that all diseases and treatments, geo-dimensions and healthcare providers have been identified and that the appropriate unique identifiers have been associated with each.  (e.g. Each type of procedure is coded with the HCSPC code (Healthcare Common Procedure Coding System)).


    To get you started quickly, the customers of the CMS Provider Performance data package will also have access to a pre-built application which can be integrated with your own data for unique insights.


    Screen Shot 2017-09-14 at 13.01.47.pngScreen Shot 2017-09-14 at 12.59.48.png

    Learn more about Qlik DataMarket visit the product page on Qlik.com or Contact a Sales Representative

    Show Less
  • Image Not found
  • qlik-community-blogs.jpg
    Qlik Support Updates Blog

    Qlik Sense June 2019 temporarily removed from the download site

    Hello Qlik Sense users,   We have unfortunately decided to remove Qlik Sense June 2019 from the download site temporarily.  This is due to a significant degrade being identified where users experienced authentication issues when accessing the QMC or the Hub via a virtual proxy having a prefix.  Currently, what we observed is that if you connect to a virtual proxy with a prefix, the request will be forwarded to the virtual proxy wit... Show More
    Hello Qlik Sense users,
     
    We have unfortunately decided to remove Qlik Sense June 2019 from the download site temporarily.  This is due to a significant degrade being identified where users experienced authentication issues when accessing the QMC or the Hub via a virtual proxy having a prefix.  Currently, what we observed is that if you connect to a virtual proxy with a prefix, the request will be forwarded to the virtual proxy without the appropriate prefix.
     
    This issue is currently being addressed and a new release will be made available as soon as possible. 
     
    We sincerely apologize for any inconvenience and we will keep you updated on developments.
     
    Kind regards
    Global Support Team
    Show Less
  • Image Not found
    Qlik Education Blog

    The Chess Game of Data & Analytics

    To start, let’s take a look back at our childhood and playing board games. How many of us liked to play the game of chess? Well, me being an absolute nerd, I still love to play chess. When we were younger and playing board games, we probably started off just playing the games, moving pieces, and knowing how to win, but not really having any strategy. Over time, as we developed our skills in board games, and maybe more importantly, as we started t... Show More

    To start, let’s take a look back at our childhood and playing board games. How many of us liked to play the game of chess? Well, me being an absolute nerd, I still love to play chess. When we were younger and playing board games, we probably started off just playing the games, moving pieces, and knowing how to win, but not really having any strategy. Over time, as we developed our skills in board games, and maybe more importantly, as we started to develop more wisdom and understanding overall, we started to figure out different ways we can play our favorite games. Eventually, we started to develop strategies to winning. When we started to develop these strategies, sometimes they worked, but other times, the other player would have strategies, and we had to revise ours. We became stronger players because we had developed strategies to winning, and most importantly, those strategies tied directly back to our goals and objectives. The game of chess is an absolutely great example of this. When we first start playing, we are scattered, excited to know how pieces move, take other pieces, and how to put people in check. But, when we come up against those who really know how to play, we noticed we were getting crushed. Then, we study, learn, and grow, and find out there is a whole world of strategy to that of chess. Of course, the overall objective and goal is to win, but at times, maybe we bring in different goals and objectives on that path to winning, and a strategy is crucial to success.

    This analogy draws perfectly into the world of data and analytical strategy trends around the world. As I have been traveling and working around the world, it is a rarity that I find an organization that has a strong data and analytical strategy that ties back to the organization’s goals and objectives. I am finding organizations of all shapes and sizes, industries, etc. know it is important to had data and analytical work, but when I ask those organizations about their strategy, goals, and objectives, I am met with blank stares. A group here or there might have a strategy, but can they tie it to the organization’s overall strategy? A different group may have its own strategy, but are they talking together? Then, an even different group wants to invest in a new, shiny software they think is going to drop knowledge bombs on the world, but they aren’t talking to anyone nor the sourcing team. Finally, underpinning all of this, is the organization’s lack of data literacy skills that will enable the goals and strategies of the data world to exist. I find this trend both promising and troubling: promising because organizations are truly wanting to succeed with data, but troubling because they will not find success with the current trends.

    The first step for an organization to build that successful data and analytical strategy is to understand the purpose of data and analytics, and how they tie back to the organization’s goals and objectives, not to understand technology and software. For far too long, organizations have been hearing software is the magic potion, only to be disappointed again and again as the ROI is not strong. This type of thinking has to shift to outcome-based approaches, where we are determining just what we want as an organization. When we do this, software and solutions can fall into place. This allows us to not force fit a strategy to a recent purchase of software.

    To help enhance this, organizations need to know what is the purpose of data and analytical strategy? For organizations to understand this, one should understand that data has many purposes and through those purposes, organizations can truly succeed in the 4th industrial revolution. In Bernard Marr’s great book, Data Strategy, he pins down three distinct things data can be used for in a data strategy:

    • Operational Improvement
    • Decision Making
    • Monetization

    These outcomes should help to underpin the data and analytical strategy an organization implements.Along with these three, organizations should also focus on:

    • Data Literacy
    • Empowerment of everyone through democratization of data and self-service analytics.

    As organizations look to capitalize on the amazing and valuable asset that is data, they should have a strong data and analytical strategy that ties back to its goals and objectives. When organizations do this, they will find the ROI they are looking for with their investments in data and analytics.

    This blog post was written by Jordan Morrow, Qlik's Global Head of Data Literacy

    Show Less
  • Image Not found
    Qlik Design Blog

    Take a Tour of Our New Cloud-based editions of Qlik Sense

          Hi guys - happy to be back in the Qlik Community teaching you about our latest Qlik Sense cloud-based deployment options / editions. In this 2 part video I take you on a simple tour of our cloud-based deployment options / editions of Qlik Sense - namely Qlik Sense Enterprise on Kubernetes, Qlik Sense Enterprise on Qlik Cloud Services and Qlik Sense Business. I start with a brief explanation of the editions and then dive right... Show More

          Hi guys - happy to be back in the Qlik Community teaching you about our latest Qlik Sense cloud-based deployment options / editions. In this 2 part video I take you on a simple tour of our cloud-based deployment options / editions of Qlik Sense - namely Qlik Sense Enterprise on Kubernetes, Qlik Sense Enterprise on Qlik Cloud Services and Qlik Sense Business. I start with a brief explanation of the editions and then dive right into the product.

     

    Part 1 focuses on a brief introduction and the creation of a simple app, while part 2 dives in deeper to the capabilities available that demonstrate how to share and manage content from the hub interface. I am working on a bonus video that goes in deeper to our latest content management capabilities - Shared and Managed spaces. So stay tuned for more content coming soon in this area by subscribing to this blog. Please note that what I present is almost identical to each cloud-based edition / deployment option - with some slight differences. We will be actively monitoring the community so please let us know if you have any comments or questions.

     

    You can experience these features and more immediately by signing up for a FREE 30 DAY trial of Qlik Sense Business here: https://www.qlik.com/us/trial/qlik-sense-business

     

    I also attached the data file I used in case you would like some sample data for your testing.

     

    Regards,

     

    Mike Tarallo
    Qlik
    https://twitter.com/mtarallo

     

    Part 1

     

     

    Part 2

     

    Helpful Resources:

    Show Less
  • qlik-community-blogs.jpg
    Qlik Technical Bulletin Blog

    Qlik September 2019 Technical Previews are Available

    The Qlik Sense September 2019 Technical Preview and Qlik NPrinting September 2019 Technical Preview are now available on their respective boards.  Head over to the boards to access the software and check out what’s new!
  • Image Not found
    Qlik Academic Program Blog

    Qlik Support Engineer positions available in Barcelona for recent graduates

    Sunny Barcelona is home to the Qlik EMEA hub office, where we bring together all different nationalities from across Europe and beyond. Here we work together to spread the word about Qlik and to provide our customers with the best possible service. As a member of this office myself, I can say from firsthand experience what a friendly, fun and supportive atmosphere there is, where the opportunities to learn are endless!   Our Technical Suppor... Show More

    Sunny Barcelona is home to the Qlik EMEA hub office, where we bring together all different nationalities from across Europe and beyond. Here we work together to spread the word about Qlik and to provide our customers with the best possible service. As a member of this office myself, I can say from firsthand experience what a friendly, fun and supportive atmosphere there is, where the opportunities to learn are endless!

     

    Our Technical Support team are now looking for Junior Engineers for Infrastructure & Deployment and Development & Design. The team provides data driven world class support to troubleshoot and resolve customer technical issues, and they do this from an office just two minutes walk from Barcelona's beautiful beach. For these positions we are looking for recent graduates with technical degrees and excellent interpersonal skills. You can read all about the full set of skills required for the roles in the job specifications here:

    Junior Technical Support Engineer - Infrastructure & Deployment

    Junior Technical Support Engineer - Development & Design

     

    Your application will certainly stand out from the crowd if you are already familiar with Qlik products. And a great way for students to gain the necessary experience is via our free Academic Program. The aim of the program is to up-skill students in Data Literacy and to enhance their employability by providing them with access to a wealth of free training resources and qualifications. You can find out more details about the program and apply here: qlik.com/academicprogram  

     

    So if you have already participated in the Academic Program and hold a technical degree, these new positions at Qlik could be ideal for you. And if you are still a student looking to enhance your CV, be sure to sign up to the Academic Program today to develop your skills ready for your first graduate roles!

     

    Show Less
  • Image Not found
    Qlik Academic Program Blog

    Virginia Techs BI Bake Off with Qlik

    The Academic Program was thrilled when Virginia Tech invited us back to be part of their annual business intelligence bake off.  The bake off was created by Professor Hoopes who teaches an MBA course about  Predictive Analytics and Data Mining for Executives.  Unlike previous years where students focused on a variety of tools, this year Qlik was the tool of choice! Qlik's very own David Lyon, a Solution Architect joined i... Show More

    The Academic Program was thrilled when Virginia Tech invited us back to be part of their annual business intelligence bake off.  The bake off was created by Professor Hoopes who teaches an MBA course about  Predictive Analytics and Data Mining for Executives.  Unlike previous years where students focused on a variety of tools, this year Qlik was the tool of choice!

    Qlik's very own David Lyon, a Solution Architect joined in on the weekend long bake off to introduce Qlik Sense and kick off the weekend.   Students attending the course joined the Academic Program for free software, a year of free training, and the option to receive a Qlik Sense certificate after passing the Qualification exam.  After the bake off, students will continue using Qlik during the semester on a case study focused around higher education.

    If you are a professor or student interested in learning Qlik, visit us at qlik.com/academicprogram any apply today!

    Show Less
  • qlik-community-blogs.jpg
    Qlik Design Blog

    Developer menu in Qlik Sense client

    Did you know there's a secret developer menu in Qlik Sense? I'm going to let you in on the secret and show you how to access it and what it contains. Just remember, this isn't documented or officially supported, and is subject to change in the future.To access the developer menu, follow the steps below:Open a sheet in a Qlik Sense app in your browserAdd /options/developer to the urlRight click on an object and choose "Developer"You can get the ob... Show More

    Did you know there's a secret developer menu in Qlik Sense? I'm going to let you in on the secret and show you how to access it and what it contains. Just remember, this isn't documented or officially supported, and is subject to change in the future.

    To access the developer menu, follow the steps below:

    1. Open a sheet in a Qlik Sense app in your browser
    2. Add /options/developer to the url
    3. Right click on an object and choose "Developer"

    3.png

    You can get the object id, properties, and layout of any object this way. There's also a link to open the object in single configurator, and test exporting. The object id's are useful for embedding visualizations. The properties are useful if you are creating your own objects and want to check the properties of an object in a Qlik Sense app for reference. In my opinion this is the most useful feature of the developer menu. Sometimes if I don't know the correct properties to set to achieve what I want I'll create a similar object in the Qlik Sense client just to check the properties. The layout shows what is returned by the engine for the layout of the object, and can be useful to see what the layout will look like before you actually create an object yourself. And the single configurator link is a handy way to get to the single configurator of an object directly from a sheet.

    4.png

    And now you know about the secret developer menu.

    Show Less
  • qlik-community-blogs.jpg
    Qlik Design Blog

    Canonical Date

      A common situation when loading data into a Qlik document is that the data model contains several dates. For instance, in order data you often have one order date, one required date and one shipped date.     This means that one single order can have multiple dates; in my example one OrderDate, one RequiredDate and several ShippedDates - if the order is split into several shipments:     So, how would you link a master ... Show More

     

    A common situation when loading data into a Qlik document is that the data model contains several dates. For instance, in order data you often have one order date, one required date and one shipped date.

     

    Base model.png

     

    This means that one single order can have multiple dates; in my example one OrderDate, one RequiredDate and several ShippedDates - if the order is split into several shipments:

     

    Logic 1.png

     

    So, how would you link a master calendar to this?

     

    Well, the question is incorrectly posed. You should not use one single master calendar for this. You should use several. You should create three master calendars.

     

    The reason is that the different dates are indeed different attributes, and you don’t want to treat them as the same date. By creating several master calendars, you will enable your users to make advanced selections like “orders placed in April but delivered in June”. See more on Why You sometimes should Load a Master Table several times.

     

    Your data model will then look like this:

     

    Model with spec calendars.png

     

    But several different master calendars will not solve all problems. You can for instance not plot ordered amount and shipped amount in the same graph using a common time axis. For this you need a date that can represent all three dates – you need a Canonical Date. This is how you create it:

     

    First you must find a table with a grain fine enough; a table where each record only has one value of each date type associated. In my example this would be the OrderLines table, since a specific order line uniquely defines all three dates. Compare this with the Orders table, where a specific order uniquely defines OrderDate and RequiredDate, but still can have several values in ShippedDate. The Orders table does not have a grain fine enough.

     

    This table should link to a new table – a Date bridge – that lists all possible dates for each key value, i.e. a specific OrderLineID has three different canonical dates associated with it. Finally, you create a master calendar for the canonical date field.

     

    Full model.png

     

    You may need to use ApplyMap() to create this table, e.g. using the following script:

     

         DateBridge:
         Load
              OrderLineID,
              Applymap('OrderID2OrderDate',OrderID,Null()) as CanonicalDate,
              'Order' as DateType
              Resident OrderLines;

         Load
              OrderLineID,
              Applymap('OrderID2RequiredDate',OrderID,Null()) as CanonicalDate,
              'Required' as DateType
              Resident OrderLines;

         Load
              OrderLineID,
              ShippedDate as CanonicalDate,
              'Shipped' as DateType
              Resident OrderLines;

     

    If you now want to make a chart comparing ordered and shipped amounts, all you need to do is to create it using a canonical calendar field as dimension, and two expressions that contain Set Analysis expressions:

     

         Sum( {$<DateType={'Order'}>} Amount )
         Sum( {$<DateType={'Shipped'}>} Amount )

     

    Bar chart.png

     

    The canonical calendar fields are excellent to use as dimensions in charts, but are somewhat confusing when used for selections. For this, the fields from the standard calendars are often better.

     

    Summary:

    • Create a master calendar for each date. Use these for list boxes and selections.
    • Create a canonical date with a canonical calendar. Use these fields as dimension in charts.
    • Use the DateType field in a Set Expression in the charts.

     

    A good alternative description of the same problem can be found here. Thank you, Rob, for inspiration and good discussions.

     

    HIC

    Show Less
  • qlik-community-blogs.jpg
    Qlik Support Updates Blog

    Qlik Sense Mobile for BlackBerry UEM and iOS 13

    Hello Qlik Sense Mobile Users. We have more information for you regarding the new release of iOS 13.   Qlik Sense Mobile does not yet formally support iOS 13 with the use of the BlackBerry UEM, in part as BlackBerry requires an upgrade of its UEM.   A compatible version of the Qlik Sense mobile client will be delivered soon, but our current recommendation is to avoid upgrading iOS devices using BlackBerry UEM to iOS / iPadOS 13 (either ... Show More

    Hello Qlik Sense Mobile Users. We have more information for you regarding the new release of iOS 13.

     

    Qlik Sense Mobile does not yet formally support iOS 13 with the use of the BlackBerry UEM, in part as BlackBerry requires an upgrade of its UEM.

     

    A compatible version of the Qlik Sense mobile client will be delivered soon, but our current recommendation is to avoid upgrading iOS devices using BlackBerry UEM to iOS / iPadOS 13 (either 13.0 or 13.1), if Qlik Sense Mobile functionality is needed.



    For questions or concerns, please don't hesitate to leave a comment or get in touch with us.

    Show Less
  • Image Not found
    Qlik Support Updates Blog

    Support Techspert Thursdays - Integrating SAML with Qlik Sense Enterprise

    Hi everyone,  Want to stay a step ahead of important Qlik support issues? Then sign up for our monthly webinar series where you can get first-hand insights from our #QlikSupport experts. Next Thursday, September 19th Qlik Support will host another Support Techspert Thursday session and this time we are looking at Integrating SAML with Qlik Sense Enterprise.   But wait, what is it exactly? Support Techspert Thursdays is a free&... Show More

    Hi everyone, 

    Want to stay a step ahead of important Qlik support issues? Then sign up for our monthly webinar series where you can get first-hand insights from our #QlikSupport experts.

    Next Thursday, September 19th Qlik Support will host another Support Techspert Thursday session and this time we are looking at Integrating SAML with Qlik Sense Enterprise.

     

    But wait, what is it exactly?

    Support Techspert Thursdays is a free webinar to facilitate knowledge sharing held on a monthly basis, on the third Thursday of each month. 

    Hear directly from Qlik Techsperts on topics that are relevant to Customers and Partners today.

    In this session we will cover:

    • Authentication Overview
    • Pre-reqs for successful deployment
    • Demo of virtual proxy setup and workflow
    • Troubleshooting common issues

    Click on this link to choose the webinar time that’s best for you.

    The webinar is hosted using ON24 in English and will last 30 minutes plus time for Q&A.

    Hope to see you there!!

    GLBL_2018_LP_Header_Questions_IMG.jpg

    Show Less
  • qlik-community-blogs.jpg
    Qlik Support Updates Blog

    QlikView and Qlik Sense - Important Security Fix now available in new Service Re...

    Qlik releases new QlikView Service Releases and new Qlik Sense Patches to address a security vulnerability. Dear Qlik users, Today we have released four new service releases across all currently supported major versions of QlikView* and six new patches across the latest versions of Qlik Sense. If you are using the following versions, this information is for you: QlikView 11.20 QlikView 12.00* QlikView 12.10 QlikView 12.20 QlikView 12.30 ... Show More

    Qlik releases new QlikView Service Releases and new Qlik Sense Patches to address a security vulnerability.

    Dear Qlik users,

    Today we have released four new service releases across all currently supported major versions of QlikView* and six new patches across the latest versions of Qlik Sense. If you are using the following versions, this information is for you:

    • QlikView 11.20
    • QlikView 12.00*
    • QlikView 12.10
    • QlikView 12.20
    • QlikView 12.30
    • Qlik Sense Enterprise any 2017 version or prior
    • Qlik Sense Enterprise February 2018
    • Qlik Sense Enterprise April 2018
    • Qlik Sense Enterprise June 2018
    • Qlik Sense Enterprise September 2018
    • Qlik Sense Enterprise November 2018
    • Qlik Sense Enterprise February 2019 

    These new service releases and patches include a fix for a security vulnerability, details of which can be found in Security Bulletin SB 000069985.

    Known internally as QLIK-94388, each new service release and patch includes, at the minimum, the fix for this vulnerability. The patches for the following Qlik Sense releases also includes other, non-security related product defect fixes.

    • June 2018 Patch 3
    • September 2018 Patch 4
    • November 2018 Patch 4

    For details, please see the attached release notes.  For all other release notes, please refer to our download site.

    Please note this patch is branched directly for the latest patch. For example, by applying Qlik Sense February 2019 Patch 2, you will also receive every fix released in Qlik Sense February Patch 1. For more details about the fixes applied in the previous patch(es), please have a look at the release note. 

    The information in this post and Security Bulletin 000069985 are disclosed in accordance with our published Security and Vulnerability Policy.

     

    Updated 5/1/2019: For further reference, we have created a list of frequently asked questions and answers which can be found here SB 000069985 FAQ.  

     

    * QlikView 12.00 is no longer officially supported.   QlikView 11.20 is under Extended Support.

    Show Less
  • qlik-community-blogs.jpg
    Qlik Design Blog

    Creating a KPI object in QlikView

    We all can agree on the fact that not all the data contained in an app is equally important, right? The most important data should be highly visible and be located in a prime location within your app. Is always interesting to recheck Michael Anthony’s post about hierarchy.KPIs are one of those elements that for sure will be at the very top of your app's first sheet, it's something you don’t want anyone to miss.Since we don’t have a KPI object in ... Show More

    We all can agree on the fact that not all the data contained in an app is equally important, right? The most important data should be highly visible and be located in a prime location within your app. Is always interesting to recheck Michael Anthony’s post about hierarchy.

    KPIs are one of those elements that for sure will be at the very top of your app's first sheet, it's something you don’t want anyone to miss.

    Since we don’t have a KPI object in QlikView’s objects library, all of us have came up with different solutions and tricks to represent a value and some contextual information next to it. All of them have one common aspect, they require several text objects to look good. This is usually ok, is not that hard to achieve a nice looking KPI using multiple text objects, but it can be really tedious to maintain.

    The object below shows an example of a KPI representing net sales, it also contains other key contextual information such as comparison vs previous year and comparison vs target. The KPI also includes graphical indicators that will let us know if the measured indicator is performing good or bad based on our goals.

    pic1.jpg

    It looks really neat but in order to achieve something like that in QlikView you will need to create and maintain a good amount of text objects as you can see.

    Today we introduce yet another alternative to text objects, it's a really smart, sexy looking, and easy-to-manage KPI object. And it’s all done using only one object! Let’s see how it’s done.


    pic3.png


    Each one of those three KPI objects are in fact a gauge chart heavily tweaked to look like a completely new KPI object. To do so you need to remove the gauge image in the gauge chart and add some text boxes as “Text in Chart”. Good news is, it all belongs to the same object now so you will be able to move it around without missing any part.


    My very favorite piece of this method is the flexibility obtained by using variables to modify each one of the moving parts that form the object making it a piece of cake to maintain. Next, I’m including a diagram of the object so you can get a better understanding of it.


    pic2.jpg

    PROS:

    • Simplified administration.
    • Global configuration options = unified look&feel.
    • Manageability, no more loose parts when moving/copying objects across sheets.
    • Minor tweaks to replicate across projects.

    CONS:

    • It might be a bit confusing for newbies due the intensive use of variables.


    I’m attaching an app (qvw) so you can just copy and paste it to your new project and explore how it's done.


    Enjoy it!

    AMZ


    PS: All kudos must go to Rasmus Andersson and Alexander Mosquera alexmosq at Mindcamp and Fredrik Thomsen and Peter Wedebrant @Qlik.


    Show Less