Qlik Community

Blogs

Hear directly from Qlik employees in our ten unique blogs. Check out the new Product Insight & Ideas Blog!

Announcements
Attachments getting stuck in the virus scanner. The team is investigating.
cancel
Showing results for 
Search instead for 
Did you mean: 

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

Learn about what's new in the Qlik Product Insight & Ideas forum.

Recent Blog Posts

  • Image Not found

    Qlik Gallery

    THE QLIKVIEW WONDERFULL "THEMEs & LAYOUTs"

    For each customer a unique customized dashboard!The secret is a "user experience" that I call "immersive"where KPIs and functionality create a true"self service discovery analysis"by stimulating future observation ...------------------------------------------------------------* Do you want to Train quickly and effectively?* Do you need targeted support?* Do you want to use a ready-made QView Template?* Do you want to migrate QView apps to QSense ... Show More

    For each customer a unique customized dashboard!
    The secret is a "user experience" that I call "immersive"
    where KPIs and functionality create a true
    "self service discovery analysis"
    by stimulating future observation ...
    ------------------------------------------------------------
    * Do you want to Train quickly and effectively?
    * Do you need targeted support?
    * Do you want to use a ready-made QView Template?
    * Do you want to migrate QView apps to QSense quickly?
    * Want to adopt a framework to speed up developments?

    The MAIN projects with my UI/UX framework

     

    Galaxy.jpg

     

     

    The main project...

    Show Less
  • Image Not found

    Qlik Gallery

    A NEW "NPRINTNG MASTER CONSOLLE

    New Function of my own QLIK Framework...My new Dashboard to simultaneously explore all the information available ... Apps, Connections, Filters, Rules, Conditions, Reports, Users, Scheduling and more... The Dashboard in action    
  • Image Not found

    Qlik Design Blog

    Using Nebula.js with React.js or in Simple html pages

    Nebula.js is an open source “collection of JavaScript libraries, visualizations, and CLIs that helps developers build and integrate visualizations on top of Qlik's Associative Engine”.It connects to all of our available Qlik Sense products, including the Qlik hosted, Qlik Sense Business and Qlik Sense Enterprise for SaaS.You can find documentation and how to get started herehttps://qlik.dev/libraries-and-tools/nebulajs.
  • Image Not found

    Qlik Support Updates Blog

    Featured Content Friday – Qlik Engine Health-Check Analysis

    Hello Qlik Users!Not only is it Friday but it is also Featured Content Friday!Today we are featuring another long-time Qlik user (12 years to be exact) and Qlik Luminary:Radovan of EMARK!When asked what his favorite thing about Qlik is, he said:“Very fast answers (because in-memory) to complex business questions (because data is associated, not queried) on top of large amounts of data (because 10s of millions on data records can be handled on a n... Show More

    Hello Qlik Users!

    Not only is it Friday but it is also Featured Content Friday!

    Jamie_Gregory_0-1599222707365.jpeg

    Today we are featuring another long-time Qlik user (12 years to be exact) and Qlik Luminary:

    Radovan of EMARK!

    When asked what his favorite thing about Qlik is, he said:

    “Very fast answers (because in-memory) to complex business questions (because data is associated, not queried) on top of large amounts of data (because 10s of millions on data records can be handled on a notebook).”

    Using the REST connector and API’s, Radovan created a Qlik Sense app that monitors current performance and availability of his Qlik Sense environment*. Check out Radovan’s post on Qlik Community for more information as well the QVF file and steps to implement.

    Qlik Engine Health-Check Analysis

    engine_hc_overview.PNG

     

    Thank you for sharing what you created, @RadOresky! It's amazing to see what you can do with the power of Qlik.

    Do you want to be spotlighted in a future post? See our previous post, Introducing Featured Content Friday!, for more information on submitting your dashboards, workarounds, how-to’s, etc.

    Thank you for being a part of the Qlik Community and for choosing Qlik!

    Kind regards,

    Qlik Digital Support

    *The information in this document is provided as-is and to be used at own discretion. Depending on tool(s) used, customization(s), and/or other factors ongoing support may not be provided by Qlik Support.

    Show Less
  • Image Not found

    Qlik Product Innovation Blog

    QlikView Customers: The Value of Modernizing Your Analytics Through SaaS

    Globally, organizations are tackling digital transformation initiatives to make them more agile and competitive in their vertical segments. As a loyal QlikView customer, you are likely thinking about how to modernize your analytics to address new use cases and keep pace with user needs.We’re seeing a surge in adoption of SaaS across the software industry and our customer base, as everyone seeks competitive advantage. The worldwide public cloud se... Show More

    Globally, organizations are tackling digital transformation initiatives to make them more agile and competitive in their vertical segments. As a loyal QlikView customer, you are likely thinking about how to modernize your analytics to address new use cases and keep pace with user needs.

    We’re seeing a surge in adoption of SaaS across the software industry and our customer base, as everyone seeks competitive advantage. The worldwide public cloud services market is forecast to grow 6.3% in 2020 to total $257.9 billion, up from $242.7 billion in 2019, according to Gartner, Inc. Furthermore, 78% of respondents to a Harvard Business review survey, rated increased business agility as a top benefit of cloud computing. Various functions within organizations have specific reasons for adopting SaaS:  

    • CIOs and business leaders are embracing SaaS to enable agility and growth, viewing cloud a mechanism to quickly deploy new product or capabilities, driving speed to market and adaptability to changing business requirements and scenarios.
    • IT staff can spend more time on business-critical tasks, as opposed to routine maintenance and one-off end user reporting requests.
    • Organizations can realize dramatic cost savings on infrastructure, administration, and security.

     

    Adopting Qlik Sense Enterprise SaaS is the best choice to deploy quickly, reduce reliance on IT, and lower your total cost of BI ownership, but you may be wondering, “How do I adopt new technology cost effectively without impacting QlikView?”

    The Analytics Modernization Program allows you to leverage the investment you’ve already made in QlikView to add next-generation BI, Qlik Sense for your QlikView users. The program provides tremendous flexibility – whether you choose to begin using Qlik Sense to satisfy new BI use cases while maintaining legacy QlikView documents in parallel or migrate some QlikView apps to Qlik Sense to enhance or extend analytics you’ve already built. We understand, your organization’s BI strategy, security requirements, and industry standards are unique, so we’ve built program options; however, the most efficient way to modernize fast is through SaaS.

    One of the most valuable aspects of the Analytics Modernization Program SaaS option is the ability to host and consume QlikView and Qlik Sense side-by-side in the cloud via Qlik Sense. This gives you the following:

    • Easier for user with one place to go for all analytics
    • Reduced running costs with less infrastructure to buy and maintain
    • Simplified management with automated QlikView document uploads and unified user entitlements  

     

    Your QlikView capabilities deliver considerable value but cannot meet all the demands of modern BI.  Modernize the easy way with Qlik Sense Enterprise SaaS. The Analytics Modernization Program is the most cost-effective way to modernize at your own pace while retaining QlikView. For resources and discussion on QlikView to Qlik Sense, visit the community group. And, contact your Qlik account manager or partner for more information on the Analytics Modernization Program.

    Show Less
  • Image Not found

    Qlik Support Updates Blog

    Upcoming LEF Database Maintenance on Saturday, October 3rd, 2020

    Hello Qlik Users!We want to notify all customers that on Saturday, October 3rd, 2020 from 2 PM to 4 PM CET, there will be an interruption to services for approximately two hours. Qlik will be using this time to update the infrastructure and speed up our overall service.Alert: During this maintenance window, we kindly ask you not to perform any product upgrade or licensing procedures as our back-end servers will be inaccessible.Operations around t... Show More

    Hello Qlik Users!

    We want to notify all customers that on Saturday, October 3rd, 2020 from 2 PM to 4 PM CET, there will be an interruption to services for approximately two hours. Qlik will be using this time to update the infrastructure and speed up our overall service.

    Alert: During this maintenance window, we kindly ask you not to perform any product upgrade or licensing procedures as our back-end servers will be inaccessible.

    Operations around the digital purchase and upsell in any form should also be avoided.

    We expect the possible interruption in services to be minimal and all operations shall resume immediately after the maintenance window.

    Your understanding and patience is appreciated.

    Another blog will be posted the week of the migration to remind everyone. If you haven’t already, subscribe to the Qlik Support Updates Blog by clicking the green Subscribe button so you can be notified about important announcements like this one. Please give this post a like if you found it helpful and let us know if you have any questions or feedback in the comments below.

    Thank you for choosing Qlik!

    Kind Regards,

    Qlik Global Support

    Show Less
  • Image Not found

    Qlik Support Updates Blog

    New Qlik Support Programs menu in Qlik Community

    Hello Qlik Users!The Qlik Community team has been hard at work. You may recall that support related content was under the section called ‘Qlik Support Knowledge’. This section has recently been renamed to Qlik Support Programs.Under Qlik Support Programs, you’ll still find the Knowledge Base, this blog, Qlik Fix and Support Techspert Thursday. You will also find the addition of two of our newest programs – Talk to Experts Tuesday and Featured Con... Show More

    Hello Qlik Users!

    The Qlik Community team has been hard at work. You may recall that support related content was under the section called ‘Qlik Support Knowledge’. This section has recently been renamed to Qlik Support Programs.

    Jamie_Gregory_0-1600285222092.png

    Under Qlik Support Programs, you’ll still find the Knowledge Base, this blog, Qlik Fix and Support Techspert Thursday. You will also find the addition of two of our newest programs – Talk to Experts Tuesday and Featured Content Friday.

    Clicking on Qlik Support Programs will bring up the new landing page that features a search bar to search all of Community or the Knowledge Base, a carousel of the Support Programs (including a description of each), and a list of the most recent discussions within the section.  

    Jamie_Gregory_1-1600285222144.png

     

    We are still working on getting some of the content moved, so please bear with us, but what does everyone think of the new layout? Let us know in the comments below!

    Be sure to subscribe to the Qlik Support Updates Blog by clicking the green Subscribe button to stay up-to-date. Please give this post a like if you found it helpful!

    Thank you for choosing Qlik!

    Kind Regards,

    Qlik Global Support

    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 Product Innovation Blog

    Qlik is raising the bar once again with the September 2020 Product Release!

    The September 2020 release has arrived, and with it comes game-changing innovations in AI, taking our users to a whole new level. This includes new capabilities like conversational analytics, advanced analytics, and more.   You’ll also find other significant enhancements to our visual analytics capabilities, SaaS capacities, and user experience.   This release goes beyond analytics, as it also includes new advancements to our Data Integration pla... Show More

    The September 2020 release has arrived, and with it comes game-changing innovations in AI, taking our users to a whole new level. This includes new capabilities like conversational analytics, advanced analytics, and more.   You’ll also find other significant enhancements to our visual analytics capabilities, SaaS capacities, and user experience.   This release goes beyond analytics, as it also includes new advancements to our Data Integration platform with improved ETL performance and extended publishing options for cataloging. 

    Show Less
  • Image Not found

    Qlik Community Manager Blog

    Hispanic Heritage Month at Qlik!

    Last year, as a part of our Diversity and Inclusion program, Qlik for All, we introduced our Employee Resource Groups (ERGs). These groups allow Qlik to celebrate the global and individual uniqueness of our corporate citizens. In the spirit of our mission to value and cherish the importance of diversity (of experiences, backgrounds, life choices, cultures, genders, sexual orientation, religion, and our countries of origin), for the next four week... Show More

    Last year, as a part of our Diversity and Inclusion program, Qlik for All, we introduced our Employee Resource Groups (ERGs). These groups allow Qlik to celebrate the global and individual uniqueness of our corporate citizens. In the spirit of our mission to value and cherish the importance of diversity (of experiences, backgrounds, life choices, cultures, genders, sexual orientation, religion, and our countries of origin), for the next four weeks the spotlight will be on the Latinos Unidos ERG!

    As a co-lead of Latinos Unidos, I am happy to announce that from September 15th to October 15th we will be celebrating Hispanic Heritage Month at Qlik.  We have a variety of activities planned for our Qlikkies worldwide.

    As members of Latinos Unidos began to reflect on the central theme surrounding our month-long cultural-heritage celebration, the consensus was a focus on our multicultural diversity. The rich tapestry of our communities is comprised of a unique blend of American Indigenous, European, African, Middle Eastern and Asian influences. Additionally, we are looking forward to sharing information on the inroads we continue to make in supporting our LGBTQ+ communities.

    Join our celebration by downloading one of our Qlik Hispanic Heritage Month “Zoom” backgrounds. I love them and hope you will too. And, if you have any questions about the work we’re doing at Qlik For All, feel free to reach out to me. I would love to chat!

    zoom hhm photo.jpg

    Show Less
  • Image Not found

    Qlik Support Updates Blog

    Qlik Sense Hub and QMC with a custom SSL certificate

      If you’ve just installed Qlik Sense Enterprise, then this image probably looks familiar. Alternatively, Chrome might display The site's security certificate is not trusted, while Firefox may report This Connection is Untrusted.   By default, Qlik Sense uses a self-signed certificate to enable HTTPS access across both the Hub (https:// YourSenseServer/hub) and the Management Console (https://YourSenseServer/qmc). But self-signed certificates ca... Show More

    header error.png

     

    If you’ve just installed Qlik Sense Enterprise, then this image probably looks familiar. Alternatively, Chrome might display The site's security certificate is not trusted, while Firefox may report This Connection is Untrusted.

     

    By default, Qlik Sense uses a self-signed certificate to enable HTTPS access across both the Hub (https:// YourSenseServer/hub) and the Management Console (https://YourSenseServer/qmc). But self-signed certificates cannot be validated or trusted by web browsers and tend to prompt a warning message.

     

    That's alright though. All we need is the following:

    • An additional (signed) certificate.
    • A brief (5 minute) downtime of the Qlik Sense Proxy.
    • And, I suppose, this blog post for the instructions.

    So, let’s get started.

    What is the current certificate used for?

    During the initial install, the Qlik Sense Repository Service creates a set of certificates. Their purpose is to:

    • Secure Service Communication and Service Authentication.

    Qlik Sense uses certificates to authenticate its service across all nodes. See the Qlik Sense Online Help for details. In addition, other products (such as Qlik NPrinting) require these certificates to be establish a connection.

    • HTTPS enabled access for the Hub the QMC.

    Note:  We will not modify, replace, or remove the originally created certificates. Doing so will break service communication.

    What we’ll do instead is to add an additional one.

    Certificate options, or: What type of certificate is right for me?

    There are three possible types of certificates for us to use.

    • A certificate purchased from and signed by a trusted CA (Certificate Authority) such as VeriSign, Thawte, Geotrust, etc.
    • A certificate provided and signed by your own Enterprise CA (Certificate Authority).
    • And, of course, a self-signed one. Those can be created by any number of applications, such as Microsoft IIS, but is generally only recommended for test environments. More so, it has the potential side effect of teaching users to ignore browser warnings, which we do not want.

    Requirements, or: What to look out for when getting your cert.

    • The certificate itself must contain a private key
    • Has an up to date valid from / valid to date range
    • Is signed by a valid and OS or browser configured Certificate Authority

    When support gets questions, they are most often related to a certificate missing the private key. Always verify the certificate comes bundled with one when you install it.

    It’ll look like this:

    private key okay.png

    As far as formats and algorithms are concerned, the following are confirmed to work with Qlik Sense:

    • Certificates that are x509 version 3
    • Use signature algorithm sha256RSA
    • Use signature hash algorithm sha256

    Where to get a certificate and how to do a CSR?

    The Certificate Authority you chose will have instructions for this, and if you are looking to get a self-signed one or one from your corporation's CA, then a local administrator can provide the certificate to you.

     

    Either way, you are going to need to generate a Certificate Signing Request (CSR) to pass on to your CA. There are tools out there to get that done with, such as certreq from Microsoft (found here), and SSLhopper has a great article on that, which I often send to customers when they ask us about CSRs and how to do them.

    Once you obtain the certificate, we'll move on to installing it and activating it in Qlik Sense. This will be done in three quick steps:

    • Import
    • Get the Thumbprint
    • Provide Thumbprint to the Proxy

    Importing the Certificate

    As mentioned before, we are not replacing certificates. The already existing ones will not be deleted. Doing so would break service authentication between the individual Qlik Sense services and render the system… broken.

     

    Step 1:

    On the Qlik Sense node running the Qlik Sense Proxy, log on with the user running the Sense services. This is important since the certificate needs to be accessible for this account.

    Step 2:

    If the certificate was saved in the .pfx format, then all you need to do is double click the file. Follow the prompt to import the certificate into the Personal store.

    import.png

     

    Longer Step 2:

    If you want to import it manually or verify if it was correctly installed, then we'll need to do a little more work.

    • Launch the Microsoft Management Console (mmc.exe) on the Proxy node
    • In the MMC, go to File > Add / Remove Snap-in...
    • Select Certificates and click Add
    • Select Computer account, click Next, select Local computer and click Finish

      mmc.png

    • In the MMC, go to Certificates (Local Computer)/Personal
    • In the MMC, go to Actions > All Tasks > Import...
    • Browse to the certificate file provided to you from your CA
    • Follow the instructions on the screen to import the certificate, including the private key
    • Verify the new certificate has been imported into Certificates (Local Computer) > Personal > Certificates and that it contains a private key
    • Double-click the Certificate > Certification Path and confirm it shows "This certificate is OK"

      cert okay.png

     

    Getting the Thumbprint

    Well, since we are already in the MMC, let's open the freshly installed certificate again.

    • Switch to the Details tab and scroll down until you find Thumbprint
    • Mark the entire thing and copy it into, for example, Notepad.

     thumbprint get.png

     Configuring the Qlik Sense Proxy

    Almost done!

    • Open the Qlik Sense Management Console (QMC)
    • Go to Proxies
    • Double click the Proxy you want to use (or select and choose Edit)
    • Enable the Security options in the Properties panel on the right
    • Paste the certificate Thumbprint into the SSL browser certificate thumbprint text box.

    Click Apply.

     

     

    add thumbprint.png

    The Sense Proxy will now restart. During the restart, it will be using Windows API calls to correctly bind the new certificate to its SSL ports.

     

    Verification, or: How to prove the certificate was accepted.

    In the web browser:

    When opening the Qlik Sense Hub or QMC, the certificate will now be displayed in the browser. This may look different depending on the web browser, but in Google Chrome you can click the padlock to the left of the URL to verify what certificate is used.

    checkcert.png

    The information displayed needs to match the properties of the certificate you installed.

    checkcert2.png

    In the log files:

    If you’d rather see what the Qlik Sense Proxy service is doing, then you can directly check up on that, too.

    On the Proxy node, go to C:\ProgramData\Qlik\Sense\Log\Proxy\Trace and open the Security log file from just after the last start.

     

    It will now print a slightly different message than before:

     

    Security.Proxy.Qlik.Sense.Common.Security.Cryptography.LoggingDigester    DOMAIN\_service    Setting crypto key for log file secure signing: success

    Security.Proxy.Qlik.Sense.Common.Security.Cryptography.SecretsKey    DOMAIN\_service    retrieving symmetric key from cert: success   

    Security.Proxy.Qlik.Sense.Common.Security.Cryptography.CryptoKey    DOMAIN\_service    setting crypto key: success   

    Security.Proxy.Qlik.Sense.Communication.Security.CertSetup    'CN=localhost' (08C871933A58E072FED7AD65E2DB6D5AD3EAF9FA) as SSL certificate presented to browser, which is a 3rd party SSL certificate  

    And that's it!

    There isn't much more to it in a standard Qlik Sense Enterprise installation, but if you have more questions, then maybe a few of these articles can help:

    I applied my certificate and it seems to be using it correctly, but browsers are still saying the Common Name is Invalid?

    ERR_CERT_COMMON_NAME_INVALID when using 3rd party certificate (kb 000030388)

    Qlik Sense keeps reverting to the default and complains it can't find a valid ssl certificate with the thumbprint.

    Qlik Sense: Couldn't find a valid ssl certificate with thumbprint in Proxy logs, the third party certificate is not used correctly (kb 000029280)

    The certificate may not have a Private key or the service account does not have access to it.

    How to: Manage Certificate Private Key (kb 000037069)

    The Qlik Sense Service account doesn't have admin privileges and the certificate is not accepted.

    How to: Change the Qlik Sense Proxy certificate if the service account does not have local administrative permissions (kb 000037491)


    I hope that this was useful 😊 Stay tuned for an upcoming post where we’ll focus on QlikView and how to enable HTTPS for its AccessPoint, and don’t forget to subscribe to this blog for more content delivered by #QlikSupport. We’ll be watching for your comments and questions and we’ll to get back to you as soon as possible. Your feedback is always appreciated.  

     

    Show Less
  • Image Not found

    Qlik Support Updates Blog

    Reminder – NPrinting and QlikView 12.50 Compatibility

    Hello Qlik Users!Happy Friday! I hope everyone had a great week.This is a reminder to clients using Qlik NPrinting regarding the compatibility with QlikView 12.50.QlikView 12.50 is not support with any current version of Qlik NPrinting. Per Qlik Help:The following versions of QlikView are supported for connection with Qlik NPrinting. QlikView 11.20 SR15 or higherQlikView November 2017 (12.20) or higherQlikView November 2018 (12.30) SR1 or higherQ... Show More

    Hello Qlik Users!

    Happy Friday! I hope everyone had a great week.

    This is a reminder to clients using Qlik NPrinting regarding the compatibility with QlikView 12.50.

    QlikView 12.50 is not support with any current version of Qlik NPrinting.

    Per Qlik Help:

    The following versions of QlikView are supported for connection with Qlik NPrinting. 

    • QlikView 11.20 SR15 or higher
    • QlikView November 2017 (12.20) or higher
    • QlikView November 2018 (12.30) SR1 or higher
    • QlikView April 2019 (12.40) or higher

    Jamie_Gregory_1-1599853369148.png

    Currently, we do not have any information on which future version of NPrinting will be supported with QlikView 12.50 but we will pass along any information received from Product Management.

    In the meantime, please make sure to take the followings steps when upgrading NPrinting:

    • Check the System Requirements* in the Qlik NPrinting Help pages
    • Review the Release Notes* (available as a companion download for each major product release from theQlik Downloads site)
    • Back up your current environment before upgrading
    • Test the new version in a test or QA environment prior to upgrading the production environment

    *These links are for NPrinting September 2020.

    Carefully following the above will provide necessary information around compatibility between our product versions as well as any notable changes to the system. By thoroughly preparing for an upgrade with necessary backups, you are providing yourself with the ability to roll back should any issues come up during testing. Hopefully it’s not needed, but it’s always important to have a roll back plan should things go awry.

    If Qlik Sense or QlikView are being upgraded at the same time, please make sure to follow the above steps as well. System Requirements and backup instructions are found on the Qlik Help site, the Release Notes are found on the Qlik Downloads site and the Qlik Sense upgrade guide and QlikView upgrade guide provide information on upgrading the environments.

    Please let us know if you have any questions using the comments below. Be sure to subscribe to the Qlik Support Updates Blog by clicking the green Subscribe button to stay up-to-date with the latest releases. Also, give this post a ‘like’ if you found it useful.

    I hope everyone has a great weekend! Thank you for choosing Qlik!

    Kind regards,

    Qlik Digital Support

    Show Less
  • Image Not found

    Qlik Support Updates Blog

    Qlik September 2020 Release Now Available!

    Hello Qlik Users,Not only were a couple of patches released today for Qlik Patch Wednesday, but Qlik Sense September 2020 was also released!Qlik Sense September 2020 includes improvements on:Augmented IntelligenceSaaS Capacities and HubVisualizationsAPIs to include support for Qlik built open-source librariesData IntegrationFor a complete run down of the new features as well as videos summarizing and demoing the release, please see Qlik is raisin... Show More

    Hello Qlik Users,

    Not only were a couple of patches released today for Qlik Patch Wednesday, but Qlik Sense September 2020 was also released!

    Qlik Sense September 2020 includes improvements on:

    • Augmented Intelligence
    • SaaS Capacities and Hub
    • Visualizations
    • APIs to include support for Qlik built open-source libraries
    • Data Integration

    For a complete run down of the new features as well as videos summarizing and demoing the release, please see Qlik is raising the bar once again with the September 2020 Product Release! on the Qlik Product Innovation Blog. Based on what you see there, let me know what we can help expand upon from a technical perspective in the comments below or reach out to Digital@qlik.com with suggestions.

    Qlik Sense September 2020 is available now on the Qlik download site. Please follow best practices when upgrading – read the release notes, back up your Qlik Sense environment and test the new version in a QA environment. For more guidance on upgrades, see the Qlik Sense Upgrade guide. This guide was put together by the Qlik Digital Support team and offers step-by-step instructions, pictures and troubleshooting tips. 

    Be sure to subscribe to the Qlik Support Updates Blog by clicking the green Subscribe button to stay up-to-date with the latest releases. Please give this post a like if you found it helpful! Please let us know if you have any questions or feedback in the comments below.

    Thank you for choosing Qlik!

    Kind Regards,

    Qlik Global Support

    Show Less
  • Image Not found

    Qlik Gallery

    FitBit Dashboard

    This is an app I built to visualize the data from my FitBit. 
  • Image Not found

    Qlik Support Updates Blog

    ‘Error 400 Bad Request’ returned for URL with specific characters in Qlik Sense ...

    Hello Qlik Users! It has been reported that URLs with specific characters are returning Error 400 Bad Request with ticket authentication and windows authentication (a type of ticket authentication). This issue is affecting the Qlik Sense  April 2020 release starting with Patch 1 and the June 2020 track and is currently being investigated by R&D.Currently, two scenarios have been identified to show the issue:Using filters with the QRS API, for exa... Show More

    Hello Qlik Users!

     

    It has been reported that URLs with specific characters are returning Error 400 Bad Request with ticket authentication and windows authentication (a type of ticket authentication). This issue is affecting the Qlik Sense  April 2020 release starting with Patch 1 and the June 2020 track and is currently being investigated by R&D.

    Currently, two scenarios have been identified to show the issue:

    1. Using filters with the QRS API, for example:
      GET  /qrs/user?filter=(name+eq+%27user2%27)

      This includes the REST connector or calling the API directly.
    2. Using the Single Integration API with some spaces in the selection values, for example:

     <iframe src='https://qlikserver1.domain.local/single/?appid=b61ef493-2687-405a-a866-cca9108729d6&obj=71de3559-c190-40a3-8790-7d08fd321deb&opt=nointeraction&select=clearall&select=ACCT_CITY,Altamonte %20Springs&qlikticket=y.j_U14d4-OHyvVN' style='border:none;width:100%;height:100%;'></iframe>

                In this case, the %20 is provoking the error 400.

    There is a work around that can alleviate the 400 error. If the user first logs in to a URL that doe not have those URL parameters and obtains a valid session on the Qlik Proxy service, then they will be able to access the problematic URL.

    I will keep you all informed on the issues as R&D progresses through the investigation.

    For more information, please see Qlik Sense: URL with specific characters return Error 400 with ticket authentication in June 2020.

    Please let us know if you have any questions. If you found this blog useful, please give it a like! Also, subscribe to the Qlik Support Updates Blog by clicking the green Subscribe button.

    Kind regards,

    Qlik Digital Support

    Show Less
  • Image Not found

    Qlik Product Innovation Blog

    A Closer Look at Qlik DataTransfer: Seamless, secure access to on-premises data ...

    Earlier this week we announced our August release to cloud and the launch of Qlik DataTransfer, a new, lightweight utility that securely pushes on-premises data and local files to Qlik Sense SaaS. Qlik DataTransfer is included in both Qlik Sense Business and Qlik Sense Enterprise SaaS, so users can include on-premises data in their cloud analytics
  • Image Not found

    Qlik Support Updates Blog

    Join us for our next Talk to Experts Tuesday session - Migrating from QlikView t...

    Hello Qlik Users!Are you a long-time QlikView user that is trying out Qlik Sense? Are you currently enrolled in our Analytics Modernization Program? Did your company recently migrate from QlikView to Qlik Sense? Are they talking about making the switch?If you answered “yes” to any of these questions then join us for the next Talk to Experts Tuesday!Our next session is September 22nd, 2020 at 10am EDT. Our panelists will be live to take all your q... Show More

    Hello Qlik Users!

    Jamie_Gregory_0-1598909657101.jpeg

    Are you a long-time QlikView user that is trying out Qlik Sense? Are you currently enrolled in our Analytics Modernization Program? Did your company recently migrate from QlikView to Qlik Sense? Are they talking about making the switch?

    If you answered “yes” to any of these questions then join us for the next Talk to Experts Tuesday!

    Our next session is September 22nd, 2020 at 10am EDT. Our panelists will be live to take all your questions about…

    Migrating from QlikView to Qlik Sense!

    The panel for this session will include:

    • Andre Sostizzo – Technical Support Engineer
    • Gio Novello – Team Lead, Technical Support
    • Nicole Tamms – Senior Product Marketing Manager
    • Vinay Kapoor – Senior Director, Product Management

    Submit your questions down below and join the session on September 22nd to hear them answered LIVE by our amazing panel!

    For more Qlik events and webinars, please check out the Qlik Events page on Community.

    We can’t wait to see you next week!

    Kind regards,

    Qlik Digital Support

    Show Less
  • Image Not found

    Qlik Design Blog

    Mini Charts

    With the June 2020 release of Qlik Sense came many chart enhancements.  My favorite is the addition of mini charts to a table. In a table, a measure can be visualized via a mini chart as either bars, dots, sparklines, or positive/negative.This enhancement not only makes a table more appealing to look at, but it can easily point out changes and trends in the data. To add a mini chart to a table, follow these simple steps:Add a measure to the table... Show More

    With the June 2020 release of Qlik Sense came many chart enhancements.  My favorite is the addition of mini charts to a table. In a table, a measure can be visualized via a mini chart as either bars, dots, sparklines, or positive/negative.

    table.png

    This enhancement not only makes a table more appealing to look at, but it can easily point out changes and trends in the data. To add a mini chart to a table, follow these simple steps:

    1. Add a measure to the table. In the example above, Sum(Sales) is the measure.
    2. In the Properties window of the table, change Representation to Mini chart.
    3. Select the dimension to indicate what data to view. In the table above, Month was the selected dimension.
    4. Select the Type of mini chart to add (bars, dots, sparklines or positive/negative).

    That is it, the mini chart is added to the table. There are other options that can be adjusted to change the look and feel of the mini chart. In the Colors area, there is the option to select the color of the bar/dot/line as well as the option to select the color of the max value, min value, first value and last value. If showing a sparkline mini chart, you also have the option to show dots on the line for each data point of the selected dimension. The y-axis can also be adjusted for the mini chart. There is the option to use local or global so you can decide if the y-axis range is based on the specific row or all rows. There is also the choice to select auto, zero as baseline or zero as center for the y-axis. Read more about mini chart in Qlik Help.

    Mini charts are eye candy for your table. Dress up the measures in your table with mini charts to provide another layer of information in an easy to digest manner. Learn more about the Qlik Sense June 2020 release by checking the links below:

     

    Thanks,

    Jennell

    Show Less
  • Image Not found

    Qlik Support Updates Blog

    Talk to Experts Tuesday – Qlik Sense Enterprise on Windows FAQ &amp; Next Session De...

    Hello Qlik Users,Last Tuesday we had our Qlik Sense Enterprise on Windows Talk to Experts Tuesday session. We had an amazing panel:Mike Dickson, Senior Technical Support EngineerAndrew Delaney, Principle Technical Support EngineerThomas Hopp, Senior Product ManagerThat session was really fun and they did a fantastic job at answering user questions! You can check out the questions and their answers in the FAQ for the Qlik Sense Enterprise on Windo... Show More

    Hello Qlik Users,

    Last Tuesday we had our Qlik Sense Enterprise on Windows Talk to Experts Tuesday session. We had an amazing panel:

    • Mike Dickson, Senior Technical Support Engineer
    • Andrew Delaney, Principle Technical Support Engineer
    • Thomas Hopp, Senior Product Manager

    That session was really fun and they did a fantastic job at answering user questions! You can check out the questions and their answers in the FAQ for the Qlik Sense Enterprise on Windows Talk to Experts Tuesday session.

    The next session will focus on…

    Jamie_Gregory_0-1598909657101.jpeg

    Qlik NPrinting!

     

    The session will be held on September 8th at 10am EDT. Our awesome panel will include:

    • Eva Beasley, Senior Technical Support Engineer
    • Frank Savino, Principle Technical Support Engineer
    • Jonny Poole, Master Principle Enterprise Architect
    • Andrew Kruger, Product Manager

    So let us know what kind of questions you have about NPrinting below in the comments and join us on September 8th to hear your questions answered LIVE!

    For more Qlik events and webinars, please check out the Qlik Events page on Community.

    We can’t wait to see you next week!

    Kind regards,

    Qlik Digital Support

    Show Less
  • Image Not found

    Qlik Support Updates Blog

    Talk to Experts Tuesday – Qlik NPrinting FAQ

    Hello Qlik Users!This past Tuesday, we had a great Talk to Experts Tuesday session on Qlik NPrinting. We answered 35 of your questions LIVE on air! A huge THANK YOU to our amazing panel: Eva Beasley, Frank Savino, Jonny Poole and Andrew Kruger!We had a few questions that were still in the queue and those have been mostly answered in the FAQ (a few were actually Ideas so make sure you’re getting those added to the board).All of the questions have ... Show More

    Hello Qlik Users!

    This past Tuesday, we had a great Talk to Experts Tuesday session on Qlik NPrinting. We answered 35 of your questions LIVE on air! A huge THANK YOU to our amazing panel: Eva Beasley, Frank Savino, Jonny Poole and Andrew Kruger!

    We had a few questions that were still in the queue and those have been mostly answered in the FAQ (a few were actually Ideas so make sure you’re getting those added to the board).

    All of the questions have been compiled into an FAQ: Talk to Experts Tuesday – Qlik NPrinting FAQ

    Our new Community space for Talk to Experts Tuesday should be completed soon. All the recordings will be posted there, so I will be sure to share the new space when it is available.

    Stay tuned for more information on our next Talk to Experts Tuesday session! For more Qlik events and webinars, please check out the Qlik Events page on the Qlik Community.

    Thank you to everyone that attended the session and thank you for choosing Qlik!

    Kind regards,

    Qlik Digital Support

    Show Less