Skip to main content

Blogs

Hear directly from Qlik employees in our ten unique blogs.

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

Design

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

Product Innovation

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

Support Updates

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

Qlik Academic Program

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

Community News

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

Qlik Digest

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

Qlik Education

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

Technical Bulletin

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

Japan

Qlik Community blogs for our customers and partners in Japan.

Recent Blog Posts

  • qlik-community-blogs.jpg

    Design

    Using Colors with Qlik Sense Visualizations, Measures and Dimensions

    Our Christof Schwarz is back and has created a video tutorial that shows you how to use PERSISTENT CUSTOM colors with Qlik Sense visualizations. Persistent colors map all dimension values to specific consistent colors that are represented equally in all charts on the sheet. When you perform selections - the values displayed will all be represented by the same color in the charts. However the colors can change when the sequence or number of values... Show More

    Our Christof Schwarz is back and has created a video tutorial that shows you how to use PERSISTENT CUSTOM colors with Qlik Sense visualizations. Persistent colors map all dimension values to specific consistent colors that are represented equally in all charts on the sheet. When you perform selections - the values displayed will all be represented by the same color in the charts. However the colors can change when the sequence or number of values for that dimension have changed. So this tip will show you how to assign specific custom colors to those values so they don't change and remain "sticky" as Christof puts it.

    Enjoy!

    Show Less
  • qlik-community-blogs.jpg

    Design

    REST connector: Using WITH CONNECTION

    See what WITH CONNECTION can do for you when working with REST data sources
  • qlik-community-blogs.jpg

    Design

    Qlik Sense 3.2: Extension Properties

    After reading Michael's wonderful post on the 3.2 features, https://community.qlik.com/blogs/qlikviewdesignblog/2017/04/04/introducing-qlik-sense-32?et=blogs.comment.created#commen…, I admit, I wanted to get into more details on each of the topics he mentioned. Even though this is impossible since there are so many goodies hidden in 3.2, I decided to focus more on the properties panel while creating custom extensions.Some of these will make us re... Show More

    After reading Michael's wonderful post on the 3.2 features, https://community.qlik.com/blogs/qlikviewdesignblog/2017/04/04/introducing-qlik-sense-32?et=blogs.comment.created#commen…, I admit, I wanted to get into more details on each of the topics he mentioned. Even though this is impossible since there are so many goodies hidden in 3.2, I decided to focus more on the properties panel while creating custom extensions.

    Some of these will make us retouch some of our extensions since, personally, I used workarounds like custom color in an input field as hex, inject dropdowns as html etc

    Below I show the latest properties and at the end I attach an extension with everything working... Please note that, as the help pages suggest, some of these are "considered EXPERIMENTAL and may be subject to change or be removed in future releases."

    For more details, please bookmark Qlik Sense Developer's help page

    http://help.qlik.com/en-US/sense-developer/3.2/Subsystems/APIs/Content/extensions-api-reference.htm

    SIMPLE TEXT DESCRIPTIONInteger
    2017-04-28 23_07_23-Helpdesk Management - Google Charts _ Sheets - Qlik Sense.png2017-04-28 23_08_10-Helpdesk Management - Google Charts _ Sheets - Qlik Sense.png

    text: {

        label:"This is a description for the properties panel (Text Component)",

        component: "text"

    },

    fontSize: {

        type: "integer",

        expression: "none",

        label: "Font Size (Integer)",

        defaultValue: "10",

        ref: "vars.fontSize"

    },


    INPUT TEXTBUTTON
    2017-04-28 23_09_25-Helpdesk Management - Google Charts _ Sheets - Qlik Sense.png2017-04-28 23_09_40-Helpdesk Management - Google Charts _ Sheets - Qlik Sense.png

    inputText: {

        type: "string",

        expression: "none",

        label: "String (Input Text)",

        defaultValue: "This is a test app to checkout custom properties",

        ref: "vars.inputText"

    },

    button: {

        label:"My Button (Button Component)",

        component: "button",

        action: function(data){

            alert("My visualization extension name is '"+data.visualization+"' and have id '"+data.qInfo.qId+"'.");

        }

    },

    BUTTON GROUPHeader 2
    2017-04-28 23_09_54-Helpdesk Management - Google Charts _ Sheets - Qlik Sense.png2017-04-28 23_10_06-Helpdesk Management - Google Charts _ Sheets - Qlik Sense.png

    weight: {

        type: "string",

        component: "buttongroup",

        label: "Font Weight (Button Group)",

        ref: "vars.weight",

        options: [{

            value: "bold",

            label: "Bold",

            tooltip: "Select for Bold text"

        }, {

            value: "normal",

            label: "Normal",

            tooltip: "Select for normal text"

        }],

        defaultValue: "normal"

    },

    show: {

        type: "boolean",

        label: "Show extra div? (boolean)",

        ref: "vars.show",

        defaultValue: false

    },

    COLOR PICKERDROP DOWN
    2017-04-28 23_10_14-Helpdesk Management - Google Charts _ Sheets - Qlik Sense.png2017-04-28 23_10_24-Helpdesk Management - Google Charts _ Sheets - Qlik Sense.png

    colorPicker: {

        label:"Background (Color-picker)",

        component: "color-picker",

        ref: "vars.color",

        type: "integer",

        defaultValue: 0

    },

    dropDown: {

        type: "string",

        component: "dropdown",

        label: "Select Options (dropdown)",

        ref: "vars.dropDown",

        options: [{

            value: "option1",

            label: "Option 1",

            tooltip: "Select for Option 1"

        }, {

            value: "option2",

            label: "Option 2",

            tooltip: "Select for Option 2"

        }, {

            value: "option3",

            label: "Option 3",

            tooltip: "Select for Option 3"

        }],

        defaultValue: "option2"

    },

    LINKSLIDER
    2017-04-28 23_10_40-Helpdesk Management - Google Charts _ Sheets - Qlik Sense.png2017-04-28 23_10_59-Helpdesk Management - Google Charts _ Sheets - Qlik Sense.png

    link: {

        label:"http://help.qlik.com/en-US/sense-developer/3.2/Subsystems/APIs/Content/ExtensionAPI/property-definition-link.htm",

        component: "link",

        url:"http://help.qlik.com/en-US/sense-developer/3.2/Subsystems/APIs/Content/ExtensionAPI/property-definition-link.htm"

    },

    slider: {

        type: "number",

        component: "slider",

        label: "Letter Spacing (Slider)",

        ref: "vars.slider",

        min: 1,

        max: 10,

        step: 1,

        defaultValue: 1

    },

    RANGE SLIDERSWITCH
    2017-04-28 23_11_07-Helpdesk Management - Google Charts _ Sheets - Qlik Sense.png2017-04-28 23_11_14-Helpdesk Management - Google Charts _ Sheets - Qlik Sense.png

    rangeSlider: {

        type: "array",

        component: "slider",

        label: "Range slider",

        ref: "vars.rangeSlider",

        min: 1,

        max: 20,

        step: 1,

        defaultValue: [8, 17]

    },

    switch: {

        type: "boolean",

        component: "switch",

        label: "Show Border (Switch)",

        ref: "vars.switch",

        options: [{

            value: true,

            label: "Show"

        }, {

            value: false,

            label: "Hide"

        }],

        defaultValue: false

    },

    TEXT AREAARRAYS
    2017-04-28 23_11_23-Helpdesk Management - Google Charts _ Sheets - Qlik Sense.png2017-04-28 23_11_40-Helpdesk Management - Google Charts _ Sheets - Qlik Sense.png

    textarea: {

        label:"Textarea",

        component: "textarea",

        rows: 7,//the amount of rows in the textarea component (default is 3)

        maxlength: 100,//will not allow more than 100 characters

        ref: "vars.textarea",

        defaultValue: "This can be your fottnote/legend to your visualizations"

    },

    MyList: {

        type: "array",

        ref: "listItems",

        label: "List Items",

        itemTitleRef: "label",

        allowAdd: true,

        allowRemove: true,

        allowMove: true,

        addTranslation: "Add Item",

        items: {

            label: {

                type: "string",

                ref: "label",

                label: "Label",

                expression: "none"

            },

            textarea: {

                label:"My textarea",

                component: "textarea",

                maxlength: 100,//you shouldn't write too much

                ref: "myTextarea"

            }

        }

    }

    Attached find the extension.

    Yianni

    Show Less
  • Image Not found

    Support Updates

    Revamped Downloads Site Comes to Community!

    Launched Tuesday, February 15, 2022
  • Image Not found

    Qlik Education

    Qlik Sense 2022 BETA certifications- $75

    Registration is now open for Qlik Sense 2022 BETA certifications. Be among the first to be certified and receive the discounted price of $75 (regularly $250).
  • qlik-community-blogs.jpg

    Design

    The Date Function

    One Qlik function that occasionally causes confusion is the Date function. I have often seen errors caused by an incorrect usage of it, so today I will try to explain what the function does – and what it does not.
  • Image Not found

    Support Updates

    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. The Techspert Talks session from July looked at NPrinting On-Demand with Qlik Sense 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 Custome... Show More

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

    The Techspert Talks session from July looked at NPrinting On-Demand with Qlik Sense 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 covers:

    • How NPrinting On-Demand works
    • Configuration considerations
    • Troubleshooting common errors

     

    Click on this link to see the presentation.

    Techspert-Talks_Imagery_Community-590x310.jpg

    Show Less
  • Image Not found

    Support Updates

    Qlik Sense Migration: Migrating your Entire Qlik Sense Environment

    Hi everyone, For various and valid reasons, you might need to migrate your entire Qlik Sense environment, or part of it, somewhere else. In this post, I’ll cover the most common scenario: a complete migration of a single or multi-node Qlik Sense system, with the bundled PostgreSQL database (Qlik Sense Repository Database service) in a new environment. So, how do we do that? Introduction and preparation Backup your old environment Deploy and r... Show More

    Hi everyone,

    For various and valid reasons, you might need to migrate your entire Qlik Sense environment, or part of it, somewhere else.

    In this post, I’ll cover the most common scenario: a complete migration of a single or multi-node Qlik Sense system, with the bundled PostgreSQL database (Qlik Sense Repository Database service) in a new environment.

    So, how do we do that?

    1. Introduction and preparation
    2. Backup your old environment
    3. Deploy and restore the new central node
    4. What about my rim nodes?
    5. Finalizing your migration

     Introduction and preparation

     

    Let’s start with a little bit of context: Say that we are running a 3 nodes Qlik Sense environment (Central node / Proxy-Engine node / Scheduler node).

    On the central node, I also have the Qlik shared folder and the bundled Qlik Sense Repository Database installed.

    This environment has been running well for years but I now need to move it to a brand new hardware ensuring better performance. It’s not possible to reinstall everything from scratch because the system has been heavily used and customized already. Redoing all of that to replicate the environment is too difficult and time-consuming.  

    I start off with going through a checklist to verify if the new system I’m migrating to is up to it:

    And then I move right over to…

     

    Backup your old environment

     

    The first step to migrate your environment in this scenario is to back it up.

    To do that, I would recommend following the steps documented on help.qlik.com (make sure to select your Qlik Sense version top left of the screen).

    https://help.qlik.com/en-US/sense/April2019/Subsystems/PlanningQlikSenseDeployments/Content/Sense_Deployment/Backing-up-a-site.htm

    Once the backup is done you should have:

    • A backup of the database in .tar format
    • A backup of the content of the file share which includes your applications, application content, archived logs, extensions,…
    • Backups of any data source files that need to be migrated and are not stored in the shared folder like QVDs

    Then we can go ahead and…

     

    Deploy and restore the new central environment

     

    The next steps are to deploy and restore your central node. In this scenario, we will also assume that the new central node will have a different name than the original one (just to make things a bit more complicated 😊).

    Let’s start by installing Qlik Sense on the central node. That’s as straightforward as any other fresh install.

    You can follow our documentation. Before clicking on Install simply uncheck the box “Start the Qlik Sense services when the setup is complete.

    The version of Qlik Sense you are going to install MUST be the same as the one the backup is taken on.  

    Now that Qlik Sense is deployed you can restore the backup you have taken earlier into your new Qlik Sense central node following Restoring a Qlik Sense site.

    Since the central node server name has also changed, you need to run a Bootstrap command to update Qlik Sense with the new server name. Instruction provided in Restoring a Qlik Sense site to a machine with a different hostname.

    The central node is now almost ready to start.

    If you have changed the Qlik Share location, then the UNC path has also changed and needs to be updated.

    To do that

    • Go to C:\Program Files\Qlik\Sense\Repository\Util\QlikSenseUtil
    • Run QlikSenseUtil.exe as Administrator
    • Click on Connect to the database and enter the credential to connect to the new PostgreSQL database
    • Click on Service Cluster and press OK. This should display the previously configured UNC Path
    • You simply need to update each path, save and start/restart all the Qlik sense services.

    01.png

    At this point make sure you can access the Qlik Sense QMC and Hub on the central node. Eventually, check that you can load applications (using the central node engine of course). You can also check in the QMC -> Service Cluster that the changes you previously made have been correctly applied.

    Troubleshooting tips: If after starting the Qlik Sense services, you cannot access the QMC and/or Hub please check the following knowledge article How to troubleshoot issue to access QMC and HUB

     

    What about my rim nodes?

     

    You’ve made it here?! Then congratulation you have passed the most difficult part.

    If you had already running and configured rim nodes in your environment that you now need to migrate as well, you might not want to remove them from Qlik Sense to add the new ones since you will lose pretty much all the configuration you have done so far on these rim nodes.

    By applying the following few steps I will show you how to connect to your “new” rim node(s) and keep the configuration of the “old” one(s).

    Let’s start by installing Qlik Sense on each rim node like it was a new one.

    The process is pretty much the same as installing a central node except that instead of choosing “Create Cluster”, you need to select “Join Cluster

    Detailed instruction can be found on help.qlik.com - Installing Qlik Sense in a multi-node site

    Once Qlik Sense is installed on your future rim node(s) and the services are started, we will need to connect to the “new” Qlik Sense Repository Database and change the hostname of the “old” rim node(s) to the “new” one so that the central node can communicate with it.

    To do that install PGAdmin4 and connect to the Qlik Sense Repository Database. Detailed instruction in Installing and Configuring PGAdmin 4 to access the PostgreSQL database used by Qlik Sense or NPrinting knowledge article.

    Once connected navigate to Databases -> QSR -> Schemas -> public -> Tables

    You need to edit the LocalConfigs and ServerNodeConfigurations table and change the Hostname of your rim node(s) from the old one to the new corresponding one (Don’t forget to Save the change)

    LocalConfigs table

    02.png

     

    ServerNodeConfigurations table

    03.png

     

    Once this is done, you will need to restart all the services on the central node.

    When you have access back, login to the QMC and go to Nodes. Your rim node(s) should display the following status, “The certificate has not been installed

    04.png

     

    From this point, you can simply select the node, click on Redistribute and follow the instruction to deploy the certificates on your rim node. After a moment the status should change and you should see the services being up and running.

    Do the same thing on the remaining rim node(s).

    Troubleshooting tips: If the rim node status is not showing “The certificate has not been installed” it means that either the central node cannot reach the rim node or the rim node is not ready to receive new certificates.

    Check that the port 4444 is opened between the central and rim node and make sure the rim node is listening on port 4444 (netstat -aon in command prompt)

    Still no luck?! You can completely uninstall Qlik Sense on the rim node and reinstall it.

     

    Finalizing your migration

     

    At this point, your environment is completely migrated and most of the stuff should work.

    Data Connection

    There is one thing to consider in this scenario. Since the Qlik Sense certificates between the old environment and the new one are not the same, it is likely that data connections with passwords will fail.  This is because passwords are saved in the repository database with encryption.  That encryption is based on a hash from the certs.  When the Qlik Sense self-signed cert is rebuilt, this hash is no longer valid, and so the saved data connection passwords will fail.  You will need to re-enter the passwords in each data connection and save.  This can be done in the QMC -> Data Connections.

    See knowledge article: Repository System Log Shows Error "Not possible to decrypt encrypted string in database"

    Licensing

    Do not forget to turn off your old Qlik Sense Environment. As per your license agreement, you can only use one license per active Qlik Sense environment. Reach out to your account manager for more details.

    Best practices

    Finally, don’t forget to apply best practices in your new environment:

     

    I’ll be watching for your questions, feedback or suggestions so please comment and share (and like if you liked 😊)!  

     

    Show Less
  • Image Not found

    Qlik Digest

    Qlik Digest - September 2022

    Welcome to the September Qlik Digest! Our latest edition brings you essential insights and tips, including product updates, event recommendations, and key resources not to be missed in an easy to “digest” format!We want everyone using Qlik to be in the loop, so please share this post with your colleagues.
  • qlik-community-blogs.jpg

    Design

    Bill of Materials

    Most hierarchies are dimensional hierarchies. This implies several things: First, you have a many-to-one relationship between the levels: a day belongs to one (and only one) month, a month to one (and only one) quarter, etc. Strictly speaking, it is not a hierarchy unless this condition is fulfilled.   Secondly, the hierarchy contains no measures. Instead, numbers are stored in a transactional table that is linked to the dimensional hierarchy.   ... Show More

    Most hierarchies are dimensional hierarchies. This implies several things: First, you have a many-to-one relationship between the levels: a day belongs to one (and only one) month, a month to one (and only one) quarter, etc. Strictly speaking, it is not a hierarchy unless this condition is fulfilled.

     

    Secondly, the hierarchy contains no measures. Instead, numbers are stored in a transactional table that is linked to the dimensional hierarchy.

     

    But there is another hierarchy-like structure, the Bill of Materials, the “BoM”. This is a list of items, assemblies and sub-assemblies representing the design of a product or device. Many products are planned and documented with BoMs.

     

    A multi-level BoM depicts parent-child relationships and shows the hierarchical structure of the assemblies and their related subcomponents. A multi-level BoM is essentially a nested list whose items are listed to illustrate multiple assemblies within a product.

     

    BoM input.png

     

    But a BoM is very different from a dimensional hierarchy. It does not have to have a strict many-to-one relationship between the levels. For instance, a specific bearing type can be used in several places. For the BoM, this means that the bearing can have several parents in the hierarchy.

     

    Further, each line in the BoM has numbers in it, typically Quantity and Cost. These are measures that should be summed. In a sense, a BoM is more similar to a transaction table than a dimensional table.

     

    A BoM can easily be loaded and analyzed with Qlik Sense or QlikView, but there are some challenges: First, the list often lacks a parent reference. Instead, the parent-child relationship is implied by the order of the rows and the Level field, and visualized by indentations.

     

    Secondly, aggregating the measures is not straightforward. When summing the costs, the multiplicities of all the nodes above it must be taken into account. In the example in the above table, the wheel assembly uses 2 bearings, and the trailer uses 4 wheel assemblies. Then the trailer obviously needs 8 bearings. In other words: The row for the wheel assembly – and all rows belonging to it – must be looped 4 times when summing the cost.

     

    Luckily, both these challenges can be handled in the Qlik script. One possible solution is the following:

     

       Hierarchy ( [Part No], Parent, Description )

       Load *,

           Subfield( Path, '/', Level ) as Parent;

       Load *,

           Left( Peek( Path ), Index( Peek( Path ) & '/', '/', Level ) -1 ) & '/' & [Part No] as Path

           While IterNo() <= Units;

       Load *,

           If( Frac( Quantity)=0, Quantity, 1 ) as Units,

           If( Frac( Quantity)=0, 1, Quantity ) as Amount

           From BoM ;

     

    The reference to the parent is created in two steps: First a Path is built using the Level and the Path of the above row. Having the path, it is straightforward to extract the parent id using Subfield().

     

    Further, each row is loaded several times using a while loop. Hence, row 16 (the ball bearings) is loaded twice since its Quantity is 2. But it should be loaded 8 times since the Quantity of its parent (row 6, Wheel assembly) is 4. This multiplication is achieved using the Hierarchy prefix.

     

    Finally, the above multiplication algorithm only works for integer quantities. For this reason the bottom Load splits the Quantity into two fields: a field Units that is used in the While loop, and an Amount that is used in the aggregation:

     

       Sum( Amount * UnitCost )

     

    However, this means that nodes that have non-integer quantities cannot have any children. If they do, the above algorithm cannot be used, and the cost roll-up must be made a different way. Luckily, this is rarely or never the case in real life.

     

    Good luck with your Bill of Materials!

     

    HIC

     

    Further reading related to this topic:

    Unbalanced, n-level hierarchies

    Show Less
  • qlik-community-blogs.jpg

    Design

    Custom Report Extension

    A couple of years ago I wrote a blog on customizing straight tables in QlikView explaining how you can add an ad-hoc report to your QlikView app.  So, I thought I would share how you can now create a custom report in Qlik Sense using the Climber Custom Report extension.  The Climber Custom Report is an extension that can be added to your Qlik Sense app to give users the ability to create their own ad-hoc reports.  In this blog, I will show you ho... Show More

    A couple of years ago I wrote a blog on customizing straight tables in QlikView explaining how you can add an ad-hoc report to your QlikView app.  So, I thought I would share how you can now create a custom report in Qlik Sense using the Climber Custom Report extension.  The Climber Custom Report is an extension that can be added to your Qlik Sense app to give users the ability to create their own ad-hoc reports.  In this blog, I will show you how easy it is to add a custom report to your app using Qlik Sense Desktop.

    1. The first step is to download the Climber Custom Report extension from Qlik Branch, unzip it and put it in your Extensions folder (C:\Users\xxx\Documents\Qlik\Sense\Extensions).
    2. In your Qlik Sense app, create a table with all the possible dimensions and measures a user may want to see in a report and then add the table to master items.  The table may look something like this: table.png
    3. Add the Climber Custom Report extension to a sheet in your app and then you are ready to create a report.
    4. In the Visualizations drop down, select the report you just created.  All tables that are in your visualization master items will be listed in the drop down.  Once the table is selected, the dimension and measure lists will be populated with the dimensions and measures that are used in the table as seen below.dimensions and measures.png
    5. Select the dimensions and measures you would like to add to your report by clicking on them.  Your report will look something like the image below after you make some selections.  The dimensions are blue and the measures are orange.selections.png
    6. From the custom report bar above the chart, you can remove a dimension or measure by clicking the x and you can change the order of the columns by dragging and dropping the dimensions and measures into the order you would like them to appear in the report.

    And that is it - it is that simple to add a custom report to your Qlik Sense app.  With Qlik Sense self-service, a user can create a report by dragging and dropping dimensions and measures into a table but what I like about the Climber Custom Report extension is it makes everything available to the user with a clean, professional and organized look.  Download it now and test it out for yourself.  See the extension in action in the Situational Awareness demo.  Note - the Climber Custom Report extension works in Qlik Sense 3.0 and higher and, like all extensions, are not supported by Qlik.

    Thanks,

    Jennell

    Show Less
  • Image Not found

    Qlik Academic Program

    Qlik Academic Program participates in ICT Learnathon 2022

    ICT Academy in association with the industry partners, launched its fifth season of ‘LEARNATHON 2022’ - a self-learning initiative for higher education students to build their foundational IT skills online. ​Since 2018, through Learnathon, ICT Academy has inculcated self-learning among college students and benefitted many students.The 5th edition of Learnathon has been launched this year by ICT Academy in partnership with global tech majors such ... Show More

    ICT Academy in association with the industry partners, launched its fifth season of ‘LEARNATHON 2022’ - a self-learning initiative for higher education students to build their foundational IT skills online. ​

    Since 2018, through Learnathon, ICT Academy has inculcated self-learning among college students and benefitted many students.

    The 5th edition of Learnathon has been launched this year by ICT Academy in partnership with global tech majors such as Qlik. This initiative is exclusive to the member institutions of ICT Academy such as colleges and Universities across India.

    Learnathon 2022 will see participation from more than 600 colleges. Nine Industry partners including Qlik are participating in this initiative to offer their learning courses and academic programs

    The Qlik Academic Program is associated with Learnathon for a second year in a row after a great response in 2021. Students have been very enthusiastic about the learning pathways offered under the academic program and they have actively pursued training for the Qlik Sense Business Analyst and Qlik Sense Data Architect pathways with many of them getting certified. This will add value to the future prospects of students given the fact that data analytics is one of the most sought after careers.

    To know more about the free data analytics resources of the Qlik Academic Program, visit: qlik.com/academicprogram 

    Show Less
  • Image Not found

    Product Innovation

    Securely access data behind a firewall or VPC with Qlik Data Gateway - Direct Ac...

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

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

    Show Less
  • Image Not found

    Community News

    In memory of Gysbert Wassenaar

    The loss of one of our most valued Qlik Community members. 
  • qlik-community-blogs.jpg

    Qlik Gallery

    Human Resource Dashboard By Tapati

    Human Resource Dashboard By Tapati Freelancer Human Resource Dashboard will be used by my prospective clients as a portfolio of my work and this dashboard shows different analyses of employee performance monitoring, employee details and directory. Discoveries Human Resource Dashboard will be used by my prospective clients as a portfolio of my work and this dashboard shows different analyses of employee performance monitoring, employee... Show More
    Show Less
  • Image Not found

    Japan

    事務所移転のお知らせ

    時下ますますご清祥のこととお慶び申し上げます。平素は格別のご高配を賜り厚くお礼申し上げます。 この度、弊社はデータを行動につなげる「アクティブインテリジェンス」の実践を通じた機動力の向上、およびアフターコロナの新しいワークスタイルへの対応をめざし、東京本社を新事務所へ移転することになりましたことお知らせ申し上げます。これを機会に、社員一同一層社業に専念いたしますので、今後とも倍旧のお引き立てを賜りますようお願い申し上げます。【移転先住所】 〒105-0001 東京都港区虎ノ門1-3-1 東京虎ノ門グローバルスクエア 13階       ※電話番号は変更ございません【業務開始日】 2022年 9月 12日(月)2022年 9月吉日クリックテック・ジャパン株式会社カントリーマネージャー今井 浩
  • Image Not found

    Japan

    Qlik AutoML - 機械学習のパワーで分析部門を強化(Qlik Blog 翻訳)

    ブログ著者:James Fisher 本ブログは  Qlik AutoML – The Power of Machine Learning for Analytics Teams の翻訳になります。機械学習は、売上予測から解約率の低減・顧客生涯価値・在庫の最適化・資本の配分など、多岐にわたる予測分析のニーズに対し、業界やユーザーコミュニティで利用されています。通常、データサイエンティストのプロフェッショナルは、非常に詳細かつ高度な方法で、上位の優先事項にのみ焦点を当てます。では、それ以外はどうなるのでしょうか?Qlik AutoML は、「その他の90%」のユースケースに予測分析を適用し、分析部門が大きな価値を創出できるようにします。Qlik は AIを活用して、単なる履歴的な分析から予測的・処方的な分析への移行を可能にします。従来の分析は、過去のデータから発生したことを把握・深掘りして、「なぜ、そのようなことが起きたのか」という、ある程度のインサイトを得て適切な意思決定を行い、より有効... Show More

    automl-overview-image.png

    ブログ著者:James Fisher 本ブログは  Qlik AutoML – The Power of Machine Learning for Analytics Teams の翻訳になります。

    機械学習は、売上予測から解約率の低減・顧客生涯価値・在庫の最適化・資本の配分など、多岐にわたる予測分析のニーズに対し、業界やユーザーコミュニティで利用されています。

    通常、データサイエンティストのプロフェッショナルは、非常に詳細かつ高度な方法で、上位の優先事項にのみ焦点を当てます。では、それ以外はどうなるのでしょうか?Qlik AutoML は、「その他の90%」のユースケースに予測分析を適用し、分析部門が大きな価値を創出できるようにします。

    Qlik AIを活用して、単なる履歴的な分析から予測的・処方的な分析への移行を可能にします。従来の分析は、過去のデータから発生したことを把握・深掘りして、「なぜ、そのようなことが起きたのか」という、ある程度のインサイトを得て適切な意思決定を行い、より有効な行動を起こそうとしていました。

    Qlik AutoML のロジックも同じですが、機械学習を利用して過去のデータを分析し、将来の結果を予測できるモデルを構築します。推測するのではなく、より具体的な目に見える形で意思決定ができるようになります。予測データと説明できるデータの両方があれば、「これから何が起きるのか」だけでなく、もっと重要な「その理由がわかる」ということです。起こりうる結果とその要因を把握すれば、最善の意思決定から行動を起こすことができるのです。

    ダウンロード.png

    Qlik AutoML Qlik Cloud に完全に統合されました。分析部門が AutoML を活用できるよう、シンプルかつコード不要の方法を提供することで、機械学習モデルのトレーニング・予測・意思決定の計画を策定することができます。Qlik AutoML は、独自の分析エンジンを活用し、Qlik Sense で予測データの探索や what-if シナリオのテストを可能にします。また、Qlik のエンドツーエンドプラットフォームを使用すると、通知と自動化で行動を促すことができます。

    すべてのエンタープライズ SaaS サブスクリプションには、無制限のテストおよび 2 つの展開モデルが含まれていますので、Qlik AutoML の優れた機能をすぐに体験することができます。ぜひ、お試しください。

    Show Less
  • Image Not found
  • Image Not found

    Design

    How to make a lollipop chart with Qlik Sense

    It's been a while since I posted a tip about creating charts. I say roll up your sleeves and let's hack one of the standard charts to create a chart type that doesn’t exist in our chart library. Who's in?We will be making a lollipop chart and something extra, because, well, why not.First, let's describe what a lollipop chart is and why it can be useful.What is a lollipop chart?A lollipop chart is a variation of a bar chart. It differs from a trad... Show More

    It's been a while since I posted a tip about creating charts. I say roll up your sleeves and let's hack one of the standard charts to create a chart type that doesn’t exist in our chart library. Who's in?

    We will be making a lollipop chart and something extra, because, well, why not.

    First, let's describe what a lollipop chart is and why it can be useful.

    What is a lollipop chart?

    A lollipop chart is a variation of a bar chart. It differs from a traditional bar chart in two ways: bars are reduced to a line, and the bar tips are oversized in the shape of a circle. If you're a sweet tooth, it'll remind you of a lollipop.

    One of the main benefits of a lollipop chart is that it can be used to represent a large set of tall bars in a less intimidating way. However, it is pertinent to emphasize that this chart is less accurate than a regular bar chart. This is mainly because the center of the circle at the end of the lollipop marks the value. In comparison to the straight edge of a bar, it is difficult to determine where the center is located. 

    Hands on

    We will use a combo chart and some of its not-so-new features to create a lollipop chart. Remember a bar chart needs at least one dimension and one measure.

    Drag a combo chart and add a dimension and one measure

    Nothing wrong with this chartNothing wrong with this chart

     

    Next, let’s start messing with the chart settings. Go to Appearance, Presentation, and then Advance Styling. There you will be presented with a bunch of configuration options. What we want is to make the bar width really thin. Anything around 0.1 usually works well.

     

    ArturoMuoz_1-1647996869113.png

     

    Now our combo chart should look something like the one below.

    ArturoMuoz_2-1647996869159.png

     

    Next, is the time to add the candy on top of those lines. Since we are using a combo chart we can quickly add another measure to it and pick a marker as its representation. Simply add the same measurement you used for the bars again. It will be added as a line and the label will say height of line. Don’t panic, no yet. Next expand the new measure panel and scroll down to click on “More properties” button and pick “Marker” from the options displayed.

     

    Your chart should be looking something like thisYour chart should be looking something like this

     

     

    The next step is to get the colors of the bars and the marker in sync. Simply select the appropriate color in the menu option under the measure “More properties” panel.

     

    ArturoMuoz_4-1647996869252.png

     

     

    If you want your circle markers in sync with your bars, and you are using something more sophisticated than single color you can go a long way with colors by using expression instead of single color in the panel.

    As a final step, make sure that neither the legend nor the tooltip ruin our little hack by showing both metrics. To do that just scroll to the very bottom of the combo chart Presentation properties panel deactivate the legend and change the tooltip properties from basic to custom to make sure you have control over it.

     

    ArturoMuoz_5-1647996869423.png

     

    EXTRA TIP:

    After learning how to make a fancy lollipop chart using the combo chart, we can spend some time creating a bar chart with rounded corners as in the picture below.

    ArturoMuoz_6-1647996869523.png

     

    The process is simple, just adjust the bar width until it matches the circle diameter size and voila, your rounded corner bar chart is ready. There are some colors that work better than others at dissimulating marker borders (darker colors), keep that in mind if you are looking for perfection. 

     

    Thank you for reading this post I hope you enjoyed it.

    Arturo

     

     

    Show Less
  • Image Not found

    Support Updates

    Latest Version of Entitlement Analyzer for Qlik Sense Enterprise SaaS customers ...

    Hello Qlik Users!  How can I track the usage of my Tenant over time? How are my entitled users using the Tenant?  How can I better understand the usage of Analyzer Capacity vs. Analyzer & Professional Entitlements?  These are a couple of the questions we frequently hear. To enable you to find better answers for those, we are happy to share with you the new Entitlement Analyzer for Qlik Sense Enterprise SaaS!  The Entitlement Analyzer will help an... Show More

    Hello Qlik Users! 

    How can I track the usage of my Tenant over time? How are my entitled users using the Tenant? 

    How can I better understand the usage of Analyzer Capacity vs. Analyzer & Professional Entitlements? 

    These are a couple of the questions we frequently hear. To enable you to find better answers for those, we are happy to share with you the new Entitlement Analyzer for Qlik Sense Enterprise SaaS! 

    Entitlement Analyzer.pngThe Entitlement Analyzer will help answer those questions and more! The app provides insights on: 

    • Entitlement usage overview across the Tenant 
    • Analyzer Capacity – Detailed usage data and a predication if you have enough 
    • Understand how users are using the system and if they have the right Entitlement assigned to them 
    • Understand which Apps are used the most by using the NEW "App consumption overview" sheet
    • And much more! 

     

    Analyzer.JPG

     

    The Entitlement Analyzer uses a new API Endpoint to fetch all the required data and will store the history in QVD files to enable even better Analytics over time. 

     A few things to note: 

    • This app is provided as-is and is not supported by Qlik Support. 
    • It is recommended to always use the latest app. 
    • Information is not collected by Qlik when using this app. 

     

    The app as well as the configuration guide can be found at the bottom of this post. This app was created internally and will be supported by the developers of the app. They will be following this thread so be sure to post any questions or issues here so they can be addressed. 

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

    Kind regards, 

    Qlik Digital Support Team 

    Edit as of Oct. 7, 2021: Updated and attached latest QVF file for Entitlement Analyzer. The new version contains details about open events and therefore allows customers to better understand their consumption of the tenant. 

     

    Show Less