Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Business

Announcements
Now accepting applications for the Qlik Luminary and Partner Ambassador Programs: Apply by July 6!
cancel
Showing results for 
Search instead for 
Did you mean: 

Analytics & AI

Forums for Qlik Analytic solutions. Ask questions, join discussions, find solutions, and access documentation and resources.

Data Integration & Quality

Forums for Qlik Data Integration solutions. Ask questions, join discussions, find solutions, and access documentation and resources

Explore Qlik Gallery

Qlik Gallery is meant to encourage Qlikkies everywhere to share their progress – from a first Qlik app – to a favorite Qlik app – and everything in-between.

Support

Chat with us, search Knowledge, open a Qlik or Talend Case, read the latest Updates Blog, find Release Notes, and learn about our Programs.

Events

Learn about upcoming Qlik related events, webinars and local meetups.

Groups

Join a Group that is right for you and get more out of your collaborations. Some groups are closed. Closed Groups require approval to view and participate.

Qlik Community

Get started on Qlik Community, find How-To documents, and join general non-product related discussions.

Blogs

This space offers a variety of blogs, all written by Qlik employees. Product and non product related.

Qlik Resources

Direct links to other resources within the Qlik ecosystem. We suggest you bookmark this page.

Qlik Academic Program

Qlik gives qualified university students, educators, and researchers free Qlik software and resources to prepare students for the data-driven workplace.

Community Sitemap

Here you will find a list of all the Qlik Community forums.

Recent Blog Posts

  • Image Not found
    blog

    Design

    Theming with Picasso.js

    Picasso.js is a powerful charting library that plays really well within the Qlik Sense ecosystem to build simple or very complex visualization.By leve... Show More

    Picasso.js is a powerful charting library that plays really well within the Qlik Sense ecosystem to build simple or very complex visualization.

    By leveraging its component-based nature, you can combine the building blocks to create virtually any type of chart.

    To learn more about Picasso.js, I recommend the following resources:

     

    The full documentation of the library can be found on qlik.dev at https://qlik.dev/libraries-and-tools/picassojs. Navigating the documentation is easy, you can dig deeper into the main concepts, learn more about the different types of supported scales, but more importantly discover the different components that you can mix and match to create unique visualizations.

    A feature of Picasso that I really like but is not very clear from the docs is Theming.

    Picasso.js is themeable meaning that you can easily control the look and feel across all visualizations by creating a theme and changing a few base variables.

    To do that, you simply pass in a theme object when instantiating Picasso js as follows:

     

     

    …
    Import picassojs from ‘picasso.js’;
    …
      const picasso = picassojs({
        style: {
          '$font-color': '#FF00FF',
          '$font-size': '10px',
          '$font-family': 'Arial',
          '$font-size--l': '16px',
          '$guide-color': '#00FF00',
          '$shape': { // for use with type point component
          fill: '#00FF00',
          strokeWidth: 1,
          stroke: 'rgba(255, 255, 255, 0.2)',
          shape: 'star',
         },
        },
        palettes: [{
          key: 'categorical',
          colors: [
            chroma.bezier(['#00FF00', '#0000FF']).scale().colors(5),
          ],
        }, {
          key: 'sequential',
          colors: [
            ['#00FF00', '#0000FF'],
          ],
        }],
      });

     

     

    Notice that you can change the labels’ font styling, colors, and even shapes of points (star, triangle, etc..) on the style object, and also pass in a color palette for categorical and sequential color scales.

    The result looks like this (the ugly colors are for demo purposes only!)

    Capture-999.PNG

    Below is the complete code of the settings file and attached is the full project to run and edit.

     

     

    /* eslint-disable no-unused-vars */
    import {
      useElement,
      useState,
      useStaleLayout,
      useRect,
      useEffect,
    } from '@nebula.js/stardust';
    import picassojs from 'picasso.js';
    import picassoQ from 'picasso-plugin-q';
    
    import chroma from 'chroma-js';
    
    export default function supernova() {
      const picasso = picassojs({
        style: {
          '$font-color': '#FF00FF',
          '$font-size': '10px',
          '$font-family': 'Arial',
          '$font-size--l': '16px',
          '$guide-color': '#00FF00',
          // $shape: { // for use with type point component
          //   fill: '#00FF00',
          //   strokeWidth: 1,
          //   stroke: 'rgba(255, 255, 255, 0.2)',
          //   shape: 'box',
          // },
        },
        palettes: [{
          key: 'categorical',
          colors: [
            chroma.bezier(['#00FF00', '#0000FF']).scale().colors(5),
          ],
        }, {
          key: 'sequential',
          colors: [
            ['#00FF00', '#0000FF'],
          ],
        }],
      });
    
      picasso.use(picassoQ);
    
      return {
        qae: {
          properties: {
            qHyperCubeDef: {
              qDimensions: [],
              qMeasures: [],
              qInitialDataFetch: [{ qWidth: 2, qHeight: 5000 }],
              qSuppressZero: false,
              qSuppressMissing: true,
            },
            showTitles: true,
            title: '',
            subtitle: '',
            footnote: '',
          },
          data: {
            targets: [
              {
                path: '/qHyperCubeDef',
                dimensions: {
                  min: 1,
                  max: 1,
                },
                measures: {
                  min: 1,
                  max: 1,
                },
              },
            ],
          },
        },
        component() {
          const element = useElement();
          const layout = useStaleLayout();
          const rect = useRect();
    
          const [instance, setInstance] = useState();
    
          useEffect(() => {
            const p = picasso.chart({
              element,
              data: [],
              settings: {},
            });
    
            setInstance(p);
    
            return () => {
              p.destroy();
            };
          }, []);
    
          useEffect(() => {
            if (!instance) {
              return;
            }
    
            instance.update({
              data: [
                {
                  type: 'q',
                  key: 'qHyperCube',
                  data: layout.qHyperCube,
                },
              ],
              settings: {
                scales: {
                  x: {
                    data: {
                      extract: {
                        field: 'qDimensionInfo/0',
                      },
                    },
                  },
                  y: {
                    data: { field: 'qMeasureInfo/0' },
                    invert: true,
                    expand: 0.1,
                  },
                  c: {
                    data: { field: 'qMeasureInfo/0' },
                    type: 'color',
                  },
                },
                components: [
                  {
                    type: 'axis',
                    dock: 'left',
                    scale: 'y',
                  },
                  {
                    type: 'axis',
                    dock: 'bottom',
                    scale: 'x',
                    settings: {
                      line: {
                        show: true,
                      },
                    },
                  },
                  {
                    type: 'grid-line',
                    x: 'x',
                    y: 'y',
                  },
                  {
                    key: 'bars',
                    type: 'box',
                    data: {
                      extract: {
                        field: 'qDimensionInfo/0',
                        props: {
                          start: 0,
                          end: { field: 'qMeasureInfo/0' },
                        },
                      },
                    },
                    settings: {
                      major: { scale: 'x' },
                      minor: { scale: 'y' },
                      box: {
                        fill: { scale: 'c', ref: 'end' },
                      },
                    },
                  },
                ],
              },
            });
          }, [layout, instance]);
    
          useEffect(() => {
            if (!instance) {
              return;
            }
            instance.update();
          }, [rect.width, rect.height, instance]);
        },
      };
    }

     

     

     

     

     

    Show Less
  • Image Not found
    blog

    Japan

    【オンデマンド配信】データリテラシーでビジネスを加速:受け身から能動的な分析への移行に不可欠な要件

    企業におけるデータの役割が急速に進化し続ける中、データリテラシーはこれまで以上に重要になっています。データリーダーは、受け身の BI モデルからアクティブインテリジェンスへと移行し始めています。リアルタイムのインサイトにアクセスし、迅速な意思決定と情報に基づいたリアルタイムのアクションを起こすには... Show More

    DataLiteracyWebinar_LANDING_PAGE_FINAL1920x4501920x450.jpg

    企業におけるデータの役割が急速に進化し続ける中、データリテラシーはこれまで以上に重要になっています。データリーダーは、受け身の BI モデルからアクティブインテリジェンスへと移行し始めています。リアルタイムのインサイトにアクセスし、迅速な意思決定と情報に基づいたリアルタイムのアクションを起こすには、能動的な分析への移行が不可欠です。

    迅速な意思決定ができていない最大の障壁の 1 つにデータリテラシー不足が挙げられます。つまり、データを読み取り、活用、分析し、データとのコミュニケーションスキルが不足しているのです。かつてないほどデータから得られる機会が増えている今、情報に基づいたアクションを取るためには、必要なスキルアップと文化の変革を早急に検討する必要があります。

    本 Web セミナーでは、新着レポート「データリテラシー:スキルアップの革新」の調査結果をはじめ、受け身の分析から能動的な分析に移行して、ビジネスの加速およびデータリテラシーを促進する方法をご紹介します。

    能動的な分析への移行におけるデータリテラシーの重要性について、ぜひご確認ください。

    ※ 参加費無料。パソコン・タブレット・スマートフォンで、どこからでもご視聴いただけます。日本語字幕付きでお届けします。

    今すぐ視聴する

    Show Less
  • qlik-nontechnicalblogs.jpg
    blog

    Design

    Combo Chart extension for Qlik Sense

    As we were working on one of our projects, we had the need of creating multiple combo charts. The problem was that we could not change the colors to m... Show More

    As we were working on one of our projects, we had the need of creating multiple combo charts. The problem was that we could not change the colors to match our mashup/webpage. So, I decided to make an extension, that gives full control of the chart appearance and it's labels. The same as my Barchart extension this is wrapping text labels underneath the bars. If you still have problems with the text, then just increase the width of the bars and everything should be back in place.

    Installation

    - [Download zip file](https://github.com/yianni-ververis/SenseUI-ComboChart/archive/master.zip)

    - Desktop - Unzip at the extension folder (C:\Users\<user>\Documents\Qlik\Sense\Extensions\SenseUIComboChart)

    - Server - Upload the zip file

    Usage

    Dimensions and Measures

    - Set 1 dimension for the x Axis

    - Set 1 Measure for an additional Line Chart

    General Settings

    - Font Size

    - Font Color

    - Display the Legend

    - Enable/Disable Selections

    Bar Chart Settings

    - Bar Color

    - Bar Hover Color

    - Bar Width (0 for auto scaling)

    - Bar Border Color

    - Bar Border Width

    Line Chart Settings

    - Line Color

    - Line Width

    - Dot Color

    - Dot Stroke Color

    - Dot Stroke Width

    - Dot Radius

    preview2.png

    preview2.png

    Barnch: http://branch.qlik.com/#!/project/5894e07a75db504d76ac3123

    Git: GitHub - yianni-ververis/SenseUI-ComboChart: Qlik Sense Combo Chart

    Yianni

    Show Less
  • Image Not found
    blog

    Explore Qlik Gallery

    Qlik Sense Education and Learning - Project - TC Ice Cream Inc.

     The TC Ice Cream Application project provides students a structured approached to learn the basics of Qlik Sense.  A variety of visualizations, maste... Show More

     

    The TC Ice Cream Application project provides students a structured approached to learn the basics of Qlik Sense.  A variety of visualizations, master dimensions/measures and variable input are topics that are covered within the project.

    This video provides an overview of the project:

    https://youtu.be/XM1sa_hyRi8

    Business Requirements Document:

    https://drive.google.com/file/d/1vUNgJQB0ZyJuTzlIBL-T7Q41u4YjbvmN/view

    Videos related to the development and functionality of the TC Ice Cream Application can be found on the following You Tube Playlist :

    https://www.youtube.com/watch?v=1h_Pvr-aiT4&list=PLl4F1FsqnyHD6Wz9Q63qxqp9EnIpkqfNt

    If you have any questions please let me know.

    Thanks - Jerry

     

     

     

    Show Less
  • qlik-nontechnicalblogs.jpg
    blog

    Qlik Academic Program

    Which Data Literacy persona are you?

    Every month our Academic Program team meets with our Educator Ambassadors to get inspired by guest speakers and customer stories or knowledge share an... Show More

    Every month our Academic Program team meets with our Educator Ambassadors to get inspired by guest speakers and customer stories or knowledge share and ask questions. Some of our most interesting sessions are those in which our Educator Ambassadors present on how they incorporate the Academic Program into their teaching.

    There are a variety of ways in which educators have used our program, from embedding the assessments to including portions of the instructor led training videos in classes. However, it is often the case that students starting the course have different strengths and weaknesses, and varying levels of data literacy. During our meeting last Friday one of our educators explained that his students are required to take a Qlik data literacy assessment before beginning their course, this then helps to him to understand what training and resources could be useful to the students. This level test, our Data Literacy Persona Assessment, is provided for free by Qlik. It can be accessed through our ‘Data Literacy Program’ which you can navigate to inside the ‘Self-Paced Learning’ section.

    HollyJohnson_6-1653314906310.png

    It can be found at the bottom of the page under the subheading ‘Assessments’, you will then be directed to sign in with your Qlik ID to gain access to the test.

    HollyJohnson_7-1653314989031.png

    Our Data Literacy Persona test takes minutes, it includes 15 different questions and can be used to assess your current knowledge level and then establish the next steps in your training. Some of the questions are geared towards those already working in industry; however, it is still possible to answer the questions as a student to better understand both knowledge level and attitude. For example, are you a data newcomer? Someone who understands the importance of data but still needs to learn the foundations. This test will help you find that out, and once you have the results, you will be provided with a custom learning plan to help you get started on your journey.

    Your learning plan will detail a variety of ways to get started, whether that be content available to you through the Qlik Continues Classroom, interesting YouTube videos or blogs and podcasts. The learning plan is themed around the crucial indicators of data literacy, for example reading, working with, analyzing and communicating with data. It is intended to be done over the course of 8 weeks, giving you optimum time to dip in and out of study when it’s most convenient.

    If you have recently gotten access to the Academic Program but you don’t know where to start with all the resources available to you, then understanding your knowledge level with our Data Literacy Persona test could help you take that first step. To understand more about how you can access the test through our Academic Program, go to  qlik.com/academicprogram.

    Show Less
  • qlik-nontechnicalblogs.jpg
    blog

    Explore Qlik Gallery

    Kobe - Basketball Career Highlights

    Kobe - Basketball Career Highlights Vizlib The Kobe Bryant app was designed as a tribute to the Black Mamba and his incredible career in the NBA... Show More
    Show Less
  • Image Not found
    blog

    Japan

    【オンデマンド配信】Qlik Espresso Web セミナーシリーズ

    Qlik Espresso Web セミナーシリーズでは、Qlik 製品のプロフェッショナル達が Qlik 製品の簡単な概要、製品デモンストレーション、使用例についてご紹介します。本 Web セミナーは、毎月 1回・最大 30分間の内容でお送りします。 コーヒーを飲みながら、短時間でお気軽に参加でき... Show More

    Qlik Espresso Web セミナーシリーズでは、Qlik 製品のプロフェッショナル達が Qlik 製品の簡単な概要、製品デモンストレーション、使用例についてご紹介します。
    本 Web セミナーは、毎月 1回・最大 30分間の内容でお送りします。

    コーヒーを飲みながら、短時間でお気軽に参加できる Web セミナーシリーズです。ぜひ、ご視聴ください。

    ※ 参加費無料。パソコン・タブレット・スマートフォンで、どこからでもご視聴いただけます。

    オンデマンド配信:
    データをビジネス成果へ結びつけるデータ活用プラットフォームとは -「目的」ではなく「手段」としてのデータ活用 -

    ビジネスにおけるデータ活用。かねてよりその重要性が説かれていましたが、新型コロナウイルスによって加速度を増し、今後ますます重要度が高まっていくと予想されています。リアルタイムなデータのビジネスへの活用が企業の将来を左右する、と言っても過言ではありません。
    この講演では、Qlik が掲げるビジョンである「アクティブインテリジェンス」」を具現化するリアルタイムのデータ活用プラットフォームと、その具体例についてご紹介します。

    オンデマンド配信:
    『DNP の価値創造プロセス』を実現するためのデータ利活用の推進

    DNP 様におけるビジネス推進のためのデータ利活用について、インタビュー形式で実際の取り組みを具体的に語っていただきます。ビジネス課題を解決するためのアクションと成果とは?Qlik 導入を機に全社におけるデータ活用への取り組み、今後の展望などを語っていただきます。ぜひ、ご参加ください。

    今すぐ視聴する

    JP_Blog_image.JPG

    今すぐ視聴する

    Show Less
  • qlik-nontechnicalblogs.jpg
    blog

    Explore Qlik Gallery

    Self Service Analytics Template

    Self Service Analytics Template Imaps Intelligence The purpose of the app is to provide a simple interface for a Business User get an answer abo... Show More
    Show Less
  • qlik-nontechnicalblogs.jpg
    blog

    Explore Qlik Gallery

    Activity trackers and Analytics Part 2 - Strava

    Activity trackers and Analytics Part 2 - Strava Mayborn Group Back in 2020 I talked about personal Qlik Sense App which I use to analyse my Garm... Show More
    Show Less
  • qlik-nontechnicalblogs.jpg
    blog

    Explore Qlik Gallery

    U.S. Demographics (2010)

    U.S. Demographics (2010) AnyChart — Extensions for QS Get a bird's-eye view of the U.S. population trends revealed by key demographic statistics... Show More

    🔗 >> LEARN MORE & DOWNLOAD THIS APP (.QVF) <<

    🔗 >> SEE MORE APPS <<

    Show Less
  • Image Not found
    blog

    Design

    Regression Lines

    What is a regression line? In simple terms, it is a line that best describes the behavior of a set of data. They are often used for forecasting to ill... Show More

    What is a regression line? In simple terms, it is a line that best describes the behavior of a set of data. They are often used for forecasting to illustrate the relationship between the dependent y variable and the independent x variables when there is linear pattern. Using a regression line can show future behavior of the dependent variable using different inputs for the independent x variables. Scatter plots now support regression lines and provide many options to choose from. In the properties pane of the scatter plot chart under Add-ons, is an option for Regression Lines.

    add reg line.png

    Click the Add Regression Line button to add a regression line to your chart. There are many types to choose from depending on your data and what you would like to show. According the Qlik Help, here are the regression line types available to add to a scatter plot chart.

    types.png

    • Average: Shows the average value of the data.
    • Linear: Shows a linear increase or decrease of values.
    • Second Degree Polynomial: Shows a curved line to represent fluctuating data with one hill or valley.
    • Third Degree Polynomial: Shows a curved line to represent fluctuating data with up to two hills or valleys.
    • Fourth Degree Polynomial: Shows a curved line to represent fluctuating data with up to three hills or valleys.
    • Exponential: Shows a curved line. Use when data values rise or fall at increasingly higher rates.
    • Logarithmic: Shows a curved line. Use when the rate of change in data increases or decreases quickly, then levels out.
    • Power: Shows a curved line. Use with data sets that compare measurements that increase at specific rates.

     

    Here are some regression line examples:

    AverageAverageLinearLinearSecond Degree PolynomialSecond Degree PolynomialFourth Degree PolynomialFourth Degree Polynomial

    There are some additional properties that can be set for a regression line. The color of the line and label can be set, and the line can be displayed as solid or dashed. The direction of fit can also be set to either minimize vertically or minimize horizontally. A scatter plot can also have more than one regression as seen in the chart below.

    multiple.png

    Regression lines are helpful for analysis because it allows us to see patterns in our data. They allow us to see the relationships between two or more variables and examine which variables may have an impact. Check them out - Qlik Sense makes it easy to use them in your scatter plots charts.

    Thanks,

    Jennell

    Show Less
  • qlik-nontechnicalblogs.jpg
    blog

    Community News

    May = QlikWorld + Community Enhancements

    Hello Qlik Community! QlikWorld 2022 is less than a week away! Are you all excited?! We sure are! If you’re not already registered, you may do so here... Show More

    Hello Qlik Community!

    QlikWorld 2022 is less than a week away! Are you all excited?! We sure are!

    If you’re not already registered, you may do so here. Qlik Community will be a part of the “Let’s Connect!” booth, so stop by and say ‘Hi’!

    I cannot believe it’s May already – in the US that means schools are winding down and summer is coming! Bring on the sunshine, pool, and BBQ! For the Qlik Community, that means we have some hot new updates for you!

    Product List

    Products are primarily used within our Support Knowledgebase and Release Notes. We’ve cleaned up the products list to make filtering easier. We also condensed Qlik Sense Enterprise SaaS and Qlik Sense Business to one product, Qlik Cloud.

    products.png

     

    Qlik Cloud Change Log

    Use the new Qlik Cloud Change Log card on the Product News carousel for easy access to what’s new in Qlik Cloud. A link to the Help page has also been added to the Qlik Cloud release notes (going forward).

    changelog.png

     

    Chat Bot

    Have you reached an inaccessible area on Qlik Community? The message directs you where to go for assistance, but we’ve also added the Chat Bot to the page so you can easily reach out to Customer Support for assistance!

    errorchatbot.png

     

    Typically, we would be on a freeze until July but we are just too excited to wait for the upcoming enhancements! Check back in a few weeks for a few new updates!

    Your Qlik Community Admins,

    Melissa, Sue, Jamie and Nicole

    Show Less
  • qlik-nontechnicalblogs.jpg
    blog

    Explore Qlik Gallery

    Cyclistic Case Study

    Cyclistic Case Study Cyclistic Cyclistic’s finance analysts have concluded that annual members are much more profitable than casual riders. Alth... Show More
    Show Less
  • Image Not found
  • Image Not found
  • Image Not found
    blog

    Product Innovation

    What's New - Qlik Sense May 2022 - Now available!

    Learn about all the great new capabilities in our Client-Managed Qlik Sense offering: Augmented Analytics Now offering Business Logic – allowing users... Show More

    Learn about all the great new capabilities in our Client-Managed Qlik Sense offering:

     

    Augmented Analytics

    Now offering Business Logic – allowing users to define the default grain for a calendar period, such as on a yearly, quarterly, or monthly basis. When users create behaviors such as default calendar periods, they can now specify whether to use or ignore the grain for a particular analysis, providing more advanced fine-grain controls.

     

    New Visualization & Dashboarding capabilities

    The May 2022 release of Qlik Sense Enterprise on Windows includes several data visualization features that were previously released in Qlik Sense SaaS. With this release, we have expanded the variety of and added flexibility to your data visualization options based on user feedback.  Our new scatter plot allows you to add regression lines, including average, linear, exponential, logarithmic; and second, third, and fourth polynomial. Regression line color and type can be set, and vertical or horizontal fit can be specified. Next, our updated, more flexible variable UI surfaces all variable elements, including name, description, value, and tags; and allows you to add search, and duplicate variables. The addition of background colors and icons in the KPI object provides more ways for you to customize Qlik Sense, as you wish. Additional capabilities and enhancements like buttons and coloring options have been added to various areas, improving usability and convenience, while adding clarity, speeding time to insight, and expediting data-driven decision making. Finally, to help with your transition to SaaS, we have enacted a 12-month grace period for GeoAnalytics extensions in Qlik Cloud. Following the grace period, you can use the map chart, which is faster, easier to use, prints better, and includes more features.

     

    Expanded Connectivity

    To start, the Qlik Web Storage Provider Connectors are now available in Qlik Sense Enterprise on Windows in the same way as in Qlik Sense SaaS. The corresponding metadata connectors are also integrated, without the need for Qlik Web Connectors separately installed. These connectors allow you to connect to file-based data stored on a web storage provider, either by browsing for folders and files directly in the UI, or via the separate metadata connectors listing the structures and objects in tables. The web storage provider platforms supported are Amazon S3, Azure Storage, Dropbox, Google Cloud Storage, Google Drive, Office 365 Sharepoint, and OneDrive.

    Also, the Oracle Connector in Sense SaaS now provides additional security capabilities with support for the upload of an Oracle Wallet file. An Oracle Wallet holds authentication credentials, private keys, certificates, etc., and thus enables organizations to easily enforce security rules based on defined user privileges contained in an Oracle Wallet. The Oracle Connector can now access Oracle via a TLS encrypted communication channel.

     

    Platform enhancements:

    Includes new capabilities to make your App Distribution from Qlik Sense Client Managed to a Qlik Sense SaaS Tenant even more robust and scalable.  Introducing a new Task type -> Distribution Task Re-Distribute an App with Data only if the Data blob has been updated

     

    Hybrid Use Case Improvements

    On top of releasing capabilities to further improve our Hybrid use cases, we released a new installation tool to help you upgrade your PostgreSQL Database as part of your Qlik Sense Client Managed installation. For the consumer-driven use cases, we released the ability to add favorites in the hub. Administrators will benefit from an improvement in the Management Console which makes it easier for them to globally replace extensions (and/or upgrade existing extensions). 

     

    To access this build: Download here

    REGISTER FOR QLIK INSIDER  providing more details on this release and new deliveries to Qlik Cloud!

     

    Show Less
  • qlik-nontechnicalblogs.jpg
    blog

    Design

    Floor It!

    Have you ever tried to compare two dates that looked the same to find out that in fact they were different?  I was recently approached by a colleague ... Show More

    Have you ever tried to compare two dates that looked the same to find out that in fact they were different?  I was recently approached by a colleague who had this problem.  In their script, they were adding a flag when the date in a field was also the last day of the month.  Both dates were formatted to show the month, day and year (M/D/YYYY) but the flag was never true even when the dates appeared to be the same.  When working with dates, you may find that although two dates are formatted the same, the underlying values may be different.  To troubleshoot this, we used the Num function to get the numeric value of the two dates we were comparing in the script to see if the two dates were the same numerically.  Take a look at the table below for an example of how we resolved the issue.

     

    Steps Date 1 Date 2 Notes

    Start with these dates2018-10-05 05:16:5010/5/2018 
    Format Date 1 to display the date like Date 2 is formatted

    Date('2018-10-05 05:16:50', 'M/D/YYYY')

    >>

    10/5/2018

    10/5/2018 
    Is Date 1 = Date 2?10/5/201810/5/2018No, not equal
    Use Num() to see numeric value of dates

    Num(‘2018-10-05 05:16:50’)

    >>

    43378.220023148

    Num(10/5/2018)

    >>

    43378

    The numerical values of Date 1 and Date 2 are not the same
    Use Floor to round Date 1 down to just the date

    Num(Floor(‘2018-10-05 05:16:50’))

    >>

    43378

    Num(10/5/2018)

    >>

    43378

     
    Using Floor, is Date 1 = Date 2?

    Num(Floor(‘2018-10-05 05:16:50’))

    >>

    43378

    Num(10/5/2018)

    >>

    43378

    Yes, they are equal

     

    So let’s explain what is going on here.  We started with 2 dates – one that had a timestamp and one that did not.  After formatting the dates the same, it was determined that the dates were not equal.  This is because the underlying numeric value of Date 1 still included the time even though the time was not visible after it was formatted as M/D/YYYY.  The numeric value of 2018-10-05 05:16:50 is 43378.220023148 while the numeric value of 10/5/2018 is 43378.  When looking at the numeric values, the value before the decimal point represents the date and the value after the decimal point represents the time.  To handle this, the Floor function was used.  According to Qlik Sense Help,

     

    Floor() rounds down a number to the nearest multiple of the step shifted by the offset number.

    Compare with the ceil function, which rounds input numbers up.

    Syntax: 

    Floor(x[, step[, offset]])

     

    Once the floor function was used, Date 1 was rounded down to just the date, giving it a numeric value of 43378 - the same as Date 2.

     

    It is helpful to remember that dates have numeric values.  We often see dates formatted to meet our needs which is great but when we need to compare dates, we need to look beyond the displayed date and look at the numeric date.  The Date function controls how the date is displayed but it does not change the underlying value of the date.  In this example, the Floor function rounded the timestamp down to just the date.  The Ceil function works similarly except it rounds up.  You can also check out Henric Cronstrom’s blog titled Why don’t my dates work? for other date related issues you may stumble upon.  I hope you find this blog helpful and that it helps you quickly troubleshoot date comparison issues should they arise.

     

    Thanks,

    Jennell

    Show Less
  • Image Not found
    blog

    Product Innovation

    Qlik Reporting Service, a new approach to report distribution in the cloud

    What Is Qlik Reporting Service?Qlik Reporting Services is a public API that provides the ability to compose multi-page outputs from your apps, leverag... Show More

    What Is Qlik Reporting Service?

    Qlik Reporting Services is a public API that provides the ability to compose multi-page outputs from your apps, leveraging your curated analytics in a report format.  It can be easily used from within Qlik Application Automation or can be integrated into customers’ systems directly.  Qlik Reporting Service is available to our Qlik Sense Enterprise SaaS customers.   This is our first major release on our cloud reporting journey and together with Qlik Application Automation it reimagines report task management using a low code/no code report process definition.  Centralized reporting teams can now in a matter of a few inputs define burst reports to support management or operational reporting requirements and leverage their cloud eco-system to source recipients, and configure distribution channels. 

     

    We see three areas where our customers will reap immediate benefits with Qlik Reporting Service:

    • Automate report distributions:  Time to value is an overarching benefit provided by Qlik Reporting Service.  By utilizing automation, IT centralized reporting functions, as well as many savvy team members within line of business, can quickly learn to assemble, automate and accelerate the distribution of different reports needed by a wide variety of stakeholders across the organization.
    • Connect and Deliver:  Whether through emailing to anyone (both Qlik users and non-Qlik stakeholders) or delivering through cloud storage connectors such as  Dropbox, Amazon S3 or Google Cloud Storage, there are several options to support burst reports in Qlik Cloud.
    • Extend the reach of analytics: We can now provide scheduled or triggered cadence of Qlik Sense report insights to a customer’s wider business ecosystem, including to partners, suppliers, customers, agents, etc. extending Qlik’s analytics reach and increasing the investment value of our Qlik Sense SaaS analytics platform.

    ­­

    Qlik Reporting Service is now available to all Qlik Sense Enterprise SaaS customers and includes 100 reports per tenant per month defined as a document output of a reporting services call. 

    We are excited about our latest data analytics innovation for the cloud.  We invite you to revisit, rethink and reexamine your potential for reporting in the cloud with Qlik Reporting Service. 

     

    To learn more visit: Qlik Reporting Service video playlist and for all the latest SaaS enhancements visit our SaaS Change Log

     

    Show Less
  • Image Not found
    blog

    Product Innovation

    Highlights of Recent Qlik Sense SaaS Data Visualization Capabilities

    Add Help to your Qlik Sense ApplicationWhen you need to provide more details to a chart, such as a definition, tip, or note, you can add a container t... Show More

    Add Help to your Qlik Sense Application

    When you need to provide more details to a chart, such as a definition, tip, or note, you can add a container tab with text and image object. This not only gives users context, but also reduces clutter when you need to add more information that is not specified within the chart.

    QlikProductUpdates_0-1649349461031.png

     

     

    QlikProductUpdates_1-1649349461130.png

     

    Add Reference Lines in Charts

    It’s often necessary to add context to metrics presented in charts and dashboards. This helps data consumers and decision makers easily see key points within your chart. By adding reference lines for 50% and top 5 as dynamic indicators, additional perspective is displayed.

    QlikProductUpdates_2-1649349461146.png

     

    Grid Chart with Pie Charts

    Using a grid chart with pies can help users visualize KPIs over time or with different variables like regions. To do this, you can re-use the map chart with the chart layer.

    QlikProductUpdates_3-1649349461151.png

     

    QlikProductUpdates_4-1649349461261.png

     

    Table Indicators

    By adding table indicators, you can enrich your tables with context, allowing users to immediately identify outliers and understand key metrics.  Table indicators can include rank, trend, and status markers to simplify the interpretation of values. Below you will see how to add table indicators in Qlik Sense.  

    QlikProductUpdates_5-1649349461357.png

    QlikProductUpdates_6-1649349461416.png

     

    QlikProductUpdates_7-1649349461474.png

     

    Icicle Chart

    Helpful in showing hierarchies, you can create an icicle chart by modifying the pivot chart. To determine the space you need, sort by the first measure and count the leafs. Make sure “totals” are turned “on,” so you can sort by the first measure. To color by number of leafs, use the colormix function. You can reduce clutter utilizing pivot buttons and condensing the header with CSS multi-KPI.

    QlikProductUpdates_8-1649349461503.png

     

                   Icicle Chart with Deviation

    Finally, the deviation icicle chart provides users with a simple way to see the differences between metrics over time. For example, you can quickly show a number increase or decrease in units sold or bookings month over month using the deviation icicle. This type of chart is created using the combo with stacked bars for the deviation and white bar as the offset. First, add lines with actual and forecast, turn on labels, and set forecast to transparent =argb(0,0,0,0). Next, add bars for offset=min(Actual,Forecast) and deviation. Then, color the offset bar transparent =argb(0,0,0,0) and deviation red for – and green for +. Finally, add a marker layer for lollipops.

    QlikProductUpdates_9-1649349461591.png

     

    As you use Qlik Sense SaaS more and more, you will clearly see how Qlik’s world-class visualization capabilities stand ahead of other analytics companies when it comes to supporting your innovation today and in the future.  For more information on these and other data visualization capabilities, check out Qlik’s Visualization Showcase. See this eBook for tips on avoiding common data visualization pitfalls.

    Show Less
  • Image Not found
    blog

    Qlik Academic Program

    University of Tasmania students learn data analytics using Qlik Academic Program

    The Qlik Academic Program is being leveraged by many Universities in Australia and New Zealand.  More than 45 Universities from ANZ are using the acad... Show More

    The Qlik Academic Program is being leveraged by many Universities in Australia and New Zealand.  More than 45 Universities from ANZ are using the academic program resources to enable the student and educator community in analytics. 

    A local study by Arktic Fox and Michael Page Australia has identified data and analytics as the number one skill gap in marketing teams. Most marketing leaders say data literacy was not strong in their departments. To fulfill this gap and also a growing demand for data analytics resources, the Qlik Academic Program provides top class analytics software, training, qualifications, certifications to University students and professors, completely free.  

    The University of Tasmania (UTAS) has been partnering with the Qlik Academic Program for a number of years now. Each year, Charlie Farah, Senior Director, Solutions and Value Engineering at Qlik presents to the students on all things data and analytics.  

    Dr. Joel Scanlan from UTAS who collaborates with Charlie on this initiatives says, “ We are very grateful to Charlie for his time and continued support”

    The primary course is the Master of Health Information Management which aims to equip students with a strong awareness of the role that data and information have on modern healthcare, with particular interest in Data Analytics, Privacy and Security, ethics, and governance. A number of these components are also covered in the Graduate Certificate in eHealth also.

    Charlie is invited to present to students enrolled in subject BAA735 Health Data Management, Information Analysis and Improvement which delves into key theories and approaches in health data management and information. Frameworks and models for information analysis and reporting are also investigated, including strategies for measuring and monitoring organisational and clinical outcomes and experiences. Something world leading data & analytics software is critical for.

    Students get practical hands on with a range of data, including a deep dive into a dataset of their own choosing using Qlik Cloud. This equips them to be able to analyse and understand data, to see its impact not only on clinical outcomes, but also the efficiency of care delivery and better equip them for their roles ahead.

    Joel Scanlan further says that they look forward to continuing this partnership for many years ahead.  The Qlik Academic Program is happy to work with UTAS and forge a strong partnership to enable its students and professors in data analytics.

    For more information about the academic program, visit: qlik.com/academicprogram

    Show Less