Qlik Community

Blogs

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

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 Support Updates Blog

    Issues with QlikView 12.50 and NPrinting

    Hello Qlik Users!I hope you are all doing well!There are a couple of defects in QlikView 12.50 that are affecting NPrinting:QV-20513: Date format turns into number from "dd/mm/yy" when creating a report on NPrintingQV-20560: QlikView 12.50 exporting to excel turns number fields into text Due to the nature of these defects, we are requesting any NPrinting customers to refrain from upgrading to QlikView 12.50. The fixes have been identified and res... Show More

    Hello Qlik Users!

    I hope you are all doing well!

    There are a couple of defects in QlikView 12.50 that are affecting NPrinting:

    • QV-20513: Date format turns into number from "dd/mm/yy" when creating a report on NPrinting
    • QV-20560: QlikView 12.50 exporting to excel turns number fields into text

     

    Due to the nature of these defects, we are requesting any NPrinting customers to refrain from upgrading to QlikView 12.50. The fixes have been identified and resolved by R&D but we are waiting for the release of the patch. I do not have a date yet as to when these fixes will be released but will let everyone know as soon as I have more information.

    We apologize for any inconvenience this issue causes.

    Please subscribe to the Qlik Support Updates Blog by clicking the green Subscribe button and give this post a like if you found it helpful. If you have any questions, please let us know in the comments.

    Thank you for choosing Qlik!

    Kind regards,

    Qlik Global Support

    Show Less
  • qlik-community-blogs.jpg

    Qlik Design Blog

    Buckets

    Often when creating a QlikView application, you want to add some grouping of a number, and then use this as a dimension in a chart or as a field where you make selections.
  • Image Not found

    Qlik Academic Program Blog

    Catch the best of QlikWorld On-Demand

    Last week our annual Qlik conference took place online with record breaking participation from our customers and partners. But in case you missed it, fear not. You can now catch all of the great content on demand with full access to the key note speeches and over 110 different breakout sessions.Of course this is also a great chance to see the presentations from our Academic Program Datathon. You will be able to see the winners of each climate cha... Show More

    Last week our annual Qlik conference took place online with record breaking participation from our customers and partners. But in case you missed it, fear not. You can now catch all of the great content on demand with full access to the key note speeches and over 110 different breakout sessions.

    Of course this is also a great chance to see the presentations from our Academic Program Datathon. You will be able to see the winners of each climate change related challenge presenting their solutions in Qlik Sense. The standard of submissions was very high, so this is a great opportunity to see the types of dashboards that students can create in Qlik Sense after just a small amount of time using the software.

    There are also a whole host of sessions available giving you all of the latest updates and innovations from Qlik as well as Data Literacy talks. These include sessions from one of our Academic Program Professor Angelika Kildas, and our Chief Learning Officer Kevin Hanegan who gives “An Introduction to Data Informed Decision Making.” Finally this is the perfect opportunity to learn how our customers across a whole host of industries are innovating and driving business success using the power of Qlik.

    Whether you are brand new to Qlik or a seasoned pro, QlikWorld on demand is am excellent way to dive into all of the features of our software and services, and to see how we benefit organisations all over the world. To access all of the on-demand content please visit: https://go.qlik.com/UK-2020-QlikWorld-Online-home.html.

    In the Data Discovery Zone at the “Data Literacy as a Service” booth you can pick up information on our Academic Program offering free software training and qualifications to University students and Academics globally. If you are not already a member sign up today: qlik.com/academicprogram.

    Show Less
  • Image Not found

    Qlik Support Updates Blog

    Qlik Patch Wednesday - New releases available

    Hello Qlik Users,It's July 1st and Qlik Patch Wednesday!There are three new Qlik Sense patches available on the Qlik download site:Qlik Sense Patch November 2019 Patch 13Release NotesApril 2020 Patch 4Release NotesJune 2020 Patch 2Release Notes There is one new Qlik Catalog patch available on the Qlik download site:Qlik Catalog Patch June 2020 SR 1Release Notes For more information on the Qlik Catalog patch, please see Qlik Catalog June 2020 SR 1... Show More

    Hello Qlik Users,

    It's July 1st and Qlik Patch Wednesday!

    There are three new Qlik Sense patches available on the Qlik download site:

    Qlik Sense Patch

     

    November 2019 Patch 13

    Release Notes

    April 2020 Patch 4

    Release Notes

    June 2020 Patch 2

    Release Notes

     

    There is one new Qlik Catalog patch available on the Qlik download site:

    Qlik Catalog Patch

     

    June 2020 SR 1

    Release Notes

     

    For more information on the Qlik Catalog patch, please see Qlik Catalog June 2020 SR 1 is now available.

    Each Qlik Sense patch has a few fixes so please follow best practices when upgrading by backing up your Qlik Sense environment and testing the patch in a QA environment first. For more guidance on upgrade, 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! Also, please let us know if you have any questions or leave your feedback in the comments.

    Thank you for choosing Qlik!

    Kind Regards,

    Qlik Global Support

    Show Less
  • qlik-community-blogs.jpg

    Qlik Design Blog

    REST connector: Using WITH CONNECTION

    See what WITH CONNECTION can do for you when working with REST data sources
  • Image Not found

    Qlik Product Innovation Blog

    On the next Do More with Qlik - for Beginners and Beyond

    Do you think you know the Associative Difference? Think again. Join me on July 9th to hear my story of my first run in with Qlik's Associative Difference and then stick around to view practical examples of it in action. Combine this with the power of the cognitive engine using our Associative Insights and you have more than just a data visualization tool. You have a complete data visualization platform that helps you find the unexpected.Hope to s... Show More

    Do you think you know the Associative Difference? Think again. Join me on July 9th to hear my story of my first run in with Qlik's Associative Difference and then stick around to view practical examples of it in action. Combine this with the power of the cognitive engine using our Associative Insights and you have more than just a data visualization tool. You have a complete data visualization platform that helps you find the unexpected.

    Hope to see you there.

    Register here: https://go.qlik.com/Do-More-with-Qlik-Webinar-Series.html

    Show Less
  • qlik-community-blogs.jpg

    Qlik Support Updates Blog

    Qlik April 2020 releases available now!

    Hello Qlik Users!We are pleased to announce the new April 2020 releases for Qlik Sense and Qlik NPrinting!Qlik Sense April 2020 includes a new organization chart, pivot table improvements, several enhancements to the map chart, and many more features and improvements! Check out the Help site for more information on the features. For resolved issues, please see the release notes.The April release also brings many of the same features to the Cloud ... Show More

    Hello Qlik Users!

    We are pleased to announce the new April 2020 releases for Qlik Sense and Qlik NPrinting!

    Qlik Sense April 2020 includes a new organization chart, pivot table improvements, several enhancements to the map chart, and many more features and improvements! Check out the Help site for more information on the features. For resolved issues, please see the release notes.

    The April release also brings many of the same features to the Cloud editions of Qlik Sense. For more information on the specific changes, please see the change log.

    In Qlik NPrinting April 2020, you’ll have the ability to create dynamic recipient email distributions! Support for Windows 2019 has been added as well. Please review the release notes for more information on the new features and fixes.

    The April 2020 releases are now available on the Qlik download site. As with all software, please follow best practices when upgrading by backing up your Qlik Sense or Qlik NPrinting environment and testing the patch in a QA environment first. For Qlik Sense upgrades, please check out the Qlik Sense Upgrade Guide for helpful tips.

    Be sure to subscribe to the Qlik Support Blog by clicking the green Subscribe button to stay up-to-date with the latest releases.

    QlikView April 2020 will be available a little later this month so be sure to check back for that announcement!

    Thank you for choosing Qlik!

    Kind Regards,

    Qlik Global Support

    Show Less
  • Image Not found

    Qlik Product Innovation Blog

    Let’s Make New Charts with Qlik Sense

    My boss asked me recently how many charts Qlik Sense supports, which led me to thinking: What counts as a chart? Should I just count the number of charts in the asset panel and the visualization bundle? That’s easy: 28, but there are many more...
  • Image Not found

    Qlik Design Blog

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

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


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

     

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

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

    Here's what you need to know to prepare:

    Qlik Sense Cloud Business Customers on Annual Subscriptions

    You will receive two emails this week guiding you to set up Qlik Sense Business. The first email will explain the product change and how to set up Qlik Sense Business.  The second email will include a unique link to set up Qlik Sense Business.  Once you complete the set up process, Qlik Sense Business will be automatically configured to the same number of users and renewal date as your existing Qlik Sense Cloud Business subscription.  You can then begin moving content and adding users to complete the migration. 

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

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

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

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

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

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

     

     

    Show Less
  • qlik-community-blogs.jpg

    Qlik Architecture Deep Dive Blog

    External program tasks in Qlik Sense

    External program tasks in Qlik Sense are simply another task type that exists, but not fully exposed by the QMC. They are tasks that are triggered from the QMC but allow for commands to be run in a command shell process behind the scenes; which in turns means you can run more or less anything you can run on the command prompt.
  • qlik-community-blogs.jpg

    Qlik Design Blog

    On Boolean Fields and Functions

    QlikView does not have any data types. Instead there is the dual format.But it is still relevant to talk about data types, because QlikView functions and operators always return specific data types, albeit in the dual form. Further, QlikView interprets dual parameters and operands differently depending on the expected data type.And how does this work for Boolean functions?All Boolean functions and operations, e.g. IsNull(), True() and comparisons... Show More

    QlikView does not have any data types. Instead there is the dual format.

    But it is still relevant to talk about data types, because QlikView functions and operators always return specific data types, albeit in the dual form. Further, QlikView interprets dual parameters and operands differently depending on the expected data type.

    And how does this work for Boolean functions?

    All Boolean functions and operations, e.g. IsNull(), True() and comparisons such as Date=Today() return 0 for FALSE and -1 for TRUE. Why minus one? Because it is equivalent to setting all the bits in the byte to 1, which is how TRUE is represented in most software systems (as opposed to FALSE, where all bits are set to 0).

    Further, in situations where QlikView expects a Boolean, e.g. in the first parameter of the if() function or in a Where-clause, QlikView will interpret 0 as FALSE, and all other numbers as TRUE.

    Boolean.png

    This means that a number of functions can be used as either Boolean or numeric functions, e.g., Index(), Match(), Substringcount(), and FieldIndex(). For instance, the Match function compares an expression with a list of values and returns the position of the match. But when the Match() function is used in a Boolean position, it will be interpreted as TRUE or FALSE.

    Match.png

    So when you use Match() in a where clause, you will have a condition that is very similar to the SQL “IN” operator. Further, with the WildMatch() function you can use wildcards, just like in the SQL “LIKE” operator:

         Load Where Match(Char, 'A','B') or WildMatch(Name,'*son')

         SQL SELECT … WHERE Char IN ('A','B') OR Name LIKE '%son'

    But the real power of Booleans in QlikView becomes obvious when you define flags in the dimensional tables. For instance, you can easily define a field in the master calendar that tells you if the date belongs to this year:

         If(Year(Date)=Year(Today()), True(), False()) as IsThisYear

    Then you can use this flag in expressions showing the numbers for this year only:

         Sum(if(IsThisYear , Sales))

    Or the same expression with Set Analysis:

         Sum({$<IsThisYear={'-1'}>} Sales)

    Similarly, you can create flags for almost anything: IsLastYear, IsThisYearToDate, IsThisMonth, IsShipped, IsFirstClassCustomer, etc.

    One nice thing about flags is that they are stored in the dimensional tables, which are relatively small tables. Hence, the flags don’t use much memory space. Secondly, QlikView evaluates expressions with flags relatively fast. A third advantage is that it is an efficient way for a script developer to define concepts that may be fairly complex, in a way that the business user easily understands.

    Conclusions:

    • Use the Match and Index functions as Boolean functions in Where-clauses and If-functions.
    • Create flags in the dimensional tables and use these as Booleans in expressions.

    HIC

    See what other QlikView developers think about flags: iQlik, QlikView Addict and QlikView Notes

    Further reading related to this topic:

    Data Types in QlikView

    Automatic Number Interpretation

    Show Less
  • Image Not found

    Qlik Academic Program Blog

    And the Winner Is...

    After  months of hard work building an application, judging by Qlik and C40 Cities, and two days of voting at QlikWorld Online, the Academic Program Datathon winner has been chosen!
  • qlik-community-blogs.jpg

    Qlik Design Blog

    Qlik Sense Custom Report

    Four years ago, I wrote the Customizable Straight Table blog illustrating how you can build a custom table in QlikView.  Last year, I wrote the Custom Report Extension blog that shows how to use the Climber Custom Report in Qlik Sense.  Today, with the help of Patric Nordstrom and Jason Michaelides, I am going to blog about how you can build a custom report in Qlik Sense.  With continued enhancements to the Qlik Sense table such as column show co... Show More

    Four years ago, I wrote the Customizable Straight Table blog illustrating how you can build a custom table in QlikView.  Last year, I wrote the Custom Report Extension blog that shows how to use the Climber Custom Report in Qlik Sense.  Today, with the help of Patric Nordstrom and Jason Michaelides, I am going to blog about how you can build a custom report in Qlik Sense.  With continued enhancements to the Qlik Sense table such as column show conditions and the ability to change the column order of a table, building a custom report in Qlik Sense is possible right out-of-the-box.

     

    Patric built the attached Qlik Sense app that illustrates how to build a custom report in Qlik Sense.  In this blog, I will review the steps needs to build your own report.  Below is an example of how the report looks with some dimensions and metrics selected.  On the left there are two filter panes, one for the dimensions and one for the metrics, that can be used to select the columns you would like to see in the report.  Then there is the table which by default will be empty and will prompt the user to select the dimensions and metrics.  In this example app, the user is encouraged to select no more than 5 dimensions and 4 metrics.

    table.png

    Let’s start by looking the script.  You would load your data as usual but what you will need to add to the data model is a data island for the dimensions and for the metrics.  In the script below, you can see how Patric did it, providing very clear details of each dimension and metric.  The first field in each table is the dimension/metric grouping, the second field is the dimension/metric name as it will appear in the filter panes.  The third field is a number to represent the default order of the dimension/metric columns in the report and the last field is description data about the dimension/metric.  The KPIs table has a fourth field that shows the formulas for the metrics.

    script.png

    Once the app is loaded with the data islands, you can begin to build the custom report.  You will need to add two filter panes and a table to your sheet.  The Dimension filter pane uses the Dimension field and the Metric filter pane uses the Metric field.  In the table, you will add 5 dimension columns and 4 measure columns since that is what is encouraged in this example.  Now here is where Patric used Jason’s FirstSortedValue trick.  For the first dimension, enter the text below in the Field.

    field.png

    And this in the Label:

    label.png

    So, you may be wondering what the expression is doing.  Basically, the Dimension field is being sorted by the DimensionNo field and then, since the third rank parameter is being used, the expression returns the Dimension for the nth sorted value.  In the report screenshot above, the dimensions Product Name and Product Number were selected.  When you sort these by DimensionNo, Product Name comes before Product Number since 3 comes before 4 and when you rank these by their sorted value, Product Name is first and Product Number is second.  This same idea was used in all the dimensions as you can see in the second dimension shown below.

    field2.png

    The measures are done in the same manner.  Below is the Field and Label for the first measure and the additional measure columns will follow the same concept as the dimension columns.

     

    Field

    m_field.png

    Label

    m_label.png

    Now the last step is to add a conditional show to the columns.  Basically, you only want the column to show if there is a dimension and/or metric selected to be displayed.  For the first dimension column, you will set the “Show column if” property to:

    condition.png

    For the second dimension, it will be the same except if greater than or equal to 2 and so on.  The first measure will have the “Show column if” property set to:

    m_condition.png

    Additional measure columns will follow the same format as described above for dimension columns.

     

    Once all the columns are added and the properties are applied, the user can select the dimensions and metrics they would like to see in the report.  By default, the column order will be based on the DimensionNo field but feel free to drag columns in the table to a new position.  For more information on how Jason used FirstSortedValue, check out his document or Qlik Sense Help.

     

    Thanks,

    Jennell

    Show Less
  • Image Not found

    Qlik Product Innovation Blog

    What's New Qlik Product Release - June 2020

    Qlik is pleased to announce the June 2020 product release, furthering our leadership in augmented intelligence, best in class visualizations, and platform extensibility.    Also, this release delivers updates to several data integration products, including performance improvements, expanded cloud platform support, and new certifications.  
  • qlik-community-blogs.jpg

    Qlik Support Updates Blog

    Installation Issue with Qlik Sense June 2020 Patch 1

    Hello Qlik Users!I hope you are all doing well!Yesterday, I blogged the new releases for Qlik Sense Patch Wednesday. After the announcement, a few users reported an error when installing Qlik Sense June 2020 Patch 1. Users have reported the following error:Update failed: Ensure that Qlik Sense June 2020 is installed before you install Qlik Sense June 2020 Patch 1.Qlik Support and R&D investigated the issue and it was found that the Qlik Sense Jun... Show More

    Hello Qlik Users!

    I hope you are all doing well!

    Yesterday, I blogged the new releases for Qlik Sense Patch Wednesday. After the announcement, a few users reported an error when installing Qlik Sense June 2020 Patch 1. Users have reported the following error:

    Update failed: Ensure that Qlik Sense June 2020 is installed before you install Qlik Sense June 2020 Patch 1.

    Qlik Support and R&D investigated the issue and it was found that the Qlik Sense June 2020 GA installer had the incorrect build number, causing June 2020 Patch 1 to error out during the installation. The Qlik Sense June 2020 GA installer with the correct build number is now available on the Qlik download site.

    For those that have Qlik Sense June 2020 GA version 13.82.3 installed, please download the new Qlik Sense June 2020 Patch 1. This new patch will allow you to upgrade version 13.82.3 to 13.82.6 instead of having to uninstall/reinstall the GA release.

    As with all software, please follow best practices when installing and/or upgrading by backing up your Qlik Sense environment and testing in a QA environment first. For more guidance on installing Qlik Sense, see the Qlik Sense Installation Guide. upgrade, 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. 

    We apologize for any inconvenience this issue causes.

    Please subscribe to the Qlik Support Updates Blog by clicking the green Subscribe button and give this post a like if you found it helpful. If you have any questions, please let us know in the comments.

    Thank you for choosing Qlik!

    Kind regards,

    Qlik Global Support

    Show Less
  • Image Not found

    Qlik Support Updates Blog

    Techspert Thursdays - Troubleshooting Qlik Insight Bot Deployment

    Hi everyone,Want to stay a step ahead of important Qlik support issues? Then sign up for our monthly webinar series where you can get first-hand insights from our #QlikSupport experts.The Support Techspert Thursday session from July looked at Troubleshooting Qlik Insight Bot Deployment.But wait, what is it exactly?Support Techspert Thursdays is a free webinar to facilitate knowledge sharing held on a monthly basis.Hear directly from Qlik Techsper... Show More

    Hi everyone,
    Want to stay a step ahead of important Qlik support issues? Then sign up for our monthly webinar series where you can get first-hand insights from our #QlikSupport experts.
    The Support Techspert Thursday session from July looked at Troubleshooting Qlik Insight Bot Deployment.

    But wait, what is it exactly?
    Support Techspert Thursdays is a free webinar to facilitate knowledge sharing held on a monthly basis.
    Hear directly from Qlik Techsperts on topics that are relevant to Customers and Partners today.
    In this session we will cover:

    • What can Insight Bot Do?
    • Architecture
    • Getting started
    • Tips and Tricks

    Click on this link to see the presentation.

    GLBL_2018_LP_Header_Questions_IMG.jpg

    Show Less
  • Image Not found

    Qlik Product Innovation Blog

    It all starts with the Hub ....

    Access the most important information you need much easier and faster - all in the Cloud Hub
  • Image Not found
  • Image Not found
  • qlik-community-blogs.jpg

    Qlik Design Blog

    Qdt-components - custom charts with Qlik's Open Source picasso.js

    Earlier this year I talked about most of the latest picasso.js charts in qdt-components, Qdt-components & Picasso.js - More Charts!. Today I will show you the latest feature where you can use any preexisting setting in qdt-components and create your own custom chart.