Qlik Community

Blogs

Hear directly from Qlik employees in our eight unique blogs. Check out the new Architecture Deep Dive Blog!

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

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

Deep dives into specific back-end technologies which allow for the extension of Qlik to fit the needs of the enterprise.

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

Updates for Qlik Community offerings, announcements and changes.

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

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.

Recent Blog Posts

  • Image Not found
    Qlik Academic Program Blog

    How analytics in sport is making an impact both on and off the pitch

    The market for sports analytics is expected to reach almost $4 billion by 2022, so if you are considering a career in this field, there could be a wealth of opportunities open to you if you have the right skills. From baseball to basketball, and football to tennis, it seems the use of in-game statistics and video analysis is becoming increasingly common place. Video analysis helping Lincoln city to top the league in 2017 is just on... Show More

    The market for sports analytics is expected to reach almost $4 billion by 2022, so if you are considering a career in this field, there could be a wealth of opportunities open to you if you have the right skills. From baseball to basketball, and football to tennis, it seems the use of in-game statistics and video analysis is becoming increasingly common place. Video analysis helping Lincoln city to top the league in 2017 is just one example of this.

     

    But it’s not only on the pitch that analytics is making an impact. Data from customer engagement both online and in the stadium can help to boost ticket sales and even to sell more merchandise on game day. Back office functions such as supply chain management and logistics can also benefit along with player trading, as there are now more data points per individual than ever before. You can read the full Forbes article on this here: https://www.forbes.com/sites/forbestechcouncil/2019/01/31/how-data-analysis-in-sports-is-changing-the-game/#7babff0c3f7b

     

    So, if this is an industry that you would like to break into, getting to grips with an analytics tool and theoretical concepts is key. And that’s where the Qlik Academic Program can help. If you are a University student or academic, you qualify to apply for our completely free program which gives you access to our analytics software and training resources. Not only can you learn how to use Qlik Sense and earn a qualification, but there is also training on general theories and concepts in data analytics too. Sign up today to get started on your path to sporting analytics glory! qlik.com/academicprogram

    Show Less
  • Image Not found
    Qlik Academic Program Blog

    Montclair State University MBA students Learn Qlik!

    For the 2nd year in a row, Qlik was asked to visit Professor Kollikkathara's MBS course for students studying Data Analytics and Visualization at Montclair State University in New Jersey.  We were joined by our Partner, Chris Ferrara at SDG group who provided a wonderful presentation about how analytics affects life sciences in today's world.  The students learned more about what makes Qlik unique and at the end of class they ... Show More

    montclair.jpgFor the 2nd year in a row, Qlik was asked to visit Professor Kollikkathara's MBS course for students studying Data Analytics and Visualization at Montclair State University in New Jersey.  We were joined by our Partner, Chris Ferrara at SDG group who provided a wonderful presentation about how analytics affects life sciences in today's world.  The students learned more about what makes Qlik unique and at the end of class they applied to the Academic Program for free software, training, and more!  The students will use their membership in the program on their final project with Qlik Sense!

    If you are teaching analytics and want to enhance your course, you and your students should sign up for the Qlik Academic Program!  Membership grants free software, a year of training, a chance to receive a Qlik Sense Certificate and more! Don't miss out, apply today!

    Show Less
  • Image Not found
    Qlik Support Updates Blog

    How to contact Customer Support if you are unable to login to the Support Portal...

    How to contact Customer Support if you are unable to login to the Support Portal. Have you tried logging into the Support Portal, but are unable to do so? This could be due to an error or an access issue. Don’t worry! If you are unable to login to the Support Portal, you can submit a case as a guest.   To do so, go to support.qlik.com. Scroll down to the green bar that says, ‘Work with an expert to get the answers you need.’ Select Submit a ... Show More

    How to contact Customer Support if you are unable to login to the Support Portal.

    Have you tried logging into the Support Portal, but are unable to do so? This could be due to an error or an access issue. Don’t worry! If you are unable to login to the Support Portal, you can submit a case as a guest.

     

    To do so, go to support.qlik.com. Scroll down to the green bar that says, ‘Work with an expert to get the answers you need.’

    Select Submit a case. The Case Wizard will pop up with a drop-down menu. The options below allow you to submit a case as a guest.

    • I have a login/access or website issue
    • I have a license issue
    • I have an issue with Qlik Sense Cloud

    All other options require users to login.

     

    After filling out the form, the option to Chat with us/Chat unavailable or Log a case is given. Chat with us allows you to chat with a Support agent live. Log a case will submit the case to the queue. From there the case will be assigned to a Customer Support agent and they will review your request and follow up.

     

    Thanks for reading and I hope this helps! Remember to like this post if you found it helpful. Look out for our next post on Monday July 22nd, 2019.

     

    Related articles:

    New Look Support Portal Demo - https://support.qlik.com/articles/000073402

    How to create a case - https://support.qlik.com/articles/000043153

    How to create a Technical Case - https://support.qlik.com/articles/000043147

     

    Join our Customer Success team for the Welcome to Qlik Webinar on Tuesday July 16th, 2019.

    Follow this link to register:

    https://community.qlik.com/t5/Community-Corner/quot-Welcome-to-Qlik-quot-Webinar-Tuesday-July-16-2019/m-p/1590102#M9878

    Another great resource for new users - https://help.qlik.com/onboarding

    Show Less
  • Image Not found
    Qlik Education Blog

    Why everyone should be data literate

    Qlik's Jordan Morrow explains the importance of being data literate through his very own Ted talk! Check it out and become data literate by visiting qlik.com/GetDataLiterate..   University professors and students can also join the Academic Program for additional opportunities to become data literate!  To apply visit  http://qlik.com/academicprogram  .  
  • Image Not found
    Qlik Design Blog

    Trellis Chart

    With the June 2019 release of Qlik Sense, the trellis chart is now a visualization we can add to our apps right out-of-the-box. With this release, the Trellis container extension is part of the Qlik Visualization bundle allowing us to show a master visualization across various dimension values all at once. Here is an example of what a Trellis chart looks like:     In the Trellis chart above, Lost Time Value by Line for each Plant is be... Show More

    With the June 2019 release of Qlik Sense, the trellis chart is now a visualization we can add to our apps right out-of-the-box. With this release, the Trellis container extension is part of the Qlik Visualization bundle allowing us to show a master visualization across various dimension values all at once. Here is an example of what a Trellis chart looks like:

     

    5 charts.png

     

    In the Trellis chart above, Lost Time Value by Line for each Plant is being displayed. The master visualization is a bar chart with the dimension Line and the measure for Lost Time Value. When I add this master visualization to the Trellis container along with the Plant dimension, I can see the bar chart for all 5 plants. This allow me to compare the time lost value for each plant side by side. The Trellis chart is created by adding the Trellis container from the Qlik Visualization bundle to a sheet and adding a dimension and master visualization. One adjustment I had to make since I was using an expression for my measure was to add a label for the measure in the master visualization. This prevented the whole expression from being displayed as the label.

     

    There are several Trellis options in the properties section that are quite helpful in customizing how you want the Trellis chart to look. In the chart above, I set number of columns property to 5 so that all charts could be displayed side by side. I also set the dimensions titles property to left side only. This shows the dimension label (Line 1, Line 2 and Line 3) on the left most chart only providing more space and removing redundant labels that are not necessary in this layout since the charts are side by side. Other title options included right side only, top only or bottom only. There is also the option to adjust the measure labels by setting the measures titles property but I opted to keep this set to chart default and show the label on each chart.

     

    Here is another example of how the Trellis charts could be displayed:

     

    3 charts.png

     

    In this example, I set the number of columns property to 3 and I kept the dimensions titles and measure titles properties set to the default, chart default, so that the x and y axis labels appear on all the charts. With this layout, if I set the dimensions titles to left side only, the top left chart would be the only chart with a dimension label and I did not think it would be clear to the user that it applied to all the charts.

     

    There are many other properties that can be set for the Trellis container such as slide mode. On mobile devices, slide mode is on and shows one Trellis chart at a time. The user can swipe to get to the next chart. Here is what the Trellis container with slide mode on looks like. Notice the arrow on the right that can be used to go to the next chart and the dots at the bottom to show that I am on the first of five charts.

     

    slide.png

     

    Check out Qlik Help and the Trellis Container video to see all the ways the Trellis container can be customized. To learn more about the other new features in the Qlik Sense June 2019 release, check out the What’s New – Qlik Sense June 2019 app on Qlik’s Demo Site and the What’s New video. These resources also highlight the best practices you should consider when creating master visualizations that will be used in a Trellis container.

     

    Thanks,
    Jennell

     

    Show Less
  • Image Not found
    Qlik Support Updates Blog

    Support Techspert Thursdays - Top 10 Qlik Sense Enterprise Visualization Best Pr...

    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. This coming Thursday, 20 June Qlik Support will host another Support Techspert Thursday session and this time we are looking at the Top 10 Qlik Sense Enterprise Visualization Best Practices. But wait, what is it exactly? Support Techspert Thursdays is a... 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.

    This coming Thursday, 20 June Qlik Support will host another Support Techspert Thursday session and this time we are looking at the Top 10 Qlik Sense Enterprise Visualization Best Practices.

    But wait, what is it exactly?

    Support Techspert Thursdays is a free webinar to facilitate knowledge sharing held on a monthly basis, on the third Thursday of each month. 

    Hear directly from Qlik Techsperts on topics that are relevant to Customers and Partners today.

    In this session we will cover:

    • Deep dive into visualizations
    • Demonstration of most effective charts
    • How to exploit controls to the max

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

    The webinar is hosted using ON24 in English and will last 30 minutes plus time for Q&A.

    Hope to see you there!!

    Show Less
  • qlik-community-blogs.jpg
    Qlik Support Updates Blog

    Latest Service Release on QlikView April 2019 Now Available

    Dear QlikView Users,   We are pleased to confirm that QlikView April 2019 Service Release 1 is now available on our download site. This release only contains a few product defect fixes, of which further details can be found in the attached release notes.   For those users currently running QlikView April 2019 IR (12.40), we'd like to specifically highlight the fix for QLIK-95577 ("General Script Error" when Binary reload a qvf").  ... Show More
    Dear QlikView Users,
     
    We are pleased to confirm that QlikView April 2019 Service Release 1 is now available on our download site. This release only contains a few product defect fixes, of which further details can be found in the attached release notes.
     
    For those users currently running QlikView April 2019 IR (12.40), we'd like to specifically highlight the fix for QLIK-95577 ("General Script Error" when Binary reload a qvf").  Under some circumstances, saving a document after a reload can result in an incorrectly persisted data format.  For more information on this bug and a possible workaround, if unable to upgrade, we encourage you to review QlikView April 2019: "General Script Error" when Binary reload a qvf

    As always when upgrading any software, make sure that you backup your system and applications before doing any installation and follow upgrading best practices. Thank you for choosing Qlik software.
     
    Kind regards
    The Global Support Team
    Show Less
  • Image Not found
    Qlik Support Updates Blog

    What does it mean to have a Qlik Account?

    Qlik Account is sometimes referred to as: username, Qlik ID, ULC, Single Sign On (SSO) Once registered for a Qlik Account, users automatically have access to Qlik Community, Qlik Sense Cloud, and Qlik Continuous Classroom (QCC). Customers and Partners can access the Support Portal and the full Downloads page. Partners can access the Partner Portal.   Am I a Customer? Customers are individuals or groups that have purchased Qlik and are entitl... Show More

    Qlik Account is sometimes referred to as: username, Qlik ID, ULC, Single Sign On (SSO)

    Once registered for a Qlik Account, users automatically have access to Qlik Community, Qlik Sense Cloud, and Qlik Continuous Classroom (QCC). Customers and Partners can access the Support Portal and the full Downloads page. Partners can access the Partner Portal.

     

    Am I a Customer?

    Customers are individuals or groups that have purchased Qlik and are entitled to support.

    Am I a Partner?

    Partners are individuals or groups that work with Qlik to sell and support our products.

     

    ***If you are a Customer or Partner and you are unable to access the Downloads page, Support Portal, or Partner Portal. First, try troubleshooting by clearing cache and refreshing your browser before logging in. You can also test in a private/incognito browser.

    If that doesn’t resolve your issue, please contact Customer Support via Live Chat or a case within the Support Portal.

     

    Related articles:

    How to Register for a Qlik Account - https://support.qlik.com/articles/000002823

    How to access the Qlik Support Portal - https://support.qlik.com/articles/000050443

    How to Access the Extended Download Page to Download Qlik Products - https://support.qlik.com/articles/000005292

     

    Thanks for reading and I hope this helps! Remember to like this post if you found it helpful. I will be posting bi-weekly, so look out for our next post on Monday July 8th, 2019.

     

    Join our Customer Success team for the Welcome to Qlik Webinar on Tuesday July 2nd, 2019.

    The Webinar is now posted on Community and open for registrations:
    https://community.qlik.com/t5/Community-Corner/quot-Welcome-to-Qlik-quot-Webinar-Tuesday-July-2-2019/m-p/1590102#M9878

    Another great resource for new users - https://help.qlik.com/onboarding

    Show Less
  • Image Not found
    Qlik Support Updates Blog

    Support Techspert Thursdays - Troubleshooting Images in Qlik NPrinting Reports

    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. Next Thursday, 11 July Qlik Support will host another Support Techspert Thursday session and this time we are looking at Troubleshooting Images in Qlik NPrinting Reports. But wait, what is it exactly? Support Techspert Thursdays is a free webi... 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.

    Next Thursday, 11 July Qlik Support will host another Support Techspert Thursday session and this time we are looking at Troubleshooting Images in Qlik NPrinting Reports.

    But wait, what is it exactly?

    Support Techspert Thursdays is a free webinar to facilitate knowledge sharing held on a monthly basis, on the third Thursday of each month. 

    Hear directly from Qlik Techsperts on topics that are relevant to Customers and Partners today.

    In this session we will cover:

    • How things work under the hood
    • Importing images from Qlik Sense
    • Resolving issues

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

    The webinar is hosted using ON24 in English and will last 30 minutes plus time for Q&A.

    Hope to see you there!!

    Show Less
  • qlik-community-blogs.jpg
    Qlik Support Updates Blog

    Qlik Sense June 2019 now available

    Hello all Qlik Sense users,   We are pleased to announce that Qlik Sense June 2019 (Build 13.32) is now available on the download site.  This build is a re-release of June 2019, where the originally reported degrade has now been resolved.   We thank you for your patience and apologize for any inconvenience this may have caused.    Remember when upgrading any software to always follow best practices and make your backups... Show More
    Hello all Qlik Sense users,
     
    We are pleased to announce that Qlik Sense June 2019 (Build 13.32) is now available on the download site.  This build is a re-release of June 2019, where the originally reported degrade has now been resolved.
     
    We thank you for your patience and apologize for any inconvenience this may have caused. 
     
    Remember when upgrading any software to always follow best practices and make your backups.
    As always, thank you for choosing Qlik software. 

    Kind Regards,
    Global Support Team
    Show Less
  • Image Not found
    Qlik Product Innovation Blog

    QlikView April 2019 Makes Strides Toward Uniting QlikView and Qlik Sense

    We are pleased to unveil QlikView April 2019, which you may recognize as being outside our typical QlikView release cadence. This release coordinates with the Qlik Sense release because the functionality included with QlikView April 2019 takes a major step in bringing QlikView and Qlik Sense closer together. Core to our strategy is to drive Qlik Sense adoption across the QlikView user base. Qlik Sense is an ideal end-to-end modern analytics platf... Show More

    We are pleased to unveil QlikView April 2019, which you may recognize as being outside our typical QlikView release cadence. This release coordinates with the Qlik Sense release because the functionality included with QlikView April 2019 takes a major step in bringing QlikView and Qlik Sense closer together.

    Core to our strategy is to drive Qlik Sense adoption across the QlikView user base. Qlik Sense is an ideal end-to-end modern analytics platform for QlikView users developing new applications and for new use cases.

    Dual-Use_Blurb.png

    The April 2019 release includes unified licensing, which gives each user a single key to access both QlikView and Qlik Sense, particularly valuable to those who have taken advantage of dual-use licensing. Unified licensing reduces license management challenges and improves compliance1. Furthermore, through compatibility with the Qlik Licensing Service, customers have an increased level of visibility into Qlik license usage. And, updates to the April 2019 Qlik Sense License Monitor give organizations better management across both products.

    This release also includes the ability to link-to QlikView apps through a common portal within Qlik Sense. Users of both solutions can simply access the Qlik Sense Multi-Cloud Hub and launch their QlikView app on a QlikView server.QV_Links_QS.pngQlikView Links within Qlik SenseFinally, April 2019 brings the introduction of a new App Profiler within the QlikView Governance Dashboard. The App Profiler answers questions about different QlikView app characteristics, so you can identify which would be the most viable candidates for migration to Qlik Sense. Answer questions about apps most-frequently used, complexity, and compatibility with Qlik Sense. You may also configure thresholds corresponding to the App Profiler’s findings.    QV_AppProfiler_Dashboar_dScreenshot.pngQlikView Governance Dashboard -- App Profiler

    Additional functional updates driving product unification are planned later in the year. You can download QlikView April 2019 here. Follow this blog for more information.

    1. You must be on QlikView April 2019 and Qlik Sense April 2019 releases or later to leverage unified licensing.
    Show Less
  • Image Not found
  • Image Not found
    Qlik Academic Program Blog

    Four essential soft skills for data-informed decision making

    Last month on thedataliteracyproject.org our Chief Learning Officer Kevin Hanegan talked about how having the best analysis tools isn’t enough on its own to ensure solid data-informed decision making. We also need to use a variety of hard and soft skills to help us to interpret the information and to make the best decisions. Data-informed decision-making is the ability to transform information into actionable and verified know... Show More

    Last month on thedataliteracyproject.org our Chief Learning Officer Kevin Hanegan talked about how having the best analysis tools isn’t enough on its own to ensure solid data-informed decision making. We also need to use a variety of hard and soft skills to help us to interpret the information and to make the best decisions.

    Data-informed decision-making is the ability to transform information into actionable and verified knowledge to ultimately make business decisions. And there is a concern that companies are not developing the hard skills and particularly the soft skills that are required to collect, transform and truly evaluate this information. If you can work on the four soft skills below, you will be well on your way to data-informed decision making success.

    1. Collaboration – Everyone will approach a decision from a different angle bringing different insights and knowledge, so it’s vital that we work with others to consider all aspects of the decision.
    2. Creativity and curiosity - Before you go ahead with a decision, you should first explore the reasons why your decision could possibly not work. This requires creativity and curiosity to come up with multiple scenarios and questions, in order to find the right solution.
    3. Critical thinking and self awareness - Bias often occurs subconsciously in our decision making as we are guided by our preferences, regardless of data to the contrary. We can reduce this bias by using the two soft skills above, and also by reflecting on our own personal views, and identifying if these are getting in the way of a decision.
    4. Analytical Storytelling - The process of bringing data to life to tell a well-constructed narrative. Communicating your insights to others in an effective way is a vital skill to ensure that you get the key messages from the data across.

    You can ready Kevin's full article here: https://thedataliteracyproject.org/posts/what-is-your-data-eq

    Alongside developing these soft skills, our Academic Program can also help you to improve your data informed decision making abilities, by getting you hands on with our industry leading analytics software, and giving you access to a wealth of training materials. The program is open to all University students and academic globally, and you can sign up today by visiting qlik.com/academicprogram.  

    Show Less
  • qlik-community-blogs.jpg
    Qlik Support Updates Blog

    Qlik Sense June 2019 temporarily removed from the download site

    Hello Qlik Sense users,   We have unfortunately decided to remove Qlik Sense June 2019 from the download site temporarily.  This is due to a significant degrade being identified where users experienced authentication issues when accessing the QMC or the Hub via a virtual proxy having a prefix.  Currently, what we observed is that if you connect to a virtual proxy with a prefix, the request will be forwarded to the virtual proxy wit... Show More
    Hello Qlik Sense users,
     
    We have unfortunately decided to remove Qlik Sense June 2019 from the download site temporarily.  This is due to a significant degrade being identified where users experienced authentication issues when accessing the QMC or the Hub via a virtual proxy having a prefix.  Currently, what we observed is that if you connect to a virtual proxy with a prefix, the request will be forwarded to the virtual proxy without the appropriate prefix.
     
    This issue is currently being addressed and a new release will be made available as soon as possible. 
     
    We sincerely apologize for any inconvenience and we will keep you updated on developments.
     
    Kind regards
    Global Support Team
    Show Less
  • qlik-community-blogs.jpg
    Qlik Product Innovation Blog

    Apply Custom Themes in Qlik Sense Cloud Business

    This month, we’re excited to announce a new customization feature for Qlik Sense Cloud Business users! You can now upload your own custom themes to your Qlik Sense Cloud Business workspace, and create and publish apps that reflect your own specific style requirements. For example, you can now apply a preferred color palette or your brand guidelines to apps.To create your own custom theme, you’ll need to compile a compressed zip folder with three ... Show More

    This month, we’re excited to announce a new customization feature for Qlik Sense Cloud Business users! You can now upload your own custom themes to your Qlik Sense Cloud Business workspace, and create and publish apps that reflect your own specific style requirements. For example, you can now apply a preferred color palette or your brand guidelines to apps.

    To create your own custom theme, you’ll need to compile a compressed zip folder with three key components:

    • A definition (QEXT) file
    • A main JSON file
    • Any additional assets that support the theme as needed (i.e. CSS files)

    Once you’ve created the folder, you can upload it to the new Themes section in the settings area of Qlik Sense Cloud Business. Once uploaded, the theme will then appear in the App Theme drop-down in the App Options menu. Don’t forget, you can also reference this list to apply any of the default themes available to all Qlik Sense Cloud users – Sense Classic, Sense Breeze, and Sense Focus.

    AddTheme.gif

    Curious about what Google and Super Mario themes look like in Qlik Sense? Watch the video below to see how Mike Tarallo uses those examples to highlight everything you need to know to set up custom themes.

    We’ve attached the Google theme files Mike uses in his demonstration to this blog so that you can try uploading custom themes on your own.

    Finally, check out some of the great resources below – including our online help documentation and other Qlik Community blogs – for more details on how to create custom themes.


    Can't see the video? YouTube blocked by your region or organization? Download the .mp4 attached to watch on your computer or mobile device.

    Show Less
  • Image Not found
    Qlik Design Blog

    What you should know before deploying Qlik Sense® Enterprise on Kubernetes

    The contents of this document are for informational purposes only and relates to installation and configuration of an initial test environment only. This document is expressly not part of Qlik Documentation, and Qlik makes no warranties or representations, or any obligations to update, with respect to the information contained herein. Partners are solely responsible to determine their own deployment processes with respect to production use of Qli... Show More

    The contents of this document are for informational purposes only and relates to installation and configuration of an initial test environment only. This document is expressly not part of Qlik Documentation, and Qlik makes no warranties or representations, or any obligations to update, with respect to the information contained herein. Partners are solely responsible to determine their own deployment processes with respect to production use of Qlik Sense Enterprise on Kubernetes.

    HAVE A QUESTION?

    Please use Source Link for Discussion - to provide your own thoughts, comments and questions so Jesús can respond to you directly.

    About Jesús Centeno:

    jesus.pngJesús Centeno is a Global Alliances Manager at Qlik with over 20 years of blended experience in Strategic Alliances, Business Development and Analytics/Data Management implementations. During the last few years at Qlik, Jesús has supported the launch of a new partner program focused towards Managed Services Providers.

    His professional background in end-to-end management of strategic partnerships with Tech companies and Global System Integrator partners expands across various industries. Prior to joining Qlik, Jesús worked for international organizations such as MicroStrategy, the International Monetary Fund (IMF) and Freddie Mac. Jesús has a BS degree in Mechanical Engineering from Tec de Monterrey University and an MBA in Finance and Logistics from University of Maryland.

     

     

    Show Less
  • qlik-community-blogs.jpg
    Qlik Design Blog

    Developer menu in Qlik Sense client

    Did you know there's a secret developer menu in Qlik Sense? I'm going to let you in on the secret and show you how to access it and what it contains. Just remember, this isn't documented or officially supported, and is subject to change in the future.To access the developer menu, follow the steps below:Open a sheet in a Qlik Sense app in your browserAdd /options/developer to the urlRight click on an object and choose "Developer"You can get the ob... Show More

    Did you know there's a secret developer menu in Qlik Sense? I'm going to let you in on the secret and show you how to access it and what it contains. Just remember, this isn't documented or officially supported, and is subject to change in the future.

    To access the developer menu, follow the steps below:

    1. Open a sheet in a Qlik Sense app in your browser
    2. Add /options/developer to the url
    3. Right click on an object and choose "Developer"

    3.png

    You can get the object id, properties, and layout of any object this way. There's also a link to open the object in single configurator, and test exporting. The object id's are useful for embedding visualizations. The properties are useful if you are creating your own objects and want to check the properties of an object in a Qlik Sense app for reference. In my opinion this is the most useful feature of the developer menu. Sometimes if I don't know the correct properties to set to achieve what I want I'll create a similar object in the Qlik Sense client just to check the properties. The layout shows what is returned by the engine for the layout of the object, and can be useful to see what the layout will look like before you actually create an object yourself. And the single configurator link is a handy way to get to the single configurator of an object directly from a sheet.

    4.png

    And now you know about the secret developer menu.

    Show Less
  • qlik-community-blogs.jpg
    Qlik Design Blog

    Average – Which average?

    If you want to display an average number of something in QlikView, you should use the Avg() function, right?   Wrong.   Yes, there is an Avg() function that returns the average value, but – this is usually not the value that you are looking for. The Avg() function returns the average transactional value, whereas you probably are looking for a larger amount.   For example, let’s say that you have an orders database where the grain -... Show More

    If you want to display an average number of something in QlikView, you should use the Avg() function, right?

     

    Wrong.

     

    Yes, there is an Avg() function that returns the average value, but – this is usually not the value that you are looking for. The Avg() function returns the average transactional value, whereas you probably are looking for a larger amount.

     

    For example, let’s say that you have an orders database where the grain - the most atomic level – of the data is Order Line. Each order can have several order lines and each order line has an amount. Then, the Avg() function will return the average order line amount, which is utterly uninteresting. No, you are most likely more interested in questions like “How much do we sell per month, on the average?”

     

    In other words – a calculation of an average has an implicit internal grouping entity; the average per month, per day, per order, per delivery or something else. You can look at it as a two-step aggregation:

     

    1. Sum all the amounts – per each value of the internal grouping entity (e.g. month, day, order or delivery)
    2. Calculate the average of the sums from previous bullet.

     

    In QlikView, you would calculate the average monthly sales value in one of the two following ways:

     

         Sum( Amount ) / Count( distinct MonthID )
         Avg( Aggr( Sum(Amount), MonthID ) )

     

    … and similarly for orders, days or deliveries. Use of the Aggr() function will work, but it is not as fast as the first option, and should therefore be avoided.

     

    Sometimes there are several internal grouping entities. You may for instance want to show the average monthly sales value per customer, i.e. you want to use both month and customer as grouping entity. Then you should use one of the following expressions:

     

         Sum( Amount ) / Count( distinct MonthID & '|' & CustomerID )
         Avg( Aggr( Sum(Amount), MonthID, CustomerID ) )

     

    The Count() aggregation with a string concatenation will find every unique combination of month and customer.

     

    Note that the internal grouping entity has nothing to do with the dimension you choose to use when you display it. It would make perfect sense to show the above number using Product as the only dimension, as shown in the graph below. Hence, the internal grouping entity is not necessarily visible in the end result.

     

    Average graph.png

     

    So, you need to figure out which internal grouping entity you want and then use this in a smart way in your expression.

     

    And by the way – an internal grouping entity can be used also for other aggregation functions: Smallest, largest, most common: Min(), Max(), Mode(). But for these, you will need to use the Aggr() function.

     

    HIC

    Show Less
  • qlik-community-blogs.jpg
    Qlik Design Blog

    Canonical Date

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

     

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

    Base model.png

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

    Logic 1.png

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

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

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

    Your data model will then look like this:

    Model with spec calendars.png

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

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

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

    Full model.png

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

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

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

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

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

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

     

    Bar chart.png

     

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

    Summary:

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

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

    HIC

    Show Less
  • qlik-community-blogs.jpg
    Qlik Design Blog

    A Primer on Set Analysis

    Set analysis is a way to define an aggregation scope different from current selection. Think of it as a way to define a conditional aggregation. The condition, however, is in itself like a selection that is evaluated before the cube (the chart) is expanded. Hence, it is not possible to have a condition that is evaluated row by row.   The set analysis is used inside an aggregation function, e.g. in an expression like      ... Show More

    Set analysis is a way to define an aggregation scope different from current selection. Think of it as a way to define a conditional aggregation. The condition, however, is in itself like a selection that is evaluated before the cube (the chart) is expanded. Hence, it is not possible to have a condition that is evaluated row by row.

     

    The set analysis is used inside an aggregation function, e.g. in an expression like

     

              Sum(Sales)

     

    The first step is to add the markers for the set analysis – the curly brackets:

     

              Sum( {…} Sales)

     

    These define the record set over which the aggregation should be made. Inside, you can use different identifiers and operators, e.g. ‘$’ for records implied by current selection, ‘1’ for all records, ‘1-$’ for all excluded records, etc.

     

    A set of records that you can define by a simple selection is called natural set. Not all record sets are natural; for instance, {1-$} cannot always be defined through a selection.

     

    The next step is often to add a set modifier, which is defined by angle brackets. The set modifier adds or changes a selection. It can be used on any natural set and consists of a list of fields, where each field can have a new selection:

     

              Sum( {$<…>} Sales)

     

    The next step is to define the element set for a field; the set of field values that defines the selection. The element set could be a field reference or a set function, P() or E(). It is more common, though, that it is an explicit list of field values or a search, and then you need the curly brackets to define the element set:

     

              Sum( {$<Date={…}>} Sales)   or   Sum( {$<Date=P(…)>} Sales)

     

    A search can be defined through double quotes. This way, field values that match the search string will be selected:

     

              Sum( {$<Date={"…"}>} Sales)

     

    Do not use single quotes to initiate a search here! Single quotes should denote literals, i.e. explicit field values. (Yes, today single quotes work as a search, but this is a bug that one day will be fixed…)

     

    Often a numeric search is made, defined by a leading relational operator. Then, field values will be selected based on a comparison:

     

              Sum( {$<Date={"<=…"}>} Sales)

     

    To make it worse, the value to which the field values are compared is often a calculated one. And in order to get a calculated value into the expression, a dollar expansion is needed.:

     

              Sum( {$<Date={"<=$(…)"}>} Sales)

     

    Inside the dollar expansion, you need an expression that starts with an equals sign and contains an aggregation function, e.g.:

     

              Sum( {$<Date={"<=$(=Max(Date))"}>} Sales)

     

    This aggregation function is evaluated globally, before the cube is expanded.

     

    As you can see, there are many levels of a set expression, and many pairs of brackets and delimiters that need to match. When you write set expressions, you should always write both brackets directly, and then continue with the expression between them. This way you will avoid simple syntax errors.

     

    Good luck with your set analysis expressions!

     

    HIC

     

    Further reading related to this topic:

    Why is it called Set Analysis?

    Dates in Set Analysis

    Excluding values in Set Analysis

    Introduction to Set Analysis (video) - Part 1

    Show Less