Qlik Community

Blogs

Hear directly from Qlik employees in our nine unique blogs. Check out the new Customer Success 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.

All about Qlik's Voice of the Customer program and Customer Success initiatives

Regular updates about Qlik Data Integration products (Qlik Data Catalyst, Qlik Compose, Qlik Replicate, Qlik Enterprise Manager, Qlik Gold Client)

Recent Blog Posts

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

    QlikView April 2019 SR2 Now Available

    Dear QlikView Users, We are pleased to confirm that QlikView April 2019 Service Release 2 (12.40 SR2) is now available on our download site. This release contains over a dozen product defect fixes, of which further details can be found in these release notes. As always when upgrading any software, make sure that you backup your system and applications before doing any installation and follow upgrading best practices. Thank you for choosing Qlik s... Show More
    Dear QlikView Users,
     
    We are pleased to confirm that QlikView April 2019 Service Release 2 (12.40 SR2) is now available on our download site. This release contains over a dozen product defect fixes, of which further details can be found in these release notes.

    As always when upgrading any software, make sure that you backup your system and applications before doing any installation and follow upgrading best practices. Thank you for choosing Qlik software.
     
     
    Kind regards
    The Global Support Team
    Show Less
  • qlik-community-blogs.jpg
    Qlik Design Blog

    qdt-components - A Components Library that can be used in simple HTML, Angular 5...

    qdt-components (Qlik Demo Team Components) is a library of components that we have developed in the demo team and that have been used in most of our mashups found in webapps.qlik.com and demos.qlik.com. It's a collection of filters, tables, barcharts, selection toolbars, or even simple getting/creating object methods from the Visualization Api. You do not have to worry about connection strings, loading Requirejs, jQuery etc. Everything is taken ... Show More

    banner-4.jpg

    qdt-components (Qlik Demo Team Components) is a library of components that we have developed in the demo team and that have been used in most of our mashups found in webapps.qlik.com and demos.qlik.com. It's a collection of filters, tables, barcharts, selection toolbars, or even simple getting/creating object methods from the Visualization Api. You do not have to worry about connection strings, loading Requirejs, jQuery etc. Everything is taken care for you! The library can be used in a simple html page by loading the qdt-components.js or in React and Angular2+ via npm.

    Today, I will show you how to load a simple object and create a session barchart, in simple html and Angular 5

    Simple HTML

    • In your HTML, add the following:

     

    <head>
      <script type="text/javascript" src="qdt-components.js"></script>
    </head>
    <body>
      <div id="qdt1"></div>
    </body>

     

    • In your Javascript code, add:

     

    var qConfig = {
       "config": {
          "host": "your-sense-server.com",
          "secure": true,
          "port": 443,
          "prefix": "/",
          "appId": "133dab5d-8f56-4d40-b3e0-a6b401391bde"
       },
       "connections": {
          "vizApi": true,
          "engineApi": false
       }
    }
    
    var QdtComponent = new window.qdtComponents.default(qConfig.config, qConfig.connections);
    
    var element = document.getElementById('qdt1');
    
    QdtComponent.render('QdtViz', {id: 'a5e0f12c-38f5-4da9-8f3f-0e4566b28398', height:'300px'}, element);

     

    And you are done.

    Simple HTML template: GitHub - qlik-demo-team/qdt-html-template: A simple html template that uses qdt-components

    Live Demo: Simple html with qdt-components

     

    Angular 5

    npm install --save qdt-components
    • Create new component by typing in the command line
    ng generate component components/qdt-components --style=less
    • In your qdt-component.component.ts import the library and import or set the qConfig with the connection details
    import { Component, OnInit, ElementRef, Input } from '@angular/core';
    // import * as qConfig from '../../../qConfig.json';
    
    import QdtComponents from 'qdt-components';
    
    let qConfig = {
       "config": {
          "host": "sense-demo.qlik.com",
          "secure": true,
          "port": 443,
          "prefix": "/",
          "appId": "133dab5d-8f56-4d40-b3e0-a6b401391bde"
       },
       "connections": {
          "vizApi": true,
          "engineApi": false
       }
    }
    • Replace the class with:
    export class QdtComponentComponent implements OnInit {
       @Input() Component: Function;
       @Input() props: object;
    
       static QdtComponent = new QdtComponents(qConfig.config, qConfig.connections);
    
       constructor(private elementRef: ElementRef) { }
    
       ngOnInit() {
          QdtComponentComponent.QdtComponent.render(this.Component, this.props, this.elementRef.nativeElement);
       }
    }
    • After this, you can start using it in any other component. In the HTML, add:
    <qdt-component [Component]="'QdtViz'" [props]="{id: 'a5e0f12c-38f5-4da9-8f3f-0e4566b28398', height:'300px'}"></qdt-component>

    Angular Template: GitHub - qlik-demo-team/qdt-angular-template: An Angular 5 template that is using qdt-components for connecting to Qlik …

    Live Demo Angular 5: https://webapps.qlik.com/qdt-components/angular5/index.html

    Live Demo Angular 6: https://webapps.qlik.com/qdt-components/angular/index.html

     

    React 16.3

    Live Demo: https://webapps.qlik.com/qdt-components/react/index.html

    Git Repo: https://github.com/qlik-demo-team/qdt-react-template

     

    Vue 2.5

    Live Demo: https://webapps.qlik.com/qdt-components/vue/index.html

    Git Repo: https://github.com/qlik-demo-team/qdt-vue-template

     

    qdt-components

    Branch: Qlik Branch

    Github: GitHub - qlik-demo-team/qdt-components: React Components to be used with Angular2+ and React. Connects with the Capabili…

    Npm: qdt-components

     

    Yianni

    Show Less
  • Image Not found
    Qlik Product Innovation Blog

    Dual Use Licensing is Now More Flexible, Easier to Qualify for and Simpler to Im...

    Several major changes have recently been made to the QlikView and Qlik Sense Dual Use Licensing offer. These changes make Dual Use Licensing more flexible, easier to qualify for and simpler to implement. First, we’ve opened-up a subscription option, which accommodates a Capacity licensing model for greater flexibility, so you don’t have to worry about the complications associated with a mixed site (perpetual and subscription). You’ll be able to l... Show More

    Several major changes have recently been made to the QlikView and Qlik Sense Dual Use Licensing offer. These changes make Dual Use Licensing more flexible, easier to qualify for and simpler to implement.

    First, we’ve opened-up a subscription option, which accommodates a Capacity licensing model for greater flexibility, so you don’t have to worry about the complications associated with a mixed site (perpetual and subscription). You’ll be able to leverage new functionality sooner and adopt a more unified approach to Qlik product usage. And now, to leverage Dual Use licensing, you can either convert Session and Usage CALs directly to subscription to take advantage of the Capacity model or convert them to Named User and Doc CALs then to the standard Professional and Analyzer licensing model for Dual Use.

    Dual_Use_Customer_Journey.pngQlikView Customer Journey -- Dual Use Licensing

    To utilize Dual Use under subscription, there is a 40% uplift on annual QlikView maintenance for a 3-year term. Under the perpetual model, Dual Use licensing is available for a 30% uplift on your annual QlikView maintenance.

    We’ve also removed the July 1, 2018 offer cut-off date to make it easier to qualify for QlikView and Qlik Sense Dual Use Licensing. This means, regardless of QlikView version or when you initially purchased QlikView, you are eligible* for the Dual Use offer, so long as you’re current on maintenance (Federal and accounts with Enterprise License Agreements continue to be ineligible). Additionally, you are not required to upgrade your release, though we strongly encourage you to use the current version to leverage Professional, Analyzer, Capacity licensing; unified licensing (described further below); and QlikView links in Qlik Sense Enterprise on Qlik Cloud Services and Kubernetes. Conversion to Dual Use remains a one-time event.

    Unified licensing, available with QlikView and Qlik Sense April 2019 releases, aligns licensing of QlikView and Qlik Sense, entitling users to both products using a single license key enabled by the Qlik Licensing Service (QLS), to simplify Dual Use adoption. Unified licensing supports Qlik’s one user, one license, one analytics experience vision (formerly known as 1x1x1), with the goal to deliver a single access point for both QlikView and Qlik Sense, bringing the products closer together. Functionality providing greater alignment between products will be delivered later this year. 

    Qlik Dual Use Services help simplify Dual Use adoption preparing you to maximize your investment, whether creating new apps in Qlik Sense or transitioning existing apps from QlikView to Qlik Sense.

    Customer Success for Dual Use.png

    Furthermore, our new version of the QlikView Governance Dashboard provides a Sense Profile Score to answer questions about different QlikView app characteristics. More information can be found in this blog post. This app can be downloaded for free from the Qlik download site.

    Contact your account manager for more information on QlikView and Qlik Sense Dual Use licensing. 

    *Exceptions: CPU Cores or IAS Server licenses     

    Show Less
  • Image Not found
    Qlik Support Updates Blog

    Security Rules and Performance in Qlik Sense

    Security rules are a very powerful tool intended to assist Qlik Sense administrators in managing access to Qlik Sense features. Using these rules administrators can manage not just the ability to access or create applications, but almost all features of the product including data connections, streams and even individual components of the Qlik Management Console.   This allows administrators to define user and administration roles that closely mat... Show More

    Security rules are a very powerful tool intended to assist Qlik Sense administrators in managing access to Qlik Sense features. Using these rules administrators can manage not just the ability to access or create applications, but almost all features of the product including data connections, streams and even individual components of the Qlik Management Console.

     

    This allows administrators to define user and administration roles that closely match unique organization needs rather than merely rely on an out of the box user model. Unfortunately, this comes at a cost, when a user logs in and access the system all the relevant security rules need to be evaluated to determine the correct access rights for the current screen. This can potentially lead to long load times and poor performance in especially in large systems.

     

    This blog post will cover a summary of the default user model Qlik Sense ships with, along with a closer examination of how security rules are evaluated and cached and in doing so will provide a framework for administrators to ensure that they can get the most out of their system and where possible reduce unintentional performance impacts on users.

     

    The Default Security Rules

    Qlik Sense ships with a set of default security rules that provide a set of administration roles and user roles for organisations to use and modify to meet their own needs.

     

    When you first log in to a fresh installation of Qlik Sense September 2019, you will be greeted with a set of 63 rules which all work together to create that initial user model.

     

    Broadly speaking the model works as follows (Items in bold are unchangeable rules and are always true):

    In the Hub:

    • Users can create apps
    • Owners of items can see those items
    • If you can read a stream, you can read all apps published to the stream
    • If you can read an app, you can read the content of that app
    • If you can update an app, you can update the contents of that app
    • If you can read an unpublished app, you can create objects that are part of that app
    • If you can read a published app, you can create some objects on that app
    • Everyone has access to the Everyone Stream
    • Administrators have access to the Monitoring Apps stream

     

    In the QMC:

    • The Service Account has access to everything
    • The Root Administrator has access to everything
    • Audit Administrators have access to audit sections and entities
    • Content Administrators have access to content section, entities and connection related security rules
    • Deployment Administrators have access to deployment sections and entities, apps (to manage load balancing) and license rules
    • Security Administrators have access to security sections and entities

     

    As you can see there are two separate contexts for rules and that, for the most part administrator roles only impact the Qlik Management Console. This is because all administration activity is expected to happen in the QMC and not the hub. It is possible, and in some cases desirable, for your root administrator to operate entirely without an assigned license, though this does prevent them from using the monitoring applications.

     

    One final note about Security rules in Qlik Sense. Rules can only ever add privileges, they can never take them away. This is very important when trying to design your access model, try to think in terms of what users can do, rather than in terms of what they cannot do and the structure of your rules will flow much more easily.

     

    Security Rule Evaluation

     

    Let’s go a little deeper and focus on how the system evaluates security rules.

    Every rule has a set of attributes that are used during evaluations:

    • Context (Does this rule apply in the QMC, the Hub or both)
    • Resource Filter (The parts of the system the rule covers)
    • Actions (The privileges the rule grants)
    • Conditions (The set of conditions that ultimately determine who is granted the actions)
    • A Score (A dynamically generated metric indicating how useful the rule is, the more

     

    When a user accesses Qlik Sense, the system pulls only rules relevant to the current context and resources (for example, when accessing the hub, we need to evaluate the rules for a user’s apps, as well as the rules for streams).

     

    The system also will retrieve the relevant resources (in this case all published applications, applications the user owns, and all streams) to evaluate the combination of rules, user and resources.

     

    It runs through these rules in score order, these scores are stored in the Security Rule Evaluation Cache, which means the values are lost every time the system restarts.

     

    Once it has finished evaluating the rules, the results are stored in the Security Rule Evaluation Cache so that the next time this user accesses the same page the system can simply retrieve the result of the calculation from the cache and if necessary only evaluate the rules on new apps.

     

    The system will exit the evaluation early if the user has already been granted all the requested rights to a resource. For example: the Root Administrator will generally find most of the QMC will load very quickly because the rule evaluation is very simple. One of the oldest rules in any given system grants them all privileges on everything in the QMC, that rule will generally score very highly and so be evaluated very early and then there is no need to perform any further checking as rules can only add and not take away.

     

    On the other hand, a limited user who has been granted access to only the Apps Section of the QMC and a small handful of applications may find that interface takes a very long time to load as the system will first need to evaluate enough rules to give access to the requested resource (i.e. in a system that has no previous evaluation, the less access the user has the longer the evaluation will take.

     

    Finally, security rule evaluation takes place on a mixture of different nodes, some evaluations will take place on the node with the proxy you are connecting to, some will take place on the node with the engine, and some will take place on the central node.

     

    In the case of QMC activity, all evaluations will take place on the central node, and in the case of very limited users, those evaluations will be relatively lengthy and complex. On larger systems this can lead to a rather slow user experience on the QMC. In extreme cases this can lead to the system becoming effectively unavailable on all nodes. In Qlik Sense September 2019 we have implemented 2 feature flags to increase the scalability of the QMC at the cost of reduced functionality.

     

    See How to enable QMC Limits in Qlik Sense (KB 000086580) for details.

     

    The Security Rule Evaluation Cache

     

    In the previous section I mentioned the Security Rule Evaluation Cache Cache, which stores the results of security rule evaluations in order to speed up future access. Why then does your system seem to slow down as more users and apps are added? After all the cache should eventually cover all common system activities.

     

    The cache is deliberately designed to be short lived, there are many circumstances under which it is either partially or wholly invalidated or discarded, meaning that a full rules evaluation needs to be completed once more. This is broadly because we need to know that the cache is correct, anytime something changes (or could have changed) we cannot rely on the cache and must revert to the slower approach.

     

    There are basically 3 types of cache invalidation:

    1. Complete invalidation (The entire cache is discarded)
    2. User based invalidation
    3. Entity based invalidation

     

    1. Complete Invalidation

    • Any change to security rules, load balancing or license rules
    • Any change to custom properties values (i.e. the potential possible values a custom property can be assigned)
    • When the system is restarted (the cache is never written to disk, and rules may have changed since the service last started)
    • If the connection to the database is disrupted

     

    As these changes could have a wide ranging impact, the entire cache is discarded and must be rebuilt by user behavior.

     

    When this cache is invalidated, the scores for every rule are also reset to 0, meaning that we also lose any optimizations gained since the session started.

     

    2. User based invalidation

    • Any change to a user attribute (e.g. the user is added or removed from a group)
    • A user’s custom properties are changed

    Rules are often based on user attributes, changes to that user mean we cannot ensure the cached results still apply, so we discard the cached results linked to that user.

    3. Entity based invalidation

     

    • Almost any change to a single entity. (e.g. changing an app’s name or owner, approving a community sheet, renaming a data connection)

     

    Much like with users, changing any aspect an entity or resource that can be addressed in a rule means that we cannot ensure the cached results still apply for that entity, so we discard the cached results linked to it.

     

    In Qlik Sense February 2019, additional logging was implemented to record when a cache invalidation occurs along with its type (Complete, User, Entity)

     

    Recommendations/Best Practices:

     

    If you want to provide the best performance for your users try to make rule changes near scheduled downtime, when the cache is already going to be invalidated due to a service restart.

     

    To reduce the number of evaluations that need to take place, try to ensure you have a regular clean up process where you export and delete old apps that are no longer in use.

     

    Limited users in the QMC should also have a very limited scope, i.e. only get access to one or two sections. Where possible try to centralise QMC activities to a smaller number of administrators rather than expand access to the entire user base. In a large organization it is better to have a small number of administrators and a ticket system than to grant every developer access to the QMC for small scale task management.

    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 businesses... 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. 

    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
  • qlik-community-blogs.jpg
    Qlik Technical Bulletin Blog

    Technical Previews: Qlik Sense November 2019 & Qlik NPrinting November 2019

      The Qlik Sense November 2019 Technical Preview and Qlik NPrinting November 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!
  • qlik-community-blogs.jpg
    Qlik Design Blog

    Qlik Sense Cloud Business Update - MS SQL, Web File and more!

    In this edition of the Qlik Design Blog, Denise is back discussing some additional connectivity updates for Qlik Sense Cloud Business and Qlik Sense Cloud Basic.What's NewQlik Sense Cloud Business users have been eagerly waiting for direct connectivity to an on-premise Microsoft SQL Server. We’ve seen rapid adoption of Qlik Sense Cloud Business’s connectors to cloud data sources – Salesforce, web connectors, etc. – over the past few months, but w... Show More

    In this edition of the Qlik Design Blog, Denise is back discussing some additional connectivity updates for Qlik Sense Cloud Business and Qlik Sense Cloud Basic.

    What's New

    Qlik Sense Cloud Business users have been eagerly waiting for direct connectivity to an on-premise Microsoft SQL Server. We’ve seen rapid adoption of Qlik Sense Cloud Business’s connectors to cloud data sources – Salesforce, web connectors, etc. – over the past few months, but we know that just because you’ve moved your analytics to the cloud, you haven’t necessarily moved all of your data there. In this article you will find how to set up the connector and to learn about few other Qlik Sense Cloud updates.

    MS SQL Server in Qlik Sense Cloud Business

    The process of setting up connectivity between Qlik Sense Cloud Business and a MS SQL Server is similar to what you’ve done to set up other connectors. A prompt will ask you to enter the appropriate host information (server host name, port number, available database, and credentials) to establish the connection and allow access passed the firewall. Check out Mike Tarallo’s video below to see how he set up connectivity between his SQL server and the Qlik Sense Cloud Business environment (thanks Mike!). And, don’t forget, you can use the automated data refresh functionality to update your Qlik Sense apps from your MS SQL data!

    Here are a few other updates and improvements that have also been introduced to the Qlik Sense Cloud offering:

    Web File Connectivity

    You might already have learned a trick to use the REST Connector in Qlik Sense Cloud Business to directly connect to web files, but we’ve now added a separate web file connector so that users have a much simpler and easier way to connect to an unsecured web file. Basically any file source that Qlik Sense can connect to (HTML tables, csv, xml, xls, etc) can also be made available over the web via HTTP and even FTP. Please refer to our online help to learn how to configure these types of connections. As an added bonus, this connector is now available in both Qlik Sense Cloud Business and Qlik Sense Cloud Basic. Qlik Sense Cloud Basic users now have another way to load data in addition to uploading files allowing them to freely experience how the associative model works to uncover insights across multiple data sources.

    App Governance

    When using Qlik Sense Cloud business you can have up to 50 users within a workspace. With up to 50 users viewing and editing multiple apps, group members often want transparency around when apps were accessed and by whom. We’ve added a “recent history” data stream to apps in the collaborative workspace so users have visibility into group activity, making governance and communication even easier to manage. Simply click on the “i” icon in any app to view the details:

    app_gov.png

    Data Wizard Redesign

    As you’ve been building out new apps, you probably noticed that the Data Wizard looks a little different lately. All of the same functionality exists – upload or attach files, access to Qlik DataMarket, etc. - but we’ve listed options differently for better usability. The biggest improvement is that all available connectors will be visible on the screen, which will be particularly helpful when we launch the next group of connectors on the way – check back soon!

    data_wiz.png

    NOTE: To increase resolution or size of the video, select the YouTube logo at the bottom right of the player. You will be brought directly to YouTube where you can increase the resolution and size of the player window. Look for the 'settings' gears icon in the lower right of the player once at YouTube.

    denise.pngDenise LaForgia is a Senior Product Marketing Manager focused on Qlik cloud solutions. On an occasional basis, Denise will share updates on our Qlik Sense Cloud solutions on the Qlik Design blog so please subscribe and stay tuned. You can also download the videos mentioned in these blog, see the .mp4 attachment on the bottom.

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

    Setting Color in Master Dimensions and Measures

    One of the new enhancements in the June 2017 release of Qlik Sense is the ability to define colors in dimensions and measures in the master items library.  When creating a dimension or measure in master items, users now can specify a color that will be used for the dimension or measure.  This makes it easier for users to be consistent in their color choices throughout their app.  Every time the master item is used, the specified color will also b... Show More

    One of the new enhancements in the June 2017 release of Qlik Sense is the ability to define colors in dimensions and measures in the master items library.  When creating a dimension or measure in master items, users now can specify a color that will be used for the dimension or measure.  This makes it easier for users to be consistent in their color choices throughout their app.  Every time the master item is used, the specified color will also be used.

    I found this new feature helpful when building out visualizations for an app.  The design required that measures that showed the actual number be a rusty color while standard measures appeared as gray.  I could do this by selecting the color I wanted to use for each measure when I created the master item.  Let’s take a closer look at how I added the coloring in the objects below.

    charts.png

    The 3 KPIs on the left are measures.  In each one, I specified the color when I created the measure.  In the image below, you can see the new color option when you create/edit a dimension or measure.

    edit measure.png

    When I use the measure in a KPI, the color is automatically set since I specified it in the master item.  In the Cost Variance KPI at the top, I wanted to add conditional coloring instead of the color I specified in the measure so I selected the option to not use the library in this object as seen below.  This flexibility allowed me to take advantage of the conditional coloring when needed.  Note: The ability to turn off “Use library” is not available in all objects.

    Color.png

    In the combo chart, the bars and lines were colored based on the measure color giving me the ability to color the bars and line in the chart exactly as the design required.  While this may seem small, it is a huge enhancement for users and expands the design capabilities of Qlik Sense.  The color palette also provides several different color options so apps can be branded as needed.  To learn what else is new in Qlik Sense June 2017, check out Michael Tarallo’s blog.

    Thanks,

    Jennell

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

    Qlik Sense Patch Wednesday* - New releases available

    Hello Qlik Sense Users,  We are pleased to announce the availability of the latest installment of Qlik Sense Patch Wednesday* releases.  The following patches were released today and are now available on the download site.  April 2019 Patch 6 - details on included fixes can be found here .June 2019 Patch 8 - details on included fixes can be found  here.September 2019 Patch 4 - details on included fixes can be found here.November 2019 Patch 3 - de... Show More

    Hello Qlik Sense Users,
     

    We are pleased to announce the availability of the latest installment of Qlik Sense Patch Wednesday* releases.  The following patches were released today and are now available on the download site.


     
    April 2019 Patch 6 - details on included fixes can be found here .
    June 2019 Patch 8 - details on included fixes can be found  here.
    September 2019 Patch 4 - details on included fixes can be found here.
    November 2019 Patch 3 - details on included fixes can be found here.


    Thank you for choosing Qlik software.  As with all software, please follow best practices when upgrading and make sure you back up your system before making any changes.
     


    Kind Regards,
    Global Support
     
    *The terms of this program and under review and are subject to change.

    Show Less
  • Image Not found
    Qlik Product Innovation Blog

    Qlik Data Catalyst December 2019 - Expanding interactions with the cloud

    We already offer a tight integration between Qlik Sense and Qlik Data Catalyst, especially around the organization of QVD files.  Now you can integrate Qlik Data Catalyst with the cloud editions of Qlik Sense.  Directly loading on-premises data into a cloud edition of Qlik Sense is typically not allowed by a customer's IT department due to security concerns.  Qlik Data Catalyst is now able to offer two new capabilities to address this issue:  1. ... Show More

    We already offer a tight integration between Qlik Sense and Qlik Data Catalyst, especially around the organization of QVD files.  Now you can integrate Qlik Data Catalyst with the cloud editions of Qlik Sense.  Directly loading on-premises data into a cloud edition of Qlik Sense is typically not allowed by a customer's IT department due to security concerns.  Qlik Data Catalyst is now able to offer two new capabilities to address this issue: 

    1.  The Publish capability has been expanded to allow users to automatically and securely publish data to a QCS Landing Zone (an S3 bucket).  Data is delivered in the QVD file format except for Sample and Profile data which is delivered in the JSON format. Cloud users can then browse and consume data using their existing Qlik S3 Connector.  This capability includes the ability to maintain obfuscation of sensitive data.

    QCS data transfer.pngDataset that was transferred by Qlik Data Catalyst into a cloud edition of Qlik Sense

    2.  Alternatively, a Qlik Data Catalyst user can publish data on-demand to cloud editions of Qlik Sense by selecting a new Publish to my QCS option in the Take Action menu. 

    Take Action.png

     

    This release also marks an important first step in elevating Qlik Data Catalyst to be a full member of the Qlik Kubernetes-based ecosystem as Qlik Data Catalyst December 2019 is additionally packaged as a set of Docker Containers. We plan on integrating modules of Qlik Data Catalyst more fully into the Kubernetes environment in future releases.

    Finally, for Qlik Sense users, Qlik Data Catalyst December 2019 includes important new QVD-related usability improvements including the automatic scheduling of QVD incremental loads, displaying QVD Qlik lineage and performance enhancements.

    QVD Scheduler.pngSchedule automatic, recurring synchronization of QVD filesLineage.pngView QVD lineage including source file

    Join us in the Qlik Community to be part of the conversation on how Qlik Data Catalyst will interact with Qlik Sense as well as what we're planning to do at Qlik World.  

    Show Less
  • 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 and share ap... 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
  • Image Not found
    Qlik Design Blog

    Curious about QlikWorld? Explore the New QlikWorld Forum

          Hi guys – I have some great news to share in preparation for our annual customer and partner conference, Qlik World, formerly known as Qonnections. For the first time, you will now be able to immediately join the discussion with those attending QlikWorld - including Qlik’s team of experts - on event-related content and events – all via our Qlik Community forum. We have created a new forum in the Qlik Community where you can post questions, ... Show More

          Hi guys – I have some great news to share in preparation for our annual customer and partner conference, Qlik World, formerly known as Qonnections. For the first time, you will now be able to immediately join the discussion with those attending QlikWorld - including Qlik’s team of experts - on event-related content and events – all via our Qlik Community forum.

    We have created a new forum in the Qlik Community where you can post questions, view Qlik World documents and learn more about the informative sessions you may want to attend. You will have inside access to many of the Qlik World key topics and themes to be presented, giving insight into our 2020 direction. There will be a selection of Qlik employees available to “Qonnect” with – whether they are product specific or event related, who will have the answers for you! . You can also subscribe to boards in the Qlik World forum to be notified of content that is published.

    Areas available:

       • Data Analytics Platform
       • Data Integration Platform
       • Data Literacy
       • Customer Success & Use Cases
       • Customer Success & Data Literacy
       • Technical Training & Certifications
       • Event Info
       • Panel & Round Table Sessions
       • Partner Success & Integration

    So get connected, be involved and share your ideas with your peers and Qlik’s data and analytics experts who are passionate about Qlik's platform, transforming business processes and driving data-driven insights. This forum will get you energized and ready for Qlik’s largest customer and partner event of the year. Let’s start a discussion.

    Join me in the QlikWorld forum today.

    Check it out!

    Register for QlikWorld here.


    BTW - here is a shameless plug - check out what I'll be up to at QlikWorld - have a question? Let us know, we'll do our best to answer. 

    Hope to see you there!

    Regards,
    Mike Tarallo - Twitter
    Qlik

     

    Show Less
  • Image Not found
    Qlik Academic Program Blog

    Data Literacy – The most important job skill for 2020

    It’s official! In a recent Forbes article covering the 10 most important job skills employees need in 2020, data literacy came top of the list. Author Bernard Marr discusses how the 4th industrial revolution is bringing about change to the skills and experience required of the modern workforce. Perhaps taking inspiration from the 2017 Economist report “The world’s most valuable resource is no longer oil, but data,” Marr highlights that organisati... Show More

    It’s official! In a recent Forbes article covering the 10 most important job skills employees need in 2020, data literacy came top of the list. Author Bernard Marr discusses how the 4th industrial revolution is bringing about change to the skills and experience required of the modern workforce.

    Perhaps taking inspiration from the 2017 Economist report “The world’s most valuable resource is no longer oil, but data,” Marr highlights that organisations who do not harness the power of their data will fall behind. “…to make data valuable, organizations must employ individuals who have data literacy and the skills to turn the data into business value.”

    In addition to data literacy being the number one skill, critical thinking and complex decision making also feature in the list. The abilities to objectively evaluate the credibility of information, and to take findings from data whilst simultaneously considering how decisions can impact the people in an organisation are key to success.

    You can check out the complete list in the full article here: https://www.forbes.com/sites/bernardmarr/2019/10/28/the-10-most-important-job-skills-every-company-will-be-looking-for-in-2020/#1a7b251867b6

    At Qlik, the importance of Data Literacy has long been recognised, and that’s why our Data Literacy courses and certifications are free for everyone to access. A whole host of topics are covered from an overview of data literacy, to data informed decision making. Qlik has also launched the Data Literacy Project, a global community aiming to develop the tools to shape a data literate society. 

    In addition, if you are a University student or academic you are also eligible to join our free Qlik Academic Program. Not only does this give you access to our industry leading Qlik Sense software and training materials, but also a Data Analytics curriculum and Qlik Sense Qualifications. The Qlik Sense Qualifications along with the Data Literacy Certification can be a great way to help you stand out from the crowd in job interviews, and to prove that you have the skills required of the modern workforce for 2020.

    Sign up today by visiting: qlik.com/academicprogram

    Show Less
  • Image Not found
    Qlik Product Innovation Blog

    Be a QlikWorld Insider – and Join in on the fun!

    New this year: we want to increase engagement with those who are attending and give those who are considering attending an area to interact with peers, sponsors and the Qlik team.  To this end, we are launching a new Qlik Community space dedicated to QlikWorld – Introducing the QlikWorld Forum! This is a new space dedicated to all things QlikWord, to give you the opportunity to interact with customers, partners and Qlik experts on event-related c... Show More

    New this year: we want to increase engagement with those who are attending and give those who are considering attending an area to interact with peers, sponsors and the Qlik team.  To this end, we are launching a new Qlik Community space dedicated to QlikWorld – Introducing the QlikWorld Forum!

    This is a new space dedicated to all things QlikWord, to give you the opportunity to interact with customers, partners and Qlik experts on event-related content.     Chat with our team of experts on how Qlik helps enterprises move faster, work smarter, and lead with data.    This QlikWorld Community forum will give you an inside look into sessions that will be featured at the event, to help you understand how Qlik provides an open-ended and curiosity-driven exploration platform, giving everyone – at any skill level, the ability to make real discoveries that lead to real outcomes and transformative changes.  

    Get informed on some of the key topics and themes that will be featured throughout the event to help you understand more about the latest innovations and where Qlik is heading next.   The forum will drive conversations around key themes, such as: managed data lakes, data warehouse modernization, cdc streaming, our platform - the technology and underlying architecture, and the strategy around our cloud and SaaS offerings.   We will also cover topics specific to governed self-service, augmented and embedded analytics, the modernization of BI and how Qlik drives Data literacy for all.      All this and more!

    Get connected, be involved and share your biggest and boldest ideas with some of Qlik’s passionate data and analytics experts.   This forum is sure to get you energized and ready for Qlik’s largest customer and partner event of the year.

    Check it out, join in and start a discussion!

     

     

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

    Technical Previews: Qlik Sense & Qlik NPrinting for February 2020

    The Qlik Sense February 2020 Technical Preview and Qlik NPrinting February 2020 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 Product Innovation Blog

    Introducting Partner ID to Qlik SaaS offering

    This feature can be found in My Qlik, another recently added tool that provides a single location for users to manage their Qlik identity and their Qlik Sense subscriptions. As part of this management, users can now associate a Partner ID with their subscription. The Partner ID is a six-digit number that uniquely identifies a partner to Qlik. To associate the Partner ID to your subscription, the first step is to talk to your Partner and ask them ... Show More

    This feature can be found in My Qlik, another recently added tool that provides a single location for users to manage their Qlik identity and their Qlik Sense subscriptions. As part of this management, users can now associate a Partner ID with their subscription.

    The Partner ID is a six-digit number that uniquely identifies a partner to Qlik. To associate the Partner ID to your subscription, the first step is to talk to your Partner and ask them what number you should use. Once you have that number, you can log into My Qlik (https://myqlik.qlik.com/portal/). Then, by clicking on the Subscriptions tab, you will be able to see your subscriptions.

    Within the subscription tile you can click on the edit button and add the Partner ID.

    JanMonthly1.png

     

    If a Partner ID has already been entered, you can also change it, or delete it entirely.

    JanMonthly2.png

     

    It’s all about improving your experience with Qlik!   The My Qlik Portal is an area where Qlik Sense users will have the ability to digitally purchase and manage Qlik Sense Business Subscriptions and their own information among many other things.

    More to come in the near future around the My Qlik Portal - stay tuned!

     

    Show Less
  • Image Not found
    Qlik Design Blog

    Qlik Sense Business - Register Your Tenant, Create Your First App and Resource R...

    Hi Guys        Recently, we've had some communication in regards to the registration process for a Qlik Sense Business tenant. Though, it is fairly simple and straightforward, some people prefer to see it in action first before actually attempting to do it. So I decided to show you the steps needed to register the tenant both with or without a Qlik Account.  I have also created a quick video showing how quickly you can create your first Qlik Sens... Show More

    Hi Guys

           Recently, we've had some communication in regards to the registration process for a Qlik Sense Business tenant. Though, it is fairly simple and straightforward, some people prefer to see it in action first before actually attempting to do it. So I decided to show you the steps needed to register the tenant both with or without a Qlik Account. 

    I have also created a quick video showing how quickly you can create your first Qlik Sense app and add data to it. (Sample data file attached below). Note these videos can be quickly used in situations where you just need to get started as quickly as possible and don't necessarily have the time to watch a longer product tour (also available).

    Please see link below for other detailed resources and let me know if you have any comments or question.

    Also - don't forget to enter the #QlikHighlights2019 $100 Amazon Giveaway for your chance to win a $100 Amazon gift card. Official rules and more information available here: https://community.qlik.com/t5/Qlik-Design-Blog/The-QlikHighlights-100-Gift-Card-Giveaway-Starts-Today/ba-p/1663495

    Regards,

    Mike Tarallo
    Qlik

    Register Your Qlik Sense Business Tenant

    Create Your First App

    Resources

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

    QlikView 12.00 End of Support nears

    Dear QlikView users,This is just a reminder that support for QlikView 12.00 ends on 16 November 2018 in line with our current QlikView Release Management Policy, see Policy Doc.   End of support is 2 years after the release of the next version, which was 12.10 - released on 16 November 2016.   In the table below we highlight End of Support dates for QlikView versions for QlikView 12.X:QlikView VersionReleasedEnd of SupportQlikView 12.00December 2... Show More

    Dear QlikView users,

    This is just a reminder that support for QlikView 12.00 ends on 16 November 2018 in line with our current QlikView Release Management Policy, see Policy Doc.   End of support is 2 years after the release of the next version, which was 12.10 - released on 16 November 2016.   In the table below we highlight End of Support dates for QlikView versions for QlikView 12.X:

    QlikView VersionReleasedEnd of Support
    QlikView 12.00December 201516 November 2018
    QlikView 12.10November 2016November 2019 *
    QlikView 12.20November 2017November 2020 *
    QlikView 12.30November 2018Not Determined Yet

    We  hope that you find the above information useful.  If you have any questions, please do not hesitate to contact Qlik Support.

    Kind regards

    Global Support Team

    * According to the published Qlik QlikView Release Policy as of November 2018.

    Show Less
  • Image Not found