Skip to main content

Blogs

Hear directly from Qlik employees in our ten unique blogs.

Announcements
Welcome to Qlik Community! Check out our new navigation! FIND OUT MORE
cancel
Showing results for 
Search instead for 
Did you mean: 

Design

The Design blog is all about product and Qlik solutions, such as scripting, data modeling, visual design, extensions, best practices, and more!

Product Innovation

By reading the Product Innovation blog, you will learn about what's new across all of the products in our growing Qlik product portfolio.

Support Updates

The Support Updates blog delivers important and useful Qlik Support information about end-of-product support, new service releases, and general support topics.

Qlik Academic Program

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

Community News

Hear it from your Community Managers! The Community News blog provides updates about the Qlik Community Platform and other news and important announcements.

Qlik Digest

The Qlik Digest is your essential monthly low-down of the need-to-know product updates, events, and resources from Qlik.

Qlik Education

The Qlik Education blog provides information about the latest updates of our courses and programs with the Qlik Education team.

Technical Bulletin

The Technical Bulletin provides nformation on all new product releases, connectors, beta programs, and technical product information.

Japan

Qlik Community blogs for our customers and partners in Japan.

Recent Blog Posts

  • Image Not found

    Product Innovation

    Qlik Sense Mobile SaaS - September Release

    September Mobile Enhancements: Now with a simplified setup process for Qlik Sense Mobile along with full landscape mode on handheld devices, you can drive more and better insights on the go.
  • Image Not found

    Design

    Qlik AutoML Tips - Tip #2 - The data you should be using - (must contain outcome...

    Can't see the video? Watch on the Qlik video site here.Missed Tip #1? - View it here.Tip #2  covers the data you should be using with Qlik AutoML. When creating new ML experiments with Qlik AutoML – you are prompted to select data from the Qlik Catalog. Though you will see data that has been registered in the catalog, it is important to note that not just any data can be used with Qlik AutoML. Historical data ( data you normally use for analytics... Show More

    Can't see the video? Watch on the Qlik video site here.

    Missed Tip #1? - View it here.

    Tip #2  covers the data you should be using with Qlik AutoML. When creating new ML experiments with Qlik AutoML – you are prompted to select data from the Qlik Catalog. Though you will see data that has been registered in the catalog, it is important to note that not just any data can be used with Qlik AutoML. Historical data ( data you normally use for analytics and reporting with dimensions, measures, time periods, etc. ) is generally not suitable for machine learning. Why? Data you’re accustomed to using in analytics apps is captured all at the same point in time (current, end of day, end of month, etc.). With machine learning and predictive analytics, the dataset needs to contain an outcome we care about and a set of attributes we call features (typically your dimension fields / values)  that existed prior to that outcome. That way, a machine learning model can learn the patterns that led to that outcome and therefore identify them in advance when we apply the model to live or current data. That being said – you must select data from the catalog that has been prepared with the main ingredients needed to train machine learning models. 

    Stay tuned for Tip #3 where I will briefly cover architecting the data set and the needed ingredients.

    7-6-2022 9-30-39 AM.jpg

     

    Qlik AutoML Helpful Resources:

    Show Less
  • Image Not found

    Design

    Qlik Sense Chart Property - Data Handling

    Many have seen this property in the Add-ons tab of the chart properties, but do they know how to use it?
  • qlik-community-blogs.jpg

    Qlik Gallery

    Climate Risk Overview

    Climate Risk OverviewVan OordThe Climate Risk Overview, a global tool powered by Van Oord where open source data has been mapped onto 10km segments of the world’s coastlines. The overview brings together key parameters such as populations, low lying land and expected sea level rise to anticipate the hazard of flooding for all coastlines and societies around the world. Use the filters on different criteria to find your own selection of hotspots b... Show More
    Show Less
  • Image Not found

    Qlik Academic Program

    A look at our EMEA Survey Results

    Thank you very much to all the students and educators who take the time to respond to our Academic Program Survey. Your feedback is invaluable and helps us to understand the strengths of our program and the areas in which we can improve. We are very proud that for the most part we receive an overwhelmingly positive response, here are some of the recent survey results we have had in the EMEA region throughout 2022.
  • Image Not found

    Support Updates

    Techspert Talks - Qlik Replicate Troubleshooting

    Hi everyone, Want to stay a step ahead of important Qlik support issues? Then sign up for our monthly webinar series where you can get first-hand insights from Qlik experts. The Techspert Talks session from September looked at Qlik Replicate Troubleshooting. But wait, what is it exactly?Techspert Talks is a free webinar held on a monthly basis, where you can hear directly from Qlik Techsperts on topics that are relevant to Customers and Partners ... Show More

    Hi everyone,

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

    The Techspert Talks session from September looked at Qlik Replicate Troubleshooting.

    But wait, what is it exactly?
    Techspert Talks is a free webinar held on a monthly basis, where you can hear directly from Qlik Techsperts on topics that are relevant to Customers and Partners today.

    In this session we will cover:

    • How Replicate Works
    • Understanding Log Files
    • Quickly Resolving Issues

     

    Click on this link to see the presentation.

    Techspert-Talks_Imagery_Community-590x310.jpg

    Show Less
  • Image Not found

    Product Innovation

    Qlik Replicate and Qlik Catalog August 2022 Client Managed Release Highlights

    Summer is the time of year when many of us take a break from work to relax and rejuvenate.  We hope all of you have had a chance to take some time off.  But summer hasn’t stopped Qlik from continuing to add enhancements to our Qlik Data Integration portfolio.    We want to highlight some of the cool things now available in the Qlik Replicate and Qlik Catalog August 2022 Client Managed Releases.   
  • qlik-community-blogs.jpg

    Design

    Canonical Date

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

     

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

     

    Base model.png

     

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

     

    Logic 1.png

     

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

     

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

     

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

     

    Your data model will then look like this:

     

    Model with spec calendars.png

     

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

     

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

     

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

     

    Full model.png

     

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

     

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

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

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

     

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

     

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

     

    Bar chart.png

     

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

     

    Summary:

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

     

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

     

    HIC

    Show Less
  • Image Not found

    Support Updates

    Retirement of legacy Attunity products on January 31, 2022

    Hello Qlik Users! Based upon alignment to the strategy of the wider Qlik portfolio, Qlik has made the difficult decision to retire:Attunity ConnectRepliweb R1Repliweb MFTRepliweb FastcopyRepliweb RDMVisibilityWe will continue to support these products until the retirement date – January 31, 2022. You can continue to renew your support agreements, through the retirement date. However, renewal support agreements will not go beyond January 31, 2022,... Show More

    Hello Qlik Users!

    Qlik-Logo_TAG_Centered_RGB.png

     Based upon alignment to the strategy of the wider Qlik portfolio, Qlik has made the difficult decision to retire:

    • Attunity Connect
    • Repliweb R1
    • Repliweb MFT
    • Repliweb Fastcopy
    • Repliweb RDM
    • Visibility

    We will continue to support these products until the retirement date – January 31, 2022. You can continue to renew your support agreements, through the retirement date. However, renewal support agreements will not go beyond January 31, 2022, even if this is shorter than your normal support renewal period. Existing support agreements that expire after the retirement date will be honored; these agreements are not eligible for renewal.  

    Support for any additionally purchased licenses will not extend past January 31, 2022. 

    Please contact your Qlik sales representative if you have any questions or let us know in the comments below and we can route them to the appropriate people if necessary. 

    Please subscribe to the Qlik Support Updates Blog by clicking the green ‘Subscribe’ button if you haven’t already. Let us know that you read this post by giving it a like!

    Kind regards,

    Qlik Global Support

    Show Less
  • Image Not found

    Design

    Example Questions in Insight Advisor

    Insight Advisor helps a user explore their data, generate visualizations, and analyze their data through Qlik Sense features such as Insight Advisor Search, Insight Advisor Analysis Types, and Insight Advisor Chat. In this blog, I am going to review how example questions can be added to Insight Advisor to help users when they start their analysis. Example questions are added at the app level and a developer can add example questions to any of the... Show More

    Insight Advisor helps a user explore their data, generate visualizations, and analyze their data through Qlik Sense features such as Insight Advisor Search, Insight Advisor Analysis Types, and Insight Advisor Chat. In this blog, I am going to review how example questions can be added to Insight Advisor to help users when they start their analysis. Example questions are added at the app level and a developer can add example questions to any of their apps. When using Insight Advisor Search, users will see the example questions when they click in the “Ask Insight Advisor” search box (see image below). From there, users can select one of the example questions or enter a question of their own.

    example questions.png

    example questions.png

    When using Insight Advisor Chat, users will see example questions from all apps that have example questions provided they have access to those apps. Below is an example from Insight Advisor Chat. Notice that the “Show example questions” is toggled on.  This needs to be on for the example questions to be presented.

    chat - plant operations.pngWhen Insight Advisor Chat is opened, the example questions are presented. If a user would like to see the example questions again later in a chat thread, all they need to do is click on the Questions button to view them. As with Insight Advisor Search, a user can select one of the example questions or enter a question of their own. If you find that the example questions are not showing up in Insight Advisor Chat, be sure to check the app options and make sure “Insight Advisor in hub” is toggled on. This setting can be accessed from within an app by clicking on the app name in the navigation bar and then selecting the app options icon.

    app options2.png

     

    app capabilities.png

     

    Now, let’s take a look at how to add example questions to an app. From within an app, click on Prepare and then select Vocabulary.

    vocabulary.png

    Click on the Example questions tab and click on the + Add question button. In the Add Example Question pop-up window, select the language for the question and then enter the question. Once you hit enter, a preview of a generated visualization will be displayed. If you would like to add an example question in multiple languages, click the + Add language button, select the language, and enter the example question in the respective language. Once you are done adding the question, in their respective languages, click the Add button to add the example question.

    add question2.pngRepeat this process until all example questions have been added to the app. Here is what it will look like once all the example questions have been added.

    list of example questions.png

    Example questions for Insight Advisor allow developers to provide hints and help when using Insight Advisor. They can be used to get the user started with using Insight Advisor and guide them on how to ask their questions about an app. Check out Michael Tarallo's SaaS in 60 video and if you need more information, check out Qlik Help.  If you are interested in Insight Advisor Analysis Types, check out my blog.

    Thanks,

    Jennell 

     

    Show Less
  • Image Not found

    Support Updates

    Qlik Sense on Windows: Node.Js Vulnerability for versions prior to Nov. 2021

    A node.js security update released new versions of14.x, 16.x, and 18.x to address three medium and two high severity issues.   Impact  Client-managed Qlik Sense Enterprise on Windows release versions prior to November 2021 are affected.  Recommendation  It is recommended affected users upgrade to the following releases:  November 2021 latest patch  February 2022 latest patch  May 2022 latest patch  August 2022 IR   To download the latest patch,... Show More

    A node.js security update released new versions of14.x, 16.x, and 18.x to address three medium and two high severity issues.  

    Impact 

    Client-managed Qlik Sense Enterprise on Windows release versions prior to November 2021 are affected. 

    Recommendation 

    It is recommended affected users upgrade to the following releases: 

    • November 2021 latest patch 
    • February 2022 latest patch 
    • May 2022 latest patch 
    • August 2022 IR  

    To download the latest patch, log into Qlik Community with your Qlik ID, and navigate to our downloads page.  Filter by Data Analytics, Qlik Sense Enterprise on Windows, and find the latest version to upgrade to.  

    Show Less
  • Image Not found

    Support Updates

    Making the Move from QlikView to Qlik Sense? Join our Q&amp;A with Qlik Webinar July...

    Whether you're thinking about changing platforms or are in the middle of your migration, join Support's live office hours to answer your questions in real time and get more insight on our data analytics offerings.
  • Image Not found

    Design

    Qlik AutoML Tips - Tip #1 - Know the outcomes you wish to predict

    Can't see the video? Watch on the Qlik video site here.Tip #1 – covers knowing the outcomes you wish to predict, as well as the questions you want to ask based off your current findings from your historical analytical data. Let’s say when analyzing your sales and order data you have noticed a number of orders that have been cancelled. Further investigation shows those cancelled orders have gone unfulfilled for a specific period of time since bein... Show More

    Can't see the video? Watch on the Qlik video site here.

    Tip #1 – covers knowing the outcomes you wish to predict, as well as the questions you want to ask based off your current findings from your historical analytical data. Let’s say when analyzing your sales and order data you have noticed a number of orders that have been cancelled. Further investigation shows those cancelled orders have gone unfulfilled for a specific period of time since being placed. This may be due to the sheer volume of orders and the number employees you have available to process them. You may want to get a better handle on understanding the pattern of cancellation and create some predictions to answer questions like:

     

    • Will a customer cancel their order before it is fulfilled?  - Or -
    • How many days pass before a customer cancels their unfulfilled order?

     

    Answering these questions will enable you to be proactive with certain customer orders and possibly direct your employees to give those order priority and fulfill them sooner to avoid cancellation. Now that we have our predictive question, we need to architect a data set that will support it so Qlik AutoML can use it effectively.  Stay tuned for Tip #2 where I will cover the data you should be using to train machine learning models with Qlik AutoML.

    See Tip #2 Available Now

    Qlik AutoML Helpful Resources:

    Show Less
  • Image Not found

    Support Updates

    The Season of Qlik Replicate!

    Check out our August Client-Managed Service Releases and join our TWO Support webinars this September!
  • Image Not found

    Support Updates

    Updates to Qlik Downloads Page

    Products previously categorized under "Value Add" have been moved under our Data Analytics and Data Integration filters.
  • Image Not found
  • Image Not found
  • qlik-community-blogs.jpg

    Design

    How to create a Butterfly (Tornado) Chart in Qlik Sense

    My previous post versed about what I think it is a very interesting use case of Set analysis element function P() to create dynamic sets and how to operate with those sets to solve really complex analysis scenarios in an easy and elegant way. In the comments section of that post, I got a couple of questions regarding one of the charts we used in our web app, the so-called Tornado Chart. This post goes to answer that question by showing how to cre... Show More

    My previous post versed about what I think it is a very interesting use case of Set analysis element function P() to create dynamic sets and how to operate with those sets to solve really complex analysis scenarios in an easy and elegant way.

     

    In the comments section of that post, I got a couple of questions regarding one of the charts we used in our web app, the so-called Tornado Chart. This post goes to answer that question by showing how to create a Tornado/Butterfly Chart.

     

    Step by step guide:

     

    Note: For the following example I got a sample data containing Population by Age data from the US census. It has 3 columns, Age Range, Male population and Female population.

     

    1. Drag and drop a bar chart to your sheet.
    2. Add a dimension.  I’ll add Age Range to mine.
    3. Add two expressions. I need one expression to display female’s population and a second one for males.

      At this point, my chart looks like this:

      5.png

    4. Next, we will adjust the bar chart sorting and appearance.

      Sort the chart according to your data. For this data set my best option is to sort Age Range using load order, to do so, move Age Range to the top and then uncheck all the sorting options to sort on load order.
      In the Appearance section of the chart property panel, switch Presentation to Horizontal and Stacked and set Value labels to Auto.

      6.png
    5. Now we need to figure out how to “move the y axis to the center of the chart". To do so I’ll transform the data to make Female population negative by changing my expression to: Sum(FemalePopulation)*-1

      7.png

    6. My chart looks almost right but there’s still a detail that doesn't fits well in the picture above. Note that the value labels for Female Population are displayed as negative numbers. While technically correct, it doesn't work for this chart, I need it to be displayed as positive vales as well.

    As a general note remember we can set up the format for positive and negative values for any expression. Format argument in the Num function can take 2 parameters, first one indicates how to format the number if it is >0 and the second piece if number <0.

    =num(sum(x), 'postivenumberFormat;negativenumberFormat')

     

    As I want negative and positive number to look exactly the same I could use the following format arguments:

     

    num(sum(FemalePopulation)*-1,’#,##0;#,##0’)

     

    8.png

     

     

    Note: Please be aware of some potential issues when exporting the chart as data since the resulting file could contain negative values.

     

    Enjoy it.

    Show Less
  • Image Not found

    Design

    Qlik AutoML on Qlik Cloud now GA! Things You Should Know Before Getting Started

    Soon we will introduce a new machine learning and predictive analytics capability to Qlik Cloud, Qlik AutoML. If you are interested in learning more, take a look at this quick video before getting started. 
  • Image Not found

    Support Updates

    Direct Access via Qlik's Data Gateway Available Now!

    Qlik Data Gateway - Direct Access provides an encrypted connection to Qlik Cloud , allowing Qlik Sense SaaS applications to securely access and analyze data that resides behind your organization's firewall, without compromising your enterprises' network security. No matter if your protected data is on-premises or in a virtual private cloud, Qlik Data Gateway - Direct Access provides a sure way to analyze that data in Qlik Sense SaaS safely and se... Show More

    Qlik Data Gateway - Direct Access provides an encrypted connection to Qlik Cloud , allowing Qlik Sense SaaS applications to securely access and analyze data that resides behind your organization's firewall, without compromising your enterprises' network security.

    No matter if your protected data is on-premises or in a virtual private cloud, Qlik Data Gateway - Direct Access provides a sure way to analyze that data in Qlik Sense SaaS safely and securely. 

    Key Resources

    • Check out our Overview and Demo video here!
    • Try Direct Access today with our demo app.
    • To set up your Data Gateway, follow these deployment instructions.
    • For a tour, please check out the Connect and Learn pane on the bottom right of your Qlik Cloud hub
    • Detailed capabilities shared on our Product Innovation Blog!

     

    Qlik Cloud offers enterprise-grade solutions for data ingestion into Qlik Sense SaaS with respect to governed access of internal data landscape(s) of an organization - no matter where the data resides.

    Happy data exploring!

    Qlik Global Support

    Show Less