29 February 2024 What’s New in Qlik Sense February 2024 for Business Users, Analytic Creators and Data Integrators Share this message This blog post provides Qlik Sense business users, analytic creators, and data integrators a summary of the features and improvements available in Qlik Sense Enterprise on Windows. Let’s get started with what’s new in Qlik Sense for February 2024. Visualizations and dashboards Data window functions in engine load script Customers can now perform complex calculations on their data tables in the Qlik load script to perform aggregation on different partitions without losing the granularity of their data. Many ML data preparation use cases commonly use this functionality in SQL. Window functions: Window – script function WRank – script function New pivot table The new Pivot table is here with a set of new features: Dimension headers Null value custom symbol, foreground and background color Grid styling with width and color Font styling for size, color and family for headers and cell contents Totals styling and placement options: above or below Column width options, set to auto, in pixels or with percentage Scrollbars outside chart Interactive sort of dimensions Qlik designed and added all of the above based on feedback from our users. Qlik launched the new Pivot table in the Visualization bundle, and it is set to replace the native pivot next year with the incorporation of additional features. Pivot table (Visualization bundle) Layout container The Layout container is a new component in the Dashboard bundle. In the Layout container, you can place charts in a freeform manner with or without a snapping grid. You can overlap and stack charts and control them with show conditions. The Layout container is highly versatile, but it is especially useful for: Grouping charts together Combining charts into new visualizations Creating composite KPIs Grouping and reusing user controls and buttons Creating aesthetic pleasing dashboards To get the most out the layout container, follow best practices, check out Bruno Calver’s talk at Techspert Visualization Day on Qlik Community. Layout container (Dashboard bundle) Layout container Styling Grid, Funnel & Sankey charts The new property panel for styling upgraded the Grid chart, Funnel chart, and Sankey chart. The styling includes general settings for title, subtitle, footnote, background, border and shadow and chart specific settings for axis and value labels. Grid chart (Visualization bundle) Funnel chart (Visualization bundle) Sankey chart (Visualization bundle) Filter pane styling The Filter pane now gets more properties for styling: General settings for title font styling, background, border and shadow. Chart specific styling for header and content font styling, color settings for selection state, background color and image. Filter pane Styling a filter pane Borders and shadows As of today, most charts receive settings for borders and shadows. While the border setting of charts inherits from the theme, you can now override and customize the border width and color settings per chart. Use the border wisely to achieve your goals, as it can significantly influence how your dashboard is perceived. Chart shadow is a new property on charts, providing a shadow contour around the chart, with options for size and color. Shadows create a depth effect and can highlight and make certain elements stand out. In the Layout container, where charts can overlap and be stacked, borders and shadows work very well. Customizing the borders and the shadows of visualizations Copy and paste style A new menu choice has been added, allowing you to copy style settings from one chart to another. This quality of life improvement makes it easier to style and work with charts. Especially now when all charts has many more styling settings. Applying custom styling to a visualization We hope that you’re just as excited about this new February 2024 release for Qlik Sense Business Users, Analytic Creators and Data Integrators as we are. If you need help upgrading or migrating, then do not hesitate to get in touch! Until next time! Additional resources Qlik Sense administrators should review the What’s New section in the Qlik Sense for Administrators documentation set. Path Currently there are no new features or changes in the Qlik Sense developers help for the February 2024 release. How can we help? Barry has over 20 years experience as a Data & Analytics architect, developer, trainer and author. He will gladly help you with any questions you may have. Call us Mail us 25 April 2024 Over 3000 Qlik Sense servers still vulnerable to Cactus ransomware In November of last year we reported on how two critical vulnerabilities in Qlik Sense Enterprise for Windows were exploited in the Cactus ransomware campaign. As of today, over 3000 vulnerable Qlik Sense servers remain connected to the Internet. New Release Qlik Vulnerability 29 March 2024 Dealing with missing and late arriving values with OtherSymbol and other solutions Learn effective strategies for handling missing or late-arriving dimension values in Qlik with our expert guide. Discover how to use OtherSymbol, WHERE NOT EXISTS, and other solutions to deal with early-arriving facts Data Model Friday Qlik Test Prep Qlik Solution 22 March 2024 Picking the right color palette for your visualization Discover how to choose the perfect color palette for your data visualizations with our expert guide. Learn about single, categorical, sequential, and diverging color palettes to enhance your charts and graphs. Ideal for data analysts and visualizers. Friday Qlik Test Prep Qlik SenseTheme Visualization
25 April 2024 Over 3000 Qlik Sense servers still vulnerable to Cactus ransomware In November of last year we reported on how two critical vulnerabilities in Qlik Sense Enterprise for Windows were exploited in the Cactus ransomware campaign. As of today, over 3000 vulnerable Qlik Sense servers remain connected to the Internet. New Release Qlik Vulnerability
29 March 2024 Dealing with missing and late arriving values with OtherSymbol and other solutions Learn effective strategies for handling missing or late-arriving dimension values in Qlik with our expert guide. Discover how to use OtherSymbol, WHERE NOT EXISTS, and other solutions to deal with early-arriving facts Data Model Friday Qlik Test Prep Qlik Solution
22 March 2024 Picking the right color palette for your visualization Discover how to choose the perfect color palette for your data visualizations with our expert guide. Learn about single, categorical, sequential, and diverging color palettes to enhance your charts and graphs. Ideal for data analysts and visualizers. Friday Qlik Test Prep Qlik SenseTheme Visualization