Skip to main content

Blogs

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

Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME 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.

Subprocessors List

Qlik Subprocessors General Data Protection Regulation (GDPR).

Japan

Qlik Community blogs for our customers and partners in Japan.

Recent Blog Posts

  • Image Not found

    Support Updates

    Qlik Customer Support Now Available on Stitch!

    Qlik Customer Support now available on Stitch! For our Stitch customers, Qlik Support is now seamlessly integrated within your product connecting you with expert assistance. Select the green chat bubble at the bottom right of your Stitch environment to start chatting with support.  With the introduction of our generative support chat, you can now receive immediate and reliable responses validated through Qlik’s expert-led documentation. If you ne... Show More

    Qlik Customer Support now available on Stitch!

    For our Stitch customers, Qlik Support is now seamlessly integrated within your product connecting you with expert assistance. Select the green chat bubble at the bottom right of your Stitch environment to start chatting with support. Katie_Davis_2-1728394388771.png

    With the introduction of our generative support chat, you can now receive immediate and reliable responses validated through Qlik’s expert-led documentation. If you need more in-depth help, our team of Support Engineers are available 24/5 to chat live and troubleshoot any issues you may encounter. This comprehensive support ensures you receive timely solutions, keeping your Qlik experience smooth and productive.

    Katie_Davis_0-1728394058253.png

    In addition to quick AI-generated answers, you’ll gain access to Qlik’s Customer Portal, to manage your support needs and explore a wealth of resources, including our library of knowledge articles. Stitch has the power of Qlik Global Support behind it, and we’re here to help you through your data journey.

    • For our Stitch-only customers without other Talend products in their data suite, a Qlik ID will need to be created to login to Qlik Customer Portal.
    • For those with both Stitch & Talend products, Talend customer accounts have been migrated to Qlik ID, and users should be able to access through their business emails. If you need help with access, please chat with our support engineers.

    Note: Now that Stitch support is fully integrated within Qlik Global support, stitchsupport@talend.com is no longer in use. Please leverage your in-product Support chat or contact us through the Customer Portal For Assistance.

    Show Less
  • Image Not found

    Qlik Education

    Welcome to the exciting world of Qlik Application Automation!

    Register now for our new course Qlik Application Automation and get 30% off (use code CLASSROOM30 at checkout)! 
  • Image Not found

    Product Innovation

    Seamless Public Data Sharing with Qlik's New Anonymous Access Capability

    As organizational accountability and transparency requirements grow, sharing data and analytics insights with the public is no longer just a "nice to have"—it’s a competitive advantage. For businesses, it helps build trust and showcase expertise. For governments and institutions, it fosters accountability and transparency. Today, Qlik launched a new capability that enables you to seamlessly and securely share public data with any visitor to your ... Show More

    As organizational accountability and transparency requirements grow, sharing data and analytics insights with the public is no longer just a "nice to have"—it’s a competitive advantage. For businesses, it helps build trust and showcase expertise. For governments and institutions, it fosters accountability and transparency. Today, Qlik launched a new capability that enables you to seamlessly and securely share public data with any visitor to your site or portal—without requiring them to log in to access apps, reports, or dashboards.

    Show Less
  • Image Not found

    Support Updates

    Qlik Customer Portal Launching July 15!

    The new home for your support needs and your gateway to unlock solutions.
  • Image Not found

    Support Updates

    Join Us Live! Q&A with Qlik: App Development

    November 5th at 09:00 EST / 15:00 CET
  • Image Not found

    Design

    Getting to know the new UI

    A look into some of the new features of Qlik Cloud's new UI.
  • Image Not found

    Qlik Academic Program

    New Data Literacy Qualification now available!

    Test you data literacy skills with our new Data Literacy Qualification, accessible to everyone with no expert level knowledge required! 
  • Image Not found

    Product Innovation

    Qlik Cloud Reporting's Perfect Update

    It’s been an exciting year for Qlik Cloud Reporting. Back in December 2023, we took a big step by adding tabular reporting to our dashboard-style capabilities, something many of you have been asking for. This update comes packed with features like report task management, easy imports of recipient lists from connected data sources, powerful filtering using bookmarks, and simple uploads for tabular report templates. Now, report developers can easil... Show More

    It’s been an exciting year for Qlik Cloud Reporting. Back in December 2023, we took a big step by adding tabular reporting to our dashboard-style capabilities, something many of you have been asking for. This update comes packed with features like report task management, easy imports of recipient lists from connected data sources, powerful filtering using bookmarks, and simple uploads for tabular report templates. Now, report developers can easily handle centralized tabular reporting tasks right inside Qlik Sense apps. Thanks to our incredible Qlik Cloud customers, we’re gearing up to roll out even more cool features!

    We’re putting the finishing touches on our cloud reporting capabilities for Q4:

    • Report Cycling: Developers can set up report tasks to cycle through a dimension, creating reports for each value.
    • Expanded Report Task Guardrails: With cycling reports, we’re increasing the task guardrails for production and batch processing to 500 reports.
    • Report Task History: Developers will have better visibility into past task runs with a new report task history feature that keeps track of up to three months of execution data. Plus, we’ll surface error and warning messages to help troubleshoot any issues.
    • PixelPerfect Authoring: We’re introducing a new template authoring feature for PixelPerfect reports! Create advanced document templates that meet strict customer or compliance needs using Qlik data, visualizations, or even a library of print-ready visuals.

    As BI leaders get ready for Qlik Answers, Qlik AutoML, and Qlik Talend Cloud, we know that having flexibility in report types and control over operations is key for keeping everyone in the loop.

    As we launch these new features, we’ll also be focusing on enhancing operational task controls, including email reporting solutions.

    Sign up for this webinar on October 17th to explore Qlik Cloud’s Reporting Evolution and get a sneak peek at everything it has to offer!

    Show Less
  • Image Not found

    Design

    Enhanced File Management

    A new file management system has been added to Qlik Cloud allowing users to create folders and subfolders for their data files. This hierarchical folder structure is available in your personal space, as well as shared, managed and data spaces. Now, I can add folders to a data space in my tenant and use folders to organize my files. This is extremely helpful when I have a project that has a lot of data files. There are two ways to add folders to a... Show More

    A new file management system has been added to Qlik Cloud allowing users to create folders and subfolders for their data files. This hierarchical folder structure is available in your personal space, as well as shared, managed and data spaces. Now, I can add folders to a data space in my tenant and use folders to organize my files. This is extremely helpful when I have a project that has a lot of data files.

    There are two ways to add folders to a space. The first is through Space details as seen in the image below.

    Space details.png

    After clicking on Space details, select Details. Then select Data files.

    data files.png

    From the screenshot below, I can use the icons at the top or click on the eclipse at the end of a folder row to:

    1. Upload files to a folder
    2. Add a folder
    3. Copy a folder
    4. Cut and paste a folder
    5. Delete a folder

    I can also use the icons and menu options to cut, copy and paste files and/or folders to somewhere else within the space or to another space. More than one file can be cut/copy/pasted by selecting the entire folder or by holding ctrl and selecting each file.

    files options.png

    The second way to add a folder to a space is via Administration > Content.

    content.png

    Let’s add one more folder to the CAJ space to see how it is done. To add a 2023 folder to the CAJ space, I will click on the Add folder icon and enter the name of the new folder. Be sure to confirm the path is correct. If not, select the correct path from the Path dropdown. Then click the Create button.

    add folder.pngOnce the folder is added, I can click on the eclipse for the 2023 folder and select Upload file to folder to upload files to this folder. If I used the Upload icon at the top, I would have to change the path to the 2023 folder before uploading my files.

    This enhancement also lets me create subfolders as seen in the image below. I have a Population folder in the Census folder.

    subfolders.png

    Now, let’s look at how we can load the data files in a Qlik Sense app using the folder structure. From the script editor in Qlik Sense, I can select the CAJ space and then click the Select data icon.

    connection.png

     

     

     

     

     

     

     

     

     

     

    I can see the folder structure I have set up and I can drill down into the folders to select the file I want to load.

    select file.png

     

     

     

     

     

     

     

     

     

     

     

    Notice that the file path in the script matches the hierarchical file structure I set up. This file structure can also be used when storing QVDs or inserting a QVS file.

     

    file path.png

     

     

    I love this new feature in Qlik Cloud. Sometimes I have the need to organize my files by their source or in the example I shared in this blog by the year of the project. This allows me to organize my data in a way that makes sense for development. To learn more about this enhanced file management feature, check out Qlik Help.

    Thanks,

    Jennell

     

    Show Less
  • Image Not found

    Design

    Straight Table

    The straight table, included in the Visualization bundle, has all the table properties that we are used to as well as many new features. These new features make it easier for developers to create a straight table and it gives users the ability to customize straight tables in the apps they view. The straight table is ideal when you want to provide detailed data – the raw data. While you do not want to have too many columns (ten or less columns are... Show More

    The straight table, included in the Visualization bundle, has all the table properties that we are used to as well as many new features. These new features make it easier for developers to create a straight table and it gives users the ability to customize straight tables in the apps they view. The straight table is ideal when you want to provide detailed data – the raw data. While you do not want to have too many columns (ten or less columns are ideal for the best performance), a straight table can have many columns (dimensions and measures).

    As previously mentioned, the straight table can be added to a sheet from the Qlik Visualization bundle. This means developers will need to open the advanced options to add the straight table to their sheet(s) and make edits. Once the straight table is added to a sheet, developers can add columns – either fields and master items or custom expressions. One of the new features that developers can take advantage of to build tables quickly is the ability to add more than one dimension and/or measure at once. Simply select the dimensions and measures you would like to add to the table and then click the Add button.

    fields and master items.png

     

     

     

     

     

     

     

     

     

     

     

    Once columns are added to the table, they can be dragged as needed to the desired position/order. Developers also can add alternate columns to the straight table. These columns can be dimensions and/or measures. These alternates columns will be available to users to customize the straight table if chart exploration is enabled. This is a great new feature because the user does not need edit permissions to modify the straight table. Users can add and/or remove columns based on their analysis. Being able to add columns as needed also improves performance since the straight table does not need to display all the columns, all the time. Loading the straight table with the minimum columns needed will decrease the load time.

    columns and alts 2.png                  exploration.png

    Chart exploration allows users, who are in analysis mode, to add and remove columns from the straight table they are viewing by checking or unchecking them in the Chart exploration panel (see image below). Any users viewing the sheet can customize the straight table. Users cannot see layout changes made by other users using the app, unless they opt to share the visualization or create a public bookmark with the layout saved.

    table with chart exploration.png

    Another new feature for developers is the ability to set the column width. By default, the column width is set to Auto, but developers can set it to Fix to content, Pixels or Percentage. Pagination is another new feature that can be enabled in a Straight table. With pagination, a specified number of rows are displayed at once and the user can navigate through the pages using arrows or selecting the page.

    column width.png

     

     

     

    pagination.png

     

    Many of the properties for the straight table are familiar but the new ones are moving the straight table to a new level. Learn everything you need to know about the straight table in Qlik Help and add one to your next app. Also check out the SaaS in 60 video for a quick video overview:

    Thanks,

    Jennell

     

     

     

     

     

    Show Less
  • Image Not found

    Support Updates

    New: Efficiently Manage Your Local Qlik Cloud Analytics Data Files with Enhanced...

    Experience the convenience of a smarter, more efficient file management system today! We have introduced our new Enhanced File Management feature in Qlik Cloud—making organization effortless. Now you can seamlessly structure your uploaded and cloud-generated files into directories and subdirectories, giving you full control over your data. With batch actions like move, copy, cut, and paste, managing multiple files has never been easier or faster.... Show More

    Experience the convenience of a smarter, more efficient file management system today!

    We have introduced our new Enhanced File Management feature in Qlik Cloud—making organization effortless. Now you can seamlessly structure your uploaded and cloud-generated files into directories and subdirectories, giving you full control over your data.

    With batch actions like move, copy, cut, and paste, managing multiple files has never been easier or faster. Streamline your workflow, reduce clutter, and stay organized with just a few clicks.

    Data Structure.png

    This feature has been rolled out in the following regions as per:

    • Oct 7th (Mon): SE+JP+UK - 14:00 CET/08:00 ET
    • Oct 9th (Wed): DE+SG+AP - 14:00 CET/08:00 ET
    • Oct 14th (Mon): US - 15:00 CET/09:00 ET
    • Oct 16th (Wed): EU 14:00 CET/08:00 ET 

     

    In this blog post we will cover:

     

    Where to access the folder structure

    The new features are accessible in your Data files menu for each space. 

    1. First, navigate to your Space and click Space Details
    2. Choose Data files

      space details and data files.png

    3. You'll now have access to additional options, such as creating, copying, or deleting folders

      create a new folder.png

    Create folder hierarchies and organize files into them

    Each space (Personal, Shared, Managed, and Data) in Qlik Cloud Analytics contains its own structure of folders organized in a hierarchical fashion. Data files can be organized in nested folder structures. For example, within your personal space, you might want to have separate folders for Order Data and Budget Data

    The location of a file or folder within a space is shown in its path. The path uses / symbols to represent when a folder is nested within other folders. 

    For example, suppose within your personal space, you have separate folders for Order Data and Budget Data. If you have a data file named Orders_2024_December.QVD in your Order Data folder, this file would be located in the following folder path within your personal space: 

    Personal/Order Data 

     

    Perform bulk operations on files and folders

    Files and folders can be moved to different spaces or locations within the same space. You can also move multiple items at a time using the Cut and Paste actions, either from the menu or through keyboard shortcuts (CTRL-C, CTRL-V, CTRL-X).

     

    Reference space folder structure in Sense app and script development 

    LOAD statements in the load script

    When you use files in spaces to add data to apps and scripts, the folder location in the space is referenced and required.

    Examples: Reference to file at the top-level path of a space

    This example loads the file orders.csv from a personal space. The file is not located within any specific folder but sits at the top-level path in the space.

    LOAD * FROM [lib://DataFiles/orders.csv]; 

    This example loads the file orders.csv from a shared, managed, or data space. The name of the space is TeamSharedSpace. The file is not located within any specific folder but sits at the top-level path in the space.

    LOAD * FROM [lib://TeamSharedSpace:DataFiles/orders.csv]; 

    Examples: References to specific folder path within a space

    This example loads the file orders_Europe.csv from the folder Orders By Region within a personal space.

    LOAD * FROM [lib://DataFiles/Orders By Region/orders_Europe.csv];

    This example loads the file orders_Europe.csv from the folder Orders By Region within a shared, managed, or data space. The name of the space is SalesSpace.

    LOAD * FROM [lib://SalesSpace:DataFiles/Orders By Region/orders_Europe.csv];

    Store statements

    When you add a Store statement to store data from a load script into Qlik Cloud Analytics, the folder location in the space is referenced and required.

    Example: Storing file at the top-level path of a space

    In this example, the entire table mytable is exported into Qlik Cloud Analytics as a file named myfile.qvd. The file is added to the shared space TeamSharedSpace. The file is not located within any specific folder but sits at the top-level path in the space.

    Store * from mytable into [lib://TeamSharedSpace:DataFiles/myfile.qvd];

    Example: Storing file to a specific folder path within a space

    In this example, the entire table mytable is exported into Qlik Cloud Analytics as a file named myfile.qvd. The file is added to the folder SalesData within the space TeamSharedSpace.

    Store * from mytable into [lib://TeamSharedSpace:DataFiles/SalesData/myfile.qvd];

    Inserting QVS code

    When inserting QVS code into a load script, the folder location in the space is referenced and required.

    Example: Referencing QVS file at the top-level path of a space

    In this example, the file test.qvs is referenced in the load script. The file is located in the space TeamSharedSpace. The file is not located within any specific folder but sits at the top-level path in the space.

    $(Must_Include=lib://TeamSharedSpace:DataFiles/test.qvs)

    Example: Referencing QVS file in a specific folder path within a space

    In this example, the file test.qvs is referenced in the load script. The file is located in the folder SalesData within the space TeamSharedSpace.

    $(Must_Include=lib://TeamSharedSpace:DataFiles/SalesData/test.qvs)

     

    Documentation

    The Qlik Cloud Documentation has been updated with comprehensive information about the new feature.

     

    Thank you for choosing Qlik,
    Qlik Support

    Show Less
  • Image Not found

    Support Updates

    Talend 7.3.1 Reaches End of Support

    Talend 7.3.1 Reaches End of Support   Talend version 7.3.1, released in February 2020, will reach the end of support on November 30, 2024, as detailed in the Talend Product Documentation. After this date, Talend version 8 will be the only regularly supported version of the Talend Platform.  What are the options for Talend 7.3.1 customers?  If you are currently using Talend version 7.3.1 in a mission-critical production environment, we encourage y... Show More

    Talend 7.3.1 Reaches End of Support  

    Talend version 7.3.1, released in February 2020, will reach the end of support on November 30, 2024, as detailed in the Talend Product Documentation. After this date, Talend version 8 will be the only regularly supported version of the Talend Platform. 

    What are the options for Talend 7.3.1 customers? 

    If you are currently using Talend version 7.3.1 in a mission-critical production environment, we encourage you to consider one of the following options:  

    • Transition to fully supported Talend 8 and purchase Talend 7.3.1 Limited Extended Support. We realize that you might need more time to migrate to Talend 8, so this option includes a limited Talend 7.3.1 support offering, covering one additional 13-month period ending December 31, 2025.  
    • Transition to fully supported Talend 8 only. Talend 8 includes many features and improvements that enhance your productivity and efficiency, not to mention that upgrading to a supported version helps ensure that your software stays relevant, secure, and usable for years to come. You can continue operating Talend 7.3.1, but it will not be supported by Qlik. 

     

    Note: Every active Talend subscription is entitled to a current Talend version 8 license. If you do not already have a Talend 8 license, please contact Qlik Customer Support via the customer portal to request one. Active subscriptions with renewal dates before December 30, 2025, can also buy the Talend 7.3.1 Limited Extended Support offer if needed. 

    Frequently Asked Questions 

    This knowledge article provides answers to the frequently asked questions that customers have posed about the End-of-Support for Talend 7.3.1.

    Next Steps 

    For renewal and purchase information, contact the following:

    • If you purchased Talend 7.3.1 from a Talend or Qlik Partner, please contact that Partner to discuss pricing and options.
    • If you purchased Talend 7.3.1 directly from Talend or Qlik, please contact your Qlik Talend representative directly or via email at sales@qlik.com.

     

    Finally, for all other upgrade and troubleshooting information, contact Qlik Customer support at https://customerportal.qlik.com/.

     

    Show Less
  • Image Not found

    Support Updates

    Service Release - QlikView May 2023 SR1

    QlikView May 2023 users can now upgrade to Service Release 1 (SR1) by logging into Qlik Community with their Qlik Account and visiting our downloads site to install the latest version.  This upgrade includes: Multiple resolved defects, such as fixes with drill-downs on calculated dimensions, and issues with quoting characters in CSV files, and more! Check out all the product upgrade details (including a list of fixes) in our Release Notes QlikV... Show More

    QlikView May 2023 users can now upgrade to Service Release 1 (SR1) by logging into Qlik Community with their Qlik Account and visiting our downloads site to install the latest version. 

    This upgrade includes:

    • Multiple resolved defects, such as fixes with drill-downs on calculated dimensions, and issues with quoting characters in CSV files, and more!

    Check out all the product upgrade details (including a list of fixes) in our Release Notes QlikView May 2023 SR1.

    Thanks for choosing Qlik!

    Qlik Global Support

     

    P.S. use the below filters to find the latest QlikView Service Release on our Download's site!

    download Qlikview.png

    Show Less
  • Image Not found

    Japan

    【開催報告】AI Reality Tour Tokyo

    10月2日、大手町三井ホールにて AI Reality Tour Tokyo を開催いたしました。その内容をご報告いたします。
  • Image Not found

    Support Updates

    Release Cadence Update: Qlik Sense Enterprise Client-Managed

    Beginning with the May 2024 release, Qlik Sense Enterprise Client-Managed will release two major releases a year (May and November).  This adjustment aligns our release cycle with the preferred cadence of our customers, enhancing communication around our major releases. Qlik continues to add new functionality to Qlik Sense Client-Managed versions following their initial release to the cloud.  As always, we will continue to deliver patches as need... Show More

    Beginning with the May 2024 release, Qlik Sense Enterprise Client-Managed will release two major releases a year (May and November). 

    This adjustment aligns our release cycle with the preferred cadence of our customers, enhancing communication around our major releases. Qlik continues to add new functionality to Qlik Sense Client-Managed versions following their initial release to the cloud.  As always, we will continue to deliver patches as needed under our Release Management Policy.  

    We look forward to helping you optimize your release experience. Be sure to follow the release notes area in Qlik Community and review our updated policy.

    Show Less
  • qlik-community-blogs.jpg

    Qlik Education

    Qlik Sense Qualification Exams - 2024 Update

    Qlik Education is pleased to announce the Business Analyst and Data Architect Qualification Exams have been updated!
  • Image Not found

    Support Updates

    Unlock Scalable, Secure and Effortless Public Data Sharing with Qlik Anonymous A...

    ​Imagine making Qlik content available to the public without requiring users to log in. And now imagine no more and get started with Qlik Anonymous Access, a feature we hope you are as excited about as we are. Qlik Anonymous Access will strengthen your community, drive engagement, and help you unlock the full potential of your public data. See our full Innovation blog here.   The Highlights Making data available to the public is one thing—making... Show More

    ​Imagine making Qlik content available to the public without requiring users to log in.

    And now imagine no more and get started with Qlik Anonymous Access, a feature we hope you are as excited about as we are. Qlik Anonymous Access will strengthen your community, drive engagement, and help you unlock the full potential of your public data.

    See our full Innovation blog here.

     

    The Highlights

    Making data available to the public is one thing—making it easy to access and consume is another. This is where Qlik’s Anonymous Access shines. By allowing users to interact with dashboards without a login, Qlik simplifies data access for a broad audience, allowing:

    • No Barriers to Entry: Any website visitor can navigate and explore interactive dashboards and reports without login

    • Inclusive Data Access: This simplifies access, ensuring that a broader audience, from policymakers to concerned citizens, can engage with the data.

    • Seamless Embedding: Qlik’s dashboards, apps, and sheets can be embedded into web portals, transforming static reports into interactive, easily navigable experiences.

    • Continuously up to date: Qlik Anonymous Access provides automatic refresh, keeping the information current.

    • Interactive Engagement: Dashboards allow users to filter, explore, and interact with data, fostering deeper understanding and insights.

    • Empowering Conversations: Encourages meaningful discussions by directly providing real-time, actionable insights through intuitive, dynamic tools.

    • Centralized Knowledge Hub: Embedding Qlik dashboards into internal and public portals creates a unified space for information and decision-making.

    • Security: The security feature, defaulted to "not allowed," prevents unauthorized public data sharing, enhancing security when sharing with anonymous users. To enable it, you must create a custom role, set the scope to "allowed," and assign it to authorized users or groups.

    • Enhanced Accessibility: The cloud allows users to access public data from anywhere, making it easier for communities and organizations to engage with the information.

     

    How to get started

    Anonymous Access is controlled at the app level. Users with the correct permissions can turn anonymous access on and off as needed. These users can also configure access code settings, as well as view and copy links and codes that provide anonymous access.

     

    Subscriptions and Offerings

    With a Qlik Anonymous Access subscription, you create an anonymous access tenant in Qlik Cloud. The cloud infrastructure is hosted and managed by Qlik. In an anonymous access tenant, the user experience is very similar to other Qlik Cloud subscriptions. The main differences are assignment of user entitlement by administrators, limitations on using certain add-on capabilities, and capacities for data loading and app development.

    See Qlik Anonymous Access subscriptions for details.

     

    Thank you for choosing Qlik,
    Qlik Support

    Show Less
  • Image Not found
  • qlik-community-blogs.jpg

    Design

    What does the TOTAL qualifier do?

    @What does the TOTAL qualifier do when used in a chart expression?  I have used TOTAL in an expression when I want to perform an aggregation across all dimensions.  For instance, if I need to show the percentage of employees in a specific office in a KPI object, I would use the TOTAL qualifier in an expression like this:I would sum the number of employees in the Paris office and divide that by the total number of employees across all offices.  In... Show More

    @What does the TOTAL qualifier do when used in a chart expression?  I have used TOTAL in an expression when I want to perform an aggregation across all dimensions.  For instance, if I need to show the percentage of employees in a specific office in a KPI object, I would use the TOTAL qualifier in an expression like this:

    expression1.png

    Paris.png

    I would sum the number of employees in the Paris office and divide that by the total number of employees across all offices.  In this expression, TOTAL disregards the dimension value (which is City in this case) and adds all employees.  Now if I make a selection in my app and select Paris, then my KPI would change to 100% because the total is based on the possible field values.  To get around this, I can add set analysis to the expression to look at the data before any selections were made.  The expression would look like the expression below and would remain 39% even if city selections are made.

    expression2.png

    I often use the TOTAL qualifier in KPI objects when I need to highlight a value but it can be used in any chart expression.  In the pivot table below, you can see how an expression value can differ with the use of TOTAL.

    pivot.png

    The TOTAL qualifier is useful when you want to see the shares of something similar to when you use a pie chart to see the percentage of parts that make up the whole.  In my case, it is helpful when I want to see the shares without making a selection first.  Henric Cronstrom wrote a great blog on The Aggregation Scope which talks about this topic is more detail.

    Thanks,

    Jennell

    Show Less
  • Image Not found

    Support Updates

    Upgrade advisory for Qlik Sense on-premise November 2024: Required add-on upgrad...

    Hello Qlik Admins and Developers, The next major Qlik Sense Enterprise on Windows release is scheduled for November 2024. The update will introduce changes that will have an impact on the following add-ons: Qlik Alerting (link) Qlik Sense Mobile client-managed (link) qlik-cli (link) Upgrade to v.2.25.0 or higher qlik/api (link) Upgrade to v1.12.0 or higher Qlik Sense .NET SDK (link) Upgrade to v16.8.0 or higher The changes affecting the add-ons... Show More

    Hello Qlik Admins and Developers,

    The next major Qlik Sense Enterprise on Windows release is scheduled for November 2024. The update will introduce changes that will have an impact on the following add-ons:

    • Qlik Alerting (link)
    • Qlik Sense Mobile client-managed (link)
    • qlik-cli (link) Upgrade to v.2.25.0 or higher
    • qlik/api (link) Upgrade to v1.12.0 or higher
    • Qlik Sense .NET SDK (link) Upgrade to v16.8.0 or higher

    The changes affecting the add-ons are:

    • Extended CSRF protection to Websocket requests
    • Adding support for CSRF to add-on products

    New versions of all affected add-ons will be available with the November 2024 release, and the associated Release Notes will provide detailed information on any improvements and changes.

    Please plan your upgrade accordingly to prevent interruptions:

    If you upgrade to Qlik Sense Enterprise on Windows November 2024, all listed add-ons must be upgraded as well. 

     

    Thank you for choosing Qlik,
    Qlik Support

     

    Show Less