Qlik Community

Blogs

Hear directly from Qlik employees in our ten unique blogs.

Announcements
IMPORTANT security patches for GeoAnalytics Server available to download: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 

Qlik Design Blog

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

Qlik Product Innovation Blog

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

Support Updates Blog

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

Qlik Academic Program Blog

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

Community News

Updates about Qlik Community Platform as well as news and announcements.

Qlik Digest

The Qlik Digest is a monthly customer newsletter providing your monthly fix of all things Qlik, including product updates, events, and resources.

Qlik Education Blog

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

Qlik Technical Bulletin Blog

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

Japan Blog

Qlik Community blogs for our customers and partners in Japan.

Recent Blog Posts

  • qlik-community-blogs.jpg

    Qlik Design Blog

    Introducing DAR mashup template

     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. WhatJust that, a mashup template for dev-hub (aka dead simple drag and drop mashup creator) that ships with a bunch of cool features such as: Dev... Show More

     

    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.

     

    What

    Just that, a mashup template for dev-hub (aka dead simple drag and drop mashup creator) that ships with a bunch of cool features such as:

     

    • Dev-hub ready
    • Multi Page
    • KPI row built in
    • Prebuilt CSS color library
    • Cards with full screen toggle
    • Offcanvas filters pane
    • Help modal popup
    • Responsive design
    • Bootstrap built in
    • Custom fonts ready

     

    Why

    Because we’ve heard you asking for a more powerful and good-looking template that can constitute a solid framework to create your customized mashups.

     

    Who

    Anyone looking for a feature rich mashup template designed for use in the dev-hub.

     

    When

    Available today!

     

    Where

    You can grab the latest* version here GitHub - fkabinoff/qs-dev-hub-dashboard-template: Dashboard template for Qlik Sense dev hub

     

    *Please notice this is a live project, we will keep updating it frequently. Right now the project documentation (readme.md) is far from what we would like it to be.

    Show Less
  • Image Not found

    Qlik Academic Program Blog

    Using Qlik for the Birds and the Bees! A MUST WATCH!

    "It automatically updates where they have all been found which is just ridiculous and amazing because to do this with other software is very challenging to say the least. And its more than one click, that's for sure"  Educator Danny Najero, Green River College
  • Image Not found

    Support Updates Blog

    Techspert Talks - NPrinting and Qlik Sense On-Demand 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. Next Thursday, July 7th Qlik will host another Techspert Talks session and this time we are looking at NPrinting and Qlik Sense On-Demand Troubleshooting. But wait, what is it exactly?Techspert Talks is a free webinar held on a monthly basis, where you can hear directly from ... 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.

    Next Thursday, July 7th Qlik will host another Techspert Talks session and this time we are looking at NPrinting and Qlik Sense On-Demand 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 NPrinting On-Demand works
    • Configuration considerations
    • Troubleshooting common errors

     

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

    The webinar is hosted using ON24 in English and will last 30 minutes plus time for Q&A.
    Hope to see you there!!

    Techspert-Talks_Imagery_Community-590x310.jpg

    Show Less
  • qlik-community-blogs.jpg

    Community News

    Meet Emma! Our Newest Member to Qlik Community Team

    Dear Members, I am thrilled to introduce Emma Spickerman (@emmaspickerman)  who joins Global Customer Marketing as a Community Manager.  Emma will be focused on driving engagement across our newly launched Partner area within the Qlik Community. She will also contribute to other advocacy programs including the Partner Ambassador Program. If you are a Qlik Partner who is also participating in our Qlik Community, this is the person you want to kn... Show More

    Melissa_Potvin_0-1655911715234.png

    Dear Members,

    I am thrilled to introduce Emma Spickerman (@emmaspickerman)  who joins Global Customer Marketing as a Community Manager.  Emma will be focused on driving engagement across our newly launched Partner area within the Qlik Community. She will also contribute to other advocacy programs including the Partner Ambassador Program.

    If you are a Qlik Partner who is also participating in our Qlik Community, this is the person you want to know!  (and If you are not participating she will find you! 😄)  Emma will be working in collaboration with the Partner Organization to bring news and updates to our (partner) members while making sure no question is left behind.   

    Emma comes to us with a strong background in Digital Marketing, Consumer Marketing, Public Relations and Sales. She has worked with big brands such as TJX Companies, Inc, Zac Posen and Lexus. Her Bachelor’s degree is from Parsons School of Design in Strategic Design & Management and she also holds a Master’s in Integrated Marketing Communications from Georgetown University.

    Based in Massachusetts, Emma loves animals and will be adopting a Cavapoo puppy in the coming months, who she plans to name Beau. 

    Please help me give a very warm welcome to Emma as she starts her journey with Qlik and our Qlik Community!

    -Melissa
    Sr. Director, Qlik Communities
     
     
     
     
    Show Less
  • Image Not found

    Qlik Design Blog

    Qlik Management Console

    A brief overview of the Qlik Management Console and the different sections within. 
  • Image Not found

    Qlik Product Innovation Blog

    Simplify Enterprise Access Control and Sharing Analytics Content

    Qlik Cloud expands access control and flexible app sharing for more granular control over how app content is shared and accessed.
  • Image Not found

    Support Updates Blog

    Qlik GeoAnalytics Server Security Issues: Patches Available

    Security issues in Qlik GeoAnalytics Server have been identified and an update containing the fixes is required to prevent system vulnerability. All Qlik GeoAnalytics server versions prior to the service releases listed below are affected. 4 vulnerabilities have been identified, 3 being flagged as high risk due to the possibility of information disclosure impacting the server running GeoAnalytics. Additional details on vulnerabilities are shared ... Show More

    Security issues in Qlik GeoAnalytics Server have been identified and an update containing the fixes is required to prevent system vulnerability.

    All Qlik GeoAnalytics server versions prior to the service releases listed below are affected. 4 vulnerabilities have been identified, 3 being flagged as high risk due to the possibility of information disclosure impacting the server running GeoAnalytics.

    Additional details on vulnerabilities are shared here.

    Available Patches:

    • May 2022 SR1
    • February 2022 SR1
    • November 2021 SR4
    • May 2021 SR3
    • February 2021 SR3
    • November 2020 SR3
    • September 2020 SR3
    • June 2020 SR3

     

    To Download the latest service releases for GeoAnalytics, visit our Qlik Download’s site. You will need to be logged into Qlik Community with your Qlik ID, and filter by Value Added / GeoAnalytics Server / All releases with latest patch.

    Katie_Davis_0-1656004141491.png

     

    Show Less
  • Image Not found

    Qlik Design Blog

    Heatmaps with the updated Grid Chart

    How to create a heatmap with the new GridChart What is a heatmap chart? Heatmaps are two-dimensional representations of data that show magnitudes as colors. A color variation - may be based on hue or intensity - gives a clear indication to the reader of how the data measured is distributed or varies over space.The result should be a data piece that doesn't require a lot of explanation. Typically, warm high-contrast colors are used to represent hi... Show More

    How to create a heatmap with the new GridChart

     

    What is a heatmap chart?

     

    Heatmaps are two-dimensional representations of data that show magnitudes as colors. A color variation - may be based on hue or intensity - gives a clear indication to the reader of how the data measured is distributed or varies over space.

    The result should be a data piece that doesn't require a lot of explanation. Typically, warm high-contrast colors are used to represent high-value data points, while cool colors represent low-value data points in heatmaps.

     

    Most common Birth Dates (US)

    Qlik Sense Feb 22  (day of the month/month)Qlik Sense Feb 22  (day of the month/month)

     

     

    The chart above is an excellent use case for a heatmap, it is simple and straight to the point. Births are fairly evenly distributed throughout the year, with a slight bias towards the summer months. The average number of births drops significantly on some days, such as 4th July, 24th-25th December, and January 1st.

     

    There is also a very popular version control product out there that displays a punch-card-like activity chart like the one below that I think is an excellent implementation of a heatmap.

    Not my profileNot my profile

     

    With the February 22 release, the Grid Chart will be your first choice when it comes to heatmaps. In addition to all the features that one expects in a Grid Chart, there is now a shortcut that lets us create a heatmap just like that.

    ArturoMuoz_3-1645208702921.png

    ArturoMuoz_2-1645208573920.png

     

    Remember that this chart is especially useful if it is self-explanatory, so try to avoid complex combinations of dimensions. This chart is best suited to time-series-based dimensions.

    Enjoy it!

    Arturo

    Show Less
  • qlik-community-blogs.jpg

    Qlik Design Blog

    Evaluate() Function

    The Evaluate() function is a string function that takes one text string parameter.  If the string is a valid QlikView or Qlik Sense expression then the evaluated result of the expression will be returned.  If the string is not a valid expression, then Null is returned.  The Evaluate() function can only be used in the script and not in a chart expression.  Evaluate() will do the math for you in the script and return the result.  For example, if yo... Show More

    The Evaluate() function is a string function that takes one text string parameter.  If the string is a valid QlikView or Qlik Sense expression then the evaluated result of the expression will be returned.  If the string is not a valid expression, then Null is returned.  The Evaluate() function can only be used in the script and not in a chart expression.  Evaluate() will do the math for you in the script and return the result.  For example, if you are loading a field whose content is expressions like this:

    1.png

    Then you can view that data in two ways.  You can either view the actual expression or you can use Evaluate() and view the results.

    2.png

    3.png

    The Evaluate() function is also useful when you are loading a number from a text file or a text field in a database with more than 14 digits.  When that number is loaded into QlikView, it is interpreted as a string since it is too long (more than 14 digits).

    4.png

    Note that while using Evaluate() returns a number, it is only stored with 14 digit precision.  While you may be able to see more than 14 digits, this is just the formatting.  The internal mantissa is only 14 digits.

    Evaluate() can similarly be used with variables which can be helpful if you have a value that you would like to use multiple times in the script.

    5.png

    6.png

    So why use a Evaluate()?  At first it seemed unnecessary to me because the calculation would still be done without the Evaluate() function but then I realized that that is only the case when the values are numeric and not strings.  So Evaluate() is helpful when your expression is in a string format or when the expression is a number with more than 14 digits.  It allows a string expression to be evaluated and the result returned.  It is like a short-cut to solving the expression.  Try it out!

    Thanks,

    Jennell

    Show Less
  • Image Not found

    Qlik Product Innovation Blog

    Exciting updates to Qlik Compose are now available

    A new release of Qlik Data Integration is here, with exciting updates to Compose. These updates address our customers’ needs across data lake creation and improved warehouse automation. 
  • Image Not found

    Qlik Digest

    Customer Newsletter "Qlik Digest" - June 2022

    Welcome to the June Qlik Digest, providing your monthly fix of all things Qlik, including product updates, events and resources.Sharing is caring, so please let other Qlik users at your organization know that they can Subscribe to receive the monthly digest directly to their inbox!
  • qlik-community-blogs.jpg

    Qlik Design Blog

    Qlik Partner Engineering Team releases Qlik AWS Cost Explorer

    A new open-source tool to help organizations to manage AWS costs
  • qlik-community-blogs.jpg

    Qlik Design Blog

    Recipe for a Pareto Analysis

    “Which products contribute to the first 80% of our turnover?”
  • qlik-community-blogs.jpg

    Support Updates Blog

    Partner Portal Access

    I need to enter the partner portal to take a course. I have a business account. The problem is that I am not allowed to enter.   How do I fix that?  
  • qlik-community-blogs.jpg

    Qlik Academic Program Blog

    New Qualification Exams Available!

    Boost your resume by earning  a Qlik Sense Business Analyst or Data Architect certificate and digital badge!  
  • Image Not found

    Qlik Education Blog

    Qlik Sense Qualification Exams - 2022 Update

    Qlik Education is pleased to announce the Business Analyst and Data Architect Qualification Exams have been updated and are based on the SaaS editions* of Qlik Sense. However, you may also use Qlik Sense on Windows editions. 
  • qlik-community-blogs.jpg

    Qlik Academic Program Blog

    The Academic Program Wraps up 2016!

    2016 was an exciting and busy year for the Academic Program which grew by 247 new universities!, The program now expands 64 countries with a total of 709 universities!   Some of our new universities include Quinnipiac University in the United States, Cardiff Metropolitan University in the UK, Shailesh J Mehta School Of Management in India, and Universidade do Estado do Para in Brazil. This year the program also released its Data Analytics curricu... Show More

    Class of 2016.jpg2016 was an exciting and busy year for the Academic Program which grew by 247 new universities!, The program now expands 64 countries with a total of 709 universities!   Some of our new universities include Quinnipiac University in the United States, Cardiff Metropolitan University in the UK, Shailesh J Mehta School Of Management in India, and Universidade do Estado do Para in Brazil.

     

    This year the program also released its Data Analytics curriculum for professors and began offering  FREE training though the Qlik Continuous Classroom to professors and students who joined the program!

     

    The first course offered in the curriculum is called Data Visualization.  This course features lecture notes, course materials, and student exercises that professors can use to help them teach the history and theory behind Data Visualization.  The course is ad-hoc so professors can use some or all of the materials depending on their needs.  It also has pre-requisites from the Qlik Continuous Classroom so the materials blend seamlessly with our free training offering.

     

    Students and professors who are accepted into the program are also enrolled in a full-year subscription to free Qlik Sense and QlikView training through on OnDemand learning platform, the Qlik Continuous Classroom.  The QCC offers hundreds of videos, take away documents, quizzes and live instructor access!  Its an ideal way to learn Qlik at your own pace.  To access free training, apply to the program by visiting http://www.qlik.com/us/company/academic-program.

     

     

    Show Less
  • Image Not found

    Qlik Design Blog

    Get to know the Engine API with Qixplorer

    For those of us who want to go beyond the out-of-the-box capabilities of Qlik Sense and want to leverage the full potential of the platform to create complex visualizations or satisfy custom development needs, understanding the Engine API is fundamental to taking advantage of what Qlik Sense hides under the hood.The Qlik Engine API is a websocket protocol that uses JSON RPC 2.0 to communicate between the Qlik Associative Engine and clients. It wo... Show More

    For those of us who want to go beyond the out-of-the-box capabilities of Qlik Sense and want to leverage the full potential of the platform to create complex visualizations or satisfy custom development needs, understanding the Engine API is fundamental to taking advantage of what Qlik Sense hides under the hood.

    The Qlik Engine API is a websocket protocol that uses JSON RPC 2.0 to communicate between the Qlik Associative Engine and clients. It works independently of any platform and programming language as long as it supports WebSockets and can parse JSON.

    A great place to get your feet wet with trying out the Engine API is through Qixplorer (You might remember this as the Engine API Explorer on Qlik Managed). The tool that you can access at https://qixplorer.qlik.dev features a newly reimagined user interface and additional updates for a better experience.

    Untitled1.png

    Right off the bat, you can see that the format is divided into 4 main sections:

    • Left: This is where you configure your connection to the tenant, pick the app, and browse through methods made available for your selected object.
    • Middle: This is where you can see your requests and responses
    • Bottom: This area is where you can construct and modify your requests and execute them
    • Right: This is a neat feature that shows you inline documentation as you explore API methods

    Other settings include a Light/Dark mode toggle at the top left, as well as a Layout toggle that lets you switch between the Original Layout (side by side request and response sections) or, my favorite, the Chat Layout.

    How to use Qixplorer?

    The first thing you would need to create a new connection to your Qlik Cloud tenant is a Web Integration ID. You can grab that by going to your tenant’s Management Console, under Web, Create a new integration and add https://qixplorer.qlik.dev as an origin.

    Untitled2.png

    Once you have the generated ID in hand, create a new connection on Qixplorer as shown below:

    Untitled4.png

    The next step is to choose the app you want to connect to from the second dropdown.

    Once you select that, you will see that a first request and response have been made automatically. That’s the “OpenDoc” method, it is responsible for opening an app. More about it here.

    Notice that a few items are now highlighted on the Left panel that you can start using - including the Doc and Global classes that can be expanded to reveal all the methods you can execute. You can also use the pre-defined Macros to list sheets, dimensions etc...

    ⚠️Before we continue, keep in mind that when using Qixplorer, you are performing changes directly on your apps, so when executing API methods to update or delete within Qixplorer, it will affect the objects in your apps.

    Examples of using Qixplorer

     

    • Using Macros to list sheets in our app

    From the Macros dropdown, click on “ListSheets”.

    Notice that the Request section at the bottom has our generated JSON with the methods needed to list sheets.
    Click on Execute and view the JSON returned in the Response section.

    P.S: notice that two separate requests have been made by our Macro: CreateSessionObject and GetLayout.

    Untitled5.png

    • Using a method from Global

    Let’s create an App in our tenant directly from Qixplorer.

    First, select the “CreateApp” method from the Global dropdown.

    Notice that the right panel has been populated with the inline documentation for our method. This makes it really convenient to view the definition and parameters at a glance.

    Within the Request section that now contains the editable JSON, enter a name for the app we’re creating in the “qAppName” property.

    Our request and response look like this:

     

    {
      "handle": -1,
      "method": "CreateApp",
      "params": {
        "qLocale": "",
        "qLocalizedScriptMainSection": "",
        "qAppName": "test-qixplorer"
      }
    }

     

    Untitled (1).png

    You can check your tenant to view the newly created app:

    Untitled.png

     

    • Using a method from Doc and GenericObject

    Let’s retrieve the calculated data from a Table object in our app.

    First, we need to get the object. Under ”Doc”, scroll down to GetObject and change the “qId” property to our Table's object id.

    Now that we got the object, you can go to ”GenericObject”, then “Select Object” and click on table.

    Untitled (3).png

    Next, scroll down to the “GetHyperCubeData” method under “GenericObject” and modify the JSON as follows to set the qHeight (number of rows to retrieve) and qWidth (number of columns)

     

    {
      "handle": 2,
      "method": "GetHyperCubeData",
      "params": {
        "qPages": [
          {
            "qHeight": 1000,
            "qWidth": 5,
            "qTop": 0,
            "qLeft": 0
          }
        ],
        "qPath": "/qHyperCubeDef"
      }
    }

     

    Click on execute and examine the response:

    hypercube-anim.gif

    The Engine API is without a doubt very powerful as it exposes methods that can be used to tap directly into the associative engine and manipulate complex data structures. Having a tool like Qixplorer is a great way to try out the API and learn more about all the methods available in a single place.

    Let me know in the comments how you use Qixplorer on you end!

    Show Less
  • Image Not found

    Qlik Product Innovation Blog

    Check out Improved Navigation, New Connectors, Blocks, and Templates in the Late...

    A new release of Qlik Application Automation is here, with improved navigation, the ability to zoom in and out of automations, and several new connectors, blocks, and templates. Let’s first dive into the new connectors and blocks. Then, look for more information on the individual links for “Getting Started” articles.
  • qlik-community-blogs.jpg

    Qlik Academic Program Blog

    The Academic Program visits the Politecnico di Torino

    At the end of May, the Qlik Academic Program visited the  Politecnico di Torino to deliver one of our Academic Program workshops.