Skip to main content

Subscribe

Announcements
YOUR OPINION MATTERS! Please take the Qlik Experience survey you received via email. Survey ends June 14.
cancel
Showing results for 
Search instead for 
Did you mean: 

Analytics

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

Data Integration & Quality

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

Explore Qlik Gallery

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

Support

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

Events & Webinars

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

Groups

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

About Qlik Community

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

Blogs

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

Qlik Resources

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

Qlik Academic Program

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

Community Sitemap

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

Recent Blog Posts

  • Image Not found
    blog

    Product Innovation

    Qlik Introduces a New Era of Visualization

    Our ability to tell stories is an art form as old as language itself. From ancient cave paintings to oral traditions passed through generations, the e... Show More

    Our ability to tell stories is an art form as old as language itself. From ancient cave paintings to oral traditions passed through generations, the essence of stories has evolved alongside our communication methods. It began with visual tales etched on cave walls, transitioned into spoken narratives, and eventually found its way into written, printed, and typed forms.

    Ultimately, modern analytics and visualizations serve the same purpose as sharing and retelling stories: guiding business users to make important and informed decisions. These decisions, however, are not made alone, and require stories to persuade and engage others, often in boardrooms or video calls. But the goal of the story remains unchanged: to inspire action, instill confidence, and ensure safety.

    So, what happens in the next chapter?

    Today, Qlik is proud to announce a new era in data visualization and dashboard design. With the latest advancements in Qlik, you can bid farewell to the days of grappling with custom style sheets and juggling third-party add-ons. It's time to explore your creativity and take control of your narrative like never before!

    Chapters:

    1. The layout container adventure

    Picture this: designing beautiful dashboards that are not only interactive but also fun and easy. Say hello to the Layout container, your new-found playground for creativity. Stack objects, craft custom and composite KPIs, and toggle individual object visibility with ease. With multi-selection, grouping, and a plethora of styling tools at your fingertips, designing experiences just got a whole lot faster and more intuitive. Need inspiration? Dive into this vibrant dashboard crafted by Luis Felipe Tensini, Qlik Partner Ambassador, and prepare to be amazed.

    2. Charting new narratives & filter pane styling

    It's not just about data; it's about presentation. You now have the power to improve the way you tell your story. Control borders, shadows, fonts, and more to add depth and personality to your visualizations while maintaining your company's branding. Explore data effortlessly with customizable filter panes. From grid mode to compact views, from checkboxes to radio buttons, tailor your data display for a truly immersive user experience.
    3. Cyclic group dimensions delivered

    Cyclic groups for Master Item Dimensions—another QlikView legendary feature delivered. Allowing users to dynamically cycle through dimensions in every chart, maximizing the potential to tell stories while conserving screen space. With this innovation, charts become versatile tools, accommodating multiple use cases effortlessly. Crafting compelling narratives is simplified: select the Cyclic option in the master items library, choose desired fields, and effortlessly switch between them in your chart.
    4. A tale of dashboard themes…enhanced

    Plot twist!
    We've introduced enhancements, including new straight tables, pivot tables, line objects, and rich text objects. Take command of your space with the ability to control the visibility of the main selection toolbar and sheet header, freeing up valuable real estate for content and custom navigation bars.

    Cliff notes: Visualizations have undergone a remarkable makeover. You now have permission to evoke the freedom of creativity, captivate your audience, and transform data into insights like never before. The future with Qlik Cloud is bright!

    From ancient cave tales to today's dynamic dashboards, the evolution of storytelling parallels human communication methods. Innovation ushering in a future where every data point tells a tale waiting to be explored.

    Your adventure into the world of Visualizations & Dashboards does not stop here… continue your journey and check out the ‘What’s New: Qlik Showcase App’ or these new and improved stylish apps below and see for yourself!

    Executive Dashboard Showcase  

    dash2.jpg

    Marketing 360 Mashup Showcase

    dash.jpg

    In the grand scheme of things, Qlik’s evolution promises freedom, creativity, and limitless possibilities in data visualizations. The only limit is your imagination.

    Highlights:

    • Filter pane styling: styling options for the filter pane
    • Chart Border and Shadow: More control for app developer. Use it to create depth effect, enhance or hide the border. Perfect for layout container. Overrides the theme setting.
    • Layout Container: Freeform layout for grouping and stacking. New way to create content and design dashboards
    • Pivot Table: New pivot table and will replace native pivot in the future
    • Styling improvements: Grid, Funnel and Sankey chart is getting styling
    • Copy and paste style: Transfer styling settings from one chart to another
    • Cyclic master dimensions 


    Helpful Links:


    Inspiration from Qlik Community: 

    @tensini @jandrekillian 

    Show Less
  • Image Not found
    blog

    Design

    P&L Pivot Chart Extension

    Several years ago, I blogged about how I used IntervalMatch to create a profit and loss statement. Now that Qlik Sense has the P&L Pivot chart extensi... Show More

    Several years ago, I blogged about how I used IntervalMatch to create a profit and loss statement. Now that Qlik Sense has the P&L Pivot chart extension in the visualization bundle, I decided to test out the extension to see how it may help create a P&L report in Qlik Sense. This blog will review some of my findings and what was involved to create the P&L Pivot chart shown below.

     

    chart.png

     

    The P&L Pivot chart extension provides a lot of properties that allow you to change the style and coloring in the chart. You can find a complete list of the properties here in Qlik Help. The chart above uses one dimension and 6 measures but I could have used up to 9 measures with my single dimension or used 2 dimensions and up to 8 measures. After loading the data into Qlik Sense, my next step was to create a style template that I could use to handle the formatting of the chart.  Here is a snapshot of the template in Excel:

     

    template.png

     

    I added a header row so that I could easily see what options I could set but it is not required and can be omitted. In the styling template, Column A should include the data that is in the first dimension of the chart you will be applying the template to. Note that this data is case sensitive.  The other columns have the various styles that can be modified via the template.

     

    Here is an example of the same template in a CSV file.

     

    csv.png

     

    If a template is used, it needs to be loaded via the script. Here is how you can load the Excel and CSV versions of the templates:

     

    Excel:

     

    excel script.png

     

    CSV:

     

    csv script.png

     

    The key in both scripts is that the entire template needs to be loaded into one field which can later be selected from the Style template field drop down in the Properties window of the P&L Pivot chart. In the Excel script, the styles are concatenated into one field separated by semi-colons. In the CSV file, the file format is set to Fixed record to load all the data into one field. Note that the name that you give the field in the script will be the template name you select from the Style template field drop down.

     

    Each row of the template should have this format:

     

    DimensionValue;Bold;Background;FontStyle;TextColor;Align;FontSize;Comment

     

    • DimensionValue is the data value of the dimension in the row that you would like the change
    • Bold is used to bold the text in a row
    • Background is used to set the background color of a row
    • FontStyle is used to change the font style of a row to italic or oblique
    • TextColor is used to change the default black font color of a row to white
    • Align is used to set the alignment to center
    • FontSize is used to change the font size of a row
    • Comment is used to replace all zeros with a space

     

    Check Qlik Help to see the default and styling options that are available in the styling template.

     

    There are many additional properties that can be set in the properties window of the P&L Pivot chart extension. I kept many of the defaults but here are some that I changed. In the Table Format section of the Properties, I checked Indent to indent the P&L Heading. The columns can be narrow so I moved the Column width slider all the way to the right, (for max width), and changed the Font family so that I could see as much of the numeric values in the chart as possible. I tweaked the header coloring in the Header format section. I opted not to color variances below 0% red because then I would lose some of my styling template changes. While I used a styling template in my example, you do not have to. The P&L Pivot chart extension can be styled via the Properties window without using a template.

     

    The P&L Pivot chart extension provides a ton of styling options that can be used to easily make your profit and loss statement looks exactly the way you want. It is worth checking out or you can watch this video to learn more.

     

    Thanks,

    Jennell

    Show Less
  • Image Not found
    blog

    Product Innovation

    Connector Factory - May and June 2024 releases

      Qlik Data Integration Additional SaaS application connectors We’re continuing to expand the connectivity of Qlik Cloud Data Integration with the ad... Show More

     

    Qlik Data Integration

    Additional SaaS application connectors

    We’re continuing to expand the connectivity of Qlik Cloud Data Integration with the addition of three more business applications that can now be used as a data source.  By eliminating the need for custom connectors to access these sources, Data Engineer productivity is increased and Data Consumer’s time to insight is decreased. The new connectors are for:

    1. Anaplan, which provides business planning software
    2. Oracle Fusion, a suite of applications built on Oracle Cloud
    3. Oracle Fusion Project Management, which is used to manage project deliveries.

     

    Qlik Replicate

    The May 2024 release of Qlik Replicate delivered a number of improvements related to connectivity with Snowflake, Databricks, SAP, AWS and Microsoft Azure.  You can find out more about these enhancement in this blog.

     

    Qlik Data Analytics

    Updated DynamoDB Connector

    This connector has been updated to be based on ODBC instead of JBDC.  The Qlik DynamoDB connector now also supports authentication using AWS IAM credentials (access key & secret key) or a credentials file.  Note that the previous JDBC-based Qlik DynamoDB connector will continue to be supported until the end of July 2024.

    Learn more about the DynamoDB connector.

     

    New version of Direct Access gateway

    The Qlik Data Gateway - Direct Access allows Qlik Sense SaaS applications to securely access behind-the-firewall data, over a strictly outbound, encrypted, and mutually authenticated connection.

    In May, we released Direct Access gateway 1.6.6 which introduced the following enhancements and new functionality:

    • Support for accessing ServiceNow via the Direct Access gateway
    • Support for Azure Active Directory authentication when using the Azure Synapse Analytics and Azure SQL Database Connectors.
    • Support for Azure OAuth authentication when using the Azure Synapse Analytics, Azure SQL Database and Databricks Connectors.
    • Support for OAuth authentication when using the Snowflake Connector
    • Support for SCRAM-SHA-256 and LDAP authentication when using the MongoDB Connector
    • Enhanced metadata paging when working with ODBC connectors
    • Additional logging to improved supportability

    You can learn more about the Gateway here.

     

    Qlik Application Automation

    Sharing Automation Connections

    Users can now create and manage automation connections in shared spaces.  You can find out more about this new capability in this blog.

    Show Less
  • Image Not found
    blog

    Japan

    【7/10(水)14:00 開催】SAP データ活用の課題解決 Web セミナー

    生成 AI の業務への組み込みは、DX のさらなる推進という従来からの取り組みと共に、多くの企業での喫緊の課題となっています。そしてその根幹にあるのはデータ活用であることは言うまでもありません。 その中でも生産・流通・財務・人事など主要業務システムの根幹でもある SAP データの活用は多くの企業が望... Show More

    生成 AI の業務への組み込みは、DX のさらなる推進という従来からの取り組みと共に、多くの企業での喫緊の課題となっています。そしてその根幹にあるのはデータ活用であることは言うまでもありません。

    その中でも生産・流通・財務・人事など主要業務システムの根幹でもある SAP データの活用は多くの企業が望んでいます。Qlik は、これまでに数多くの SAP ユーザー様との対話を重ね、SAP データ活用の課題の理解に努め、さまざまな解決策をご提案してまいりました。

    本 Web セミナーではこれらを集大成し、SAP ユーザーの皆さまが抱える課題を整理し、最適なソリューションと顧客事例をご紹介します。SAP の運用に関わる方だけでなく、SAP データをさらに活用したいビジネスユーザーの方、SAP の投資効果を高めたい経営部門のご参加をお待ちしています。

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

    今すぐ申し込む

    【開催概要】
    日時:2024年 7月 10日(水)14:00 - 15:00
    会場:オンライン
    参加費:無料

    スクリーンショット 2024-06-12 170449.png

    今すぐ申し込む

    Show Less
  • Image Not found
    blog

    Support Updates

    Entitlement Analyzer for Qlik Sense Enterprise SaaS (Cloud only)

    We are happy to share with you the new Entitlement Analyzer for Qlik Sense Enterprise SaaS! This application will enable you to answer questions like:... Show More

    We are happy to share with you the new Entitlement Analyzer for Qlik Sense Enterprise SaaS! This application will enable you to answer questions like: 

    • 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? 

    Entitlement Analyzer.png

    The Entitlement Analyzer is only available for Qlik Cloud subscription types. Refer to the compatibility matrix within the Qlik Cloud Monitoring Apps repository for an overview of which monitoring app is compatible with which subscription type.

    The Entitlement Analyzer app provides insights on: 

    • Entitlement usage overview across the Tenant 
    • Analyzer Capacity – Detailed usage data and a predication if you have enough 
    • How users are using the system and if they have the right Entitlement assigned to them 
    • 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 are available via GitHub, linked below. 

     

    Any issues, questions, and enhancement requests should be opened on the Issues page within the app’s GitHub repository.

    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 Platform Architects

     

    Additional Resources:

    Our other monitoring apps for Qlik Cloud can be found below.

    Show Less
  • qlik-blogssubscribe.jpg
    blog

    Community News

    Welcome Talend Members!

    Welcome Talend Community members to the Qlik Community! We are so DELIGHTED to have you be a part of the Qlik family and Qlik Community! Our Community... Show More

    Welcome Talend Community members to the Qlik Community!

    We are so DELIGHTED to have you be a part of the Qlik family and Qlik Community! Our Community is a place to ask questions, find solutions, engage with other members and employees, and so much more. We would like to take this time to show you around and help you acclimate to your new surroundings.

    Before we start showing you the ropes, a very important note:

    YOUR ACTION IS REQUIRED!

    Please register (click 'Sign Up' underneath the login form) for the Qlik Community by creating a Qlik Account. You MUST use the same email address used to register on the Talend Community. This will ensure your activity from the Talend Community persists within the Qlik Community.

    If you do not remember the email address you signed up with or do not see your previous activity, please reach out to qlikcommunityadmins@qlik.com.

    If you are a member of both Communities, your accounts should merge into one. If this is not what you experienced, please reach out to qlikcommunityadmins@qlik.com.

     

    Participating in the Discussions

    The Talend forums can be found by going to Forums > Data Integration. Here you will find a section called, ‘Formerly Talend’. The board names have remained the same to ensure a seamless experience. All posts have been brought over, as well as any attachments, embedded links, and likes (kudos).

     Forums.gif

    Searching the Knowledgebase

    Members of the Support and Digital Experience team have been hard at work, combing through the Talend articles checking validity and updating the content to ensure the latest and greatest information is at your fingertips. About 900 articles are available in the Community, with more on the way!

    The articles can be found under Support > Knowledge > Official Support Articles.

    Official Support Articles.gif

    Use the search bar to find articles using key terms, phrases, error messages, etc. 

    Jamie_Gregory_0-1706039345116.png

    Filter the results using the facets on the left of the search results. Filter by 'Product' or 'Labels by Topic' to find what you are looking for.

    Jamie_Gregory_1-1706039553177.png

    The remaining articles will be added within the next couple of weeks. If there is anything you need and do not see, please let us know. Also in the coming weeks, redirects will be added to accommodate any saved bookmarks. 

     

    Creating Support Cases

    Combining the two Communities is one amazing step towards integrating the two companies. The Support Portals will remain separate for the time being, which requires Authorized Support Contacts to continue to use the Talend Support portal to create cases.

    Existing articles can still be found in the Support portal; however, they will only be maintained in the Qlik Community.

     

    Viewing My Profile

    All members that have logged in since January of 2019, were brought into the Qlik Community. Please note: if you registered for the Talend Community on or after January 11, 2024, your user will not be in the Qlik Community.

    To get to your profile, click on the avatar in the top right corner and click “My Profile”.

    My profile.gif

     

    The profile will display any recent conversations you participated in and show your current rank plus any badges earned. It will also display stats such as the number of posts, solutions accepted, likes given and likes received.

    Your rank will replace the points you earned in the Talend Community. The more active you are, the higher the rank you will achieve. Learn more about ranks in the Qlik Community here.

    Badges earned have been replaced with the Qlik Community badges. The two systems were very similar with badging, so you should mostly see the same badges.

    Please note: badges will not appear on your profile until you log into the Qlik Community.

     

    Learn more about Qlik Community

    Here are some helpful resources to learn more about Qlik Community:

    For more useful content about Qlik Community, see Get Started and Suzy’s Tips.

     

    Where to ask questions about Qlik Community

    We know this is a big change, but we hope an exciting one! If you should have any questions about Qlik Community, please do not hesitate to reach out to us. You can find us at the Water Cooler.

     

    This is a lot of information all at once so please let us know in the comments below or in the Water Cooler what questions you have. We are here to help you through this transition.

    Welcome again, we are thrilled to have you here!

    Your Qlik Community Admins,

    Melissa, Sue, Jamie, and Nicole

    @Melissa_Potvin @Sue_Macaluso @Jamie_Gregory @nicole_ulloa 

     

    Show Less
  • Image Not found
    blog

    Support Updates

    Talend Login Credentials Moving to Qlik Unified Login This May

    Update May 15th 2024: Moved the dates back by one week. As part of Qlik’s ongoing effort to unify our presence with Talend offerings, we are moving Ta... Show More

    Update May 15th 2024: Moved the dates back by one week.

    As part of Qlik’s ongoing effort to unify our presence with Talend offerings, we are moving Talend login credentials to use the same authentication mechanism as other Qlik web properties. This will improve our overall customer experience and provide Talend customers greater access to data integration, quality, and analytics capabilities.

    Starting May 21, 2024, the login mechanism for Talend Cloud customers will change to use the Qlik Account authentication infrastructure. This is not a forced migration to using Qlik Cloud applications or services; no other infrastructure is changing. Existing Talend Cloud login credentials will switch to a new authentication provider.

    Review our most frequently asked questions below:

    What is Qlik Account?

    Qlik Account helps users access multiple Qlik services using one set of credentials. Once registered Qlik customers and partners can access their Qlik Cloud applications, Talend Cloud, Support Portal, and the Downloads page. Users can also access Qlik Community and Qlik Continuous Classroom (QCC). Additionally, partners can use their Qlik Account to access the Partner Portal.

    When will the conversion take place?
    The migration timing depends on your geographic region as follows
    • May 21th – Asia Pacific, including Australia and Japan
    • May 23th – Europe
    • TBD – Americas
     
    Do I need to take any proactive action?

    No, but you can create a Qlik Account before the conversion dates.

    Note: You must use the email address listed in your Talend Cloud profile when creating your Qlik Account. Do not use your Login Name.

    2024-05-27_11-56-03.png

    What happens during the conversion process?

    The following video explains the process of moving to a Qlik Account, referred to as Qlik ID.


    Can I create and use a Qlik Account before May 14th?

    Yes. Follow this link for instructions on creating your Qlik Account.

    Note: If you create a Qlik Account before May 14th, then you must use the same email address listed in your Talend Cloud profile (see Figure 1.) and not your Login Name.

    Katie_Davis_0-1714075406082.png

    Figure 1. Talend Cloud Profile

    2024-05-27_11-56-03.png

    Figure 1a. Use your Email address, not the Login Name

     

    What if I have multiple Talend Cloud tenants?

    A web page displaying your currently active Qlik Cloud and Talend Cloud tenants will be displayed after a successful login. You can then navigate to a specific tenant by clicking on the appropriate tile (see Figure 2.)

    Katie_Davis_2-1714075711836.png

    Figure 2.  Tenant Selection Page
    What if I have multiple Talend Cloud tenants and one or more of them doesn't appear on the multiple tenants web page?

    Synchronization to populate your tenants list can take from ten seconds to a couple of minutes. If the web page doesn't populate your tenants list, the synchronization process will run again after two hours.

    Another reason why all tenants may not appear in the list is a "region" query string parameter has been added to the URL. Simply remove the region parameter and the value, refresh the page, and the full list of tenants will appear.

    What if I receive the No Tenants to manage page?

    If you see this page after completing the migration (see Figure 3,) the synchronization process may not have completed or you may have a mismatch between your Qlik Account email and your Talend Cloud tenant email. 

    Jeffrey_Goldberg_0-1716590867912.png

    Figure 3.  No Tenants to Manage Page

    You can fix the email mismatch by using the Talend Legacy Login link. You will be redirected to the old Talend login page. Follow these steps:

    1. In your browser, navigate to https://iam.<region>.cloud.talend.com/idp/login?legacy=true where
    "<region>" is the region your Talend Cloud tenant resides.

    2. Authenticate to your tenant with your Talend userId and password.

    3. Click on your name in the right side of the Talend toolbar.

    4. Select Profile preferences from the menu.

    5. In the Email field, update the email address to match your Qlik Account email address.

    6. Save your profile.

    7. Logout of the Talend tenant and navigate to the Qlik Cloud login page at https://login.qlik.com.

    8. Log into Qlik Cloud using your Qlik Account.

    What if I change my email address in my Talend tenant to something different from my Qlik Account?

    You will not be able to access your Talend tenant if the email address for your user profile in the tenant doesn't match your Qlik Account email address.

    What if I already have a Qlik Account?

    Great! No further action is required.

    What if I use single sign-on (SSO) to log in?

    Single sign-on functionality is not changing and you do not have to switch authentication providers. Access the updated sign-in page directly by entering https://iam.<region>.cloud.talend.com/idp/login-sso where <region> is the location of your Talend Cloud tenant. When you see this page, confirm your Talend Cloud region and enter the email you use to access Talend Cloud through your single sign-on provider.2024-06-13_05-27-57.png

    When you press next you will be redirected to your identity provider authentication process.

    Do I need to recreate any bookmarks?

    No. Your existing bookmarked pages should redirect to use the new login mechanism.

    What is the Qlik Account login page URL?

    To access the new Qlik Cloud login page visit https://login.qlik.com

    Can I keep using the legacy login instead of Qlik Cloud login?

    The legacy login is available for a limited time to help users resolve email mismatches between Talend tenants and Qlik Account. Qlik reserves the right to deprecate this URL at any time with limited notice.

    Who do I contact if I experience login difficulties?

    If you experience login difficulties, then contact us at the customercare@talend.com

     

    If you have additional questions, comment below!

    Show Less
  • Image Not found
    blog

    Design

    Quick and Easy Dashboard Makeover

    The Original Let’s face it, the original dashboard was boring. It was just a plain, functional dashboard with no “Wow“ factor. My goal for this makeov... Show More

    The Original

    Let’s face it, the original dashboard was boring. It was just a plain, functional dashboard with no “Wow“ factor. My goal for this makeover was to add some character to the dashboard.

    MattSmart_15-1717793579614.png

     

      

     

    Step 1: Find a color palette

    The color palette that I decided on was on the green scale. Here are the colors that I used:

    Sheet Background: #3d6666

    Chart Background: #578080

    Font color: #ffffff

     

    Step 2: Change the sheet background color

    • In Edit Sheet mode, click on the sheet background to open up the Sheet Properties panel
    • Select Styling from the Sheet Properties panel

    MattSmart_16-1717793579614.png

     

    • Toggle off the Background – Auto icon to show Custom

    MattSmart_17-1717793579614.png

     

    • Select the Background color dropdown and enter the hex code that you would like to use

    MattSmart_18-1717793579615.png

     

     

     

    MattSmart_19-1717793579620.png

     

     

    Step 3 – Chart Styling

    Much of the work is done this section. The way I approached this was to style one chart and then use the copy/paste style function to bring the other charts to life with the new chart properties.

    Note: When copy and pasting styles between chart types, there may be some additional editing needed to update all the chart characteristics. I started with the Profitability by Clinician bar chart.

    • First, we need to change the bars to white by selecting it in the Properties Panel > Colors and Legends

    MattSmart_20-1717793579621.png

     

    • Next, we need to edit the other chart properties by opening the Styling Properties

    MattSmart_21-1717793579621.png

     

     

    • We make the changes in the General section first.
      • Change the text color of the Title, Subtitle, and Footnote: #ffffff
      • Change the background color to our new chart background color:  #578080
      • Change the color of the border to the sheet background color: #3d6666
      • Change the corner radius to 7px
      • Change the shadow to medium

    MattSmart_22-1717793579623.png

     

     

     

    • We now need to make the same changes to the Chart section

                   

    MattSmart_23-1717793579623.png

     

    • Change the text color of the Axis Title, Axis Label,  Value Label, Legend Title, Legend Label to #ffffff

    MattSmart_24-1717793579624.png

     

     

    • Here is our new chart after the changes:

    MattSmart_25-1717793579625.png

     

     

    • Next we need to copy/paste the new style to all of the charts by right clicking on the chart and selecting Copy Style.

    MattSmart_26-1717793579627.png

     

    • Next, we right click on the chart where we want to paste the style and select Paste style

    MattSmart_27-1717793579629.png

     

    • Once we update the characteristics of each chart, we will add grid containers to help us to layout each section of the dashboard and add in the corresponding charts to each section.

    MattSmart_28-1717793579632.png

     

     

    After all of the visualizations are added to the grid containers, we now have a new and improved dashboard.

    MattSmart_29-1717793579638.png

     

    Summary: With just some small changes to our color scheme and chart properties, we were able to completely transform our dashboard. With all the new features, chart types, and chart properties available to the Qlik Sense developer,  the only limit to customizing a Qlik Sense app is your own imagination.  

    Show Less
  • Image Not found
    blog

    Support Updates

    QlikView - New Security Patches Available Now

    Update 21st of March 16:00 CET: published CVE numberUpdate 27th of March 10:45 CET: added FAQ Hello Qlik Users, A security issue in QlikView has been ... Show More

    Update 21st of March 16:00 CET: published CVE number
    Update 27th of March 10:45 CET: added FAQ

    Hello Qlik Users,

    A security issue in QlikView has been identified and patches have been made available. Details can be found in the Security Bulletin High Severity Security fix for QlikView (CVE-2024-29863).

    Today, 20th of March 2024, we have released two service releases across the latest versions of QlikView to patch the reported issue. All versions of QlikView prior to and including the releases below are impacted:

    • QlikView May 2023 SR1 (12.80.20100)
    • QlikView May 2022 SR2 (12.70.20200)

     

    Call to Action

    As no workarounds can be provided, Customers should upgrade QlikView to one of the following versions that contain the fix:

    • QlikView May 2023 SR2 (12.80.20200)
    • QlikView May 2022 SR3 (12.70.20300)
    This issue only impacts QlikView. Other Qlik data analytics products including Qlik Cloud and Qlik Sense Enterprise on Windows are not impacted.

    Additional Details


    The Security Notice label is used to notify customers about security patches and upgrades that require a customer’s action. Please subscribe to the ‘Security Notice’ label to be notified of future updates. 

    Frequently Asked Questions

    Q: Is the vulnerability present in the QlikView Plugin or other QlikView products? 
    A: The vulnerability is related to the MSI files on disk.

    Q: Will deleting the MSI files mitigate the issue?
    A: Qlik does not consider removing the MSI files a complete workaround. A server user can restore them.

    Show Less
  • qlik-blogssubscribe.jpg
    blog

    Design

    User.Environment.What?! - Session Attributes in Qlik Sense

    Today - Jeff Goldberg is back and will introduce us to using session attributes to pass security and other information to a Qlik Sense session.Introdu... Show More

    Today - Jeff Goldberg is back and will introduce us to using session attributes to pass security and other information to a Qlik Sense session.


    Introduction

    Did you know with Qlik Sense security rules, it's possible to use attributes delivered to Qlik Sense Enterprise during the authentication process?  Yup, it's true. While the conventional approach to using attributes is to import them using a User Directory Connector, session attributes are a flexible alternative to storing attributes in the repository to control capabilities and authorization in Qlik Sense Enterprise.

    Qlik Sense supports session attributes through SAML, ticketing, and session authentication schemes.  Session attributes are attributes sent in the request for access to the Qlik Sense server.  The attributes are not stored in the repository, but in the user's Qlik Sense session.  Session attributes can be referenced in security rules using the user.environment (e.g. user.environment.attributename) syntax.  In addition, if there is an attribute named group sent to Qlik Sense using SAML, ticketing, or session, it can be used in Section Access data reduction.

    Session Attributes in SAML

    When you setup a SAML virtual proxy in Qlik Sense, there is an additional attributes section where you can add attribute names from the saml response sent by the identity provider, and the name you want to use in Qlik Sense.  Here you can see I have a SAML integration with Okta.  I have an additional attribute that comes in from Okta named Groups.  In Qlik Sense I have it use the name group.  The name on the left must match what is sent by the idp.  The name on the right can be whatever you want it to be.

    jeff1.png

    How do you identify the names of the attributes contained in the SAML response?  I use SAML Message Decoder chrome extension.  It's a great tool for reading through the messages sent to an IDP and sent to the Qlik Sense server.

    jeff2.png

    <?xml version="1.0" encoding="UTF-8"?>

    <saml2p:Response xmlns:saml2p="urn:oasis:names:tc:SAML:2.0:protocol"

            Destination="https://gss.qlikpoc.com:443/okta/samlauthn/"

            ID="id1026813850591869499238360"

            InResponseTo="_583b079d-39d2-44ab-9824-1336e628770e"

            IssueInstant="2016-12-13T14:03:23.898Z"

            Version="2.0"

            xmlns:xs="http://www.w3.org/2001/XMLSchema">

    <...>

        <saml2 :AttributeStatement xmlns:saml2="urn:oasis:names:tc:SAML:2.0:assertion">

          <saml2 :Attribute Name="email"

                 NameFormat="urn:oasis:names:tc:SAML:2.0:attrname-format:unspecified">

            <saml2 :AttributeValue xmlns:xs="http://www.w3.org/2001/XMLSchema"

                   xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"

                   xsi:type="xs:string">goldbergjeffrey@yahoo.com</saml2:AttributeValue>

          </saml2:Attribute>

              <saml2 :Attribute Name="groups" NameFormat="urn:oasis:names:tc:SAML:2.0:attrname-format:unspecified">

              <saml2 :AttributeValue xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"

    xsi:type="xs:string">QlikGroup</saml2:AttributeValue>

              <saml2 :AttributeValue xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"

    xsi:type="xs:string">Everyone</saml2:AttributeValue>

            </saml2:Attribute>

        </saml2:AttributeStatement>

    </saml2p:Response>

    In Qlik Sense, I've created a stream for members of the QlikGroup group to access in the Qlik Sense Hub. The security rule I put in place uses the user.environment.group attribute and evaluates it against the QlikGroup group value.

    jeff3.png

    When I log into Qlik Sense,  you see that I have access to the stream I created because in my SAML response I am a member of the QlikGroup group.

    jeff4.png

    Session Attributes in Ticketing and Session

    When ticketing and session authentication schemes are used session attributes are sent as part of the request. Here is a snippet from some sample code that demonstrates how to send attributes in a ticketing request. Notice that in the JSON message there is the UserDirectory and UserId properties and then the attributes property which is an array inside you specify an additional JSON object for each key value pair that's used to send an attribute to Qlik Sense.

    ticket request message body

    {...}

    //The body message sent to the Qlik Sense Proxy api will add the session to Qlik Sense for authentication

    string body = "{ 'UserId':'" + user + "','UserDirectory':'" + userdirectory +"',";

        body+= "'Attributes': [{"group":"QlikGroup"},{"group":"Sales"}],";

        body+= "}";

    byte[] bodyBytes = Encoding.UTF8.GetBytes(body);

    {...}

    Once a session attribute has been sent through the ticketing or session request system those attributes are stored for the duration of the users access and are used for security rules just like in the SAML example. Let's take a quick at how this works. I'll navigate to my webpage that uses the ticketing code.  Inside the ticketing code I've supplied a group attribute that will grant me access to the QlikGroup stream. During authentication, security rules will evaluate and determine that I have a group attribute and the security rule uses user.environment.group to grant me access to the QlikGroup stream.

    Section Access


    In the previous examples I sent along an attribute named group. In reality I could send any attribute I want through the session attributes mechanism. But the group attribute name has some additional capabilities within Qlik Sense. Using the group attribute name allows those values to pass into an application for section access data reduction purposes.

    Let's go ahead and open up a sales application as Anne Foster.

    Her data is reduced to only the United States because the session attribute named group has a value of "SalesUS".

    jeff567.png

    When I log in as Eddie Reese, he is only able to see Australia because his the session attribute value for him is "SalesAUS".

    jeff8910.png

    Wrap up

    Session attributes are a powerful and flexible alternative to user directory connectors when using SAML, ticketing, or session authentication schemes.  Session attributes are accessible in security rules with the user.environment syntax, and when the session attribute is named "group", the values may be used with Section Access data reduction.  To learn more Qlik products and discover additional technical materials, join the conversation on our Qlik Community, Qlik Help YouTube channel and view the video libraries on the Qlik Community: New to Qlik Sense Videos - New to QlikView Videos

    About Jeff:

    IMG_2582.JPG

    Jeff is a Principal Enterprise Architect on the North America Enterprise Architecture team who has worked in various technology positions for over 16 years. Jeff focuses on integration, deployment, automation, security, and api topics across a wide range of software. Thanks for this valuable contribution Jeff!





    (Hey Jeff - this pic is going to give me nightmares!)


    Follow us:
    Jeff Goldberg (@goldbergjeffrey) | Twitter

    Mike Tarallo (@mtarallo) | Twitter




    Show Less
  • qlik-blogssubscribe.jpg
    blog

    Community News

    Thank you for making Qlik Connect a success!

    Well, that’s a wrap on Qlik Connect 2024. There were so many product announcements and stories shared from our customers and partners. We were so luc... Show More

    dianelipik_0-1717618907491.png

    Well, that’s a wrap on Qlik Connect 2024. There were so many product announcements and stories shared from our customers and partners. We were so lucky to have such a great crowd attending both in person and virtually. We saw so many of you sharing the week’s festivities using #QlikConnect on LinkedIn. But let’s continue the conversation here!

    What were some event highlights for you?

    Did you make any great connections?

    Give us the details!

    We loved having you in Orlando this year, hope to see you in 2025!

    Show Less
  • qlik-blogssubscribe.jpg
    blog

    Support Updates

    Qlik Inline load

    Inline load is a type of data load that can be used when you do not have a data source. The data can be entered manually or by using the wizard within... Show More

    Inline load is a type of data load that can be used when you do not have a data source. The data can be entered manually or by using the wizard within QlikView or Qlik Sense.

    Here are a couple of key things to remember:

    • Data entered through an inline clause must be enclosed by square brackets [ ]
    • The columns of the table are defined in the first line of the inline load statement, separated by comas.
    • A semi colon (;) is required after the closing square bracket


    Here is an example of a simple table using inline load:

    Load * Inline [

    ID, Name, Age, Title

    1, Wladimir, 31, Team Lead

    2, Paul, 22, Technical Support Engineer

    3, Mark, 40, Customer Support Engineer

    4, Janne, 27, IT Specialist

    ];

     

    In the example inline load above, the columns for the table are:

    • ID
    • Name
    • Age
    • Title


    The values starting with 1, are all data values that will populate the table. After loading the data, and looking at the data model, it will look like a normal table:

    Wlad_Masi_0-1587737439846.png

     

    As with any other dataset, two inline load tables can be created and be connected as can be seen below. You can also connect your inline table to an already existing table:

    Wlad_Masi_1-1587737439848.png



    Inline load using the QlikView wizard:

    You can accomplish the same result using the QlikView Inline load wizard.
    In the edit script window, go to Insert > Load Statement > Load Inline. A window with a structure of a table will appear. Select the top cell indicated by F1 and change its value to the name of your first column. Repeat for the other columns of your inline table. Insert the data to create the table.  At the end, your table should look like this:

    Wlad_Masi_2-1587737439854.png

     

     

    Inline load using the Qlik Sense wizard:

     In the Data Manager, select the ‘Manual Entry’ option located at the top left corner of the screen.

    Add the table name and double click on Field_1 cell to insert your first column name. Repeat this for the other columns. After naming all the columns, you should have something like in the image below.
    Note that at the bottom right you can see the column count = 4 and number of rows = 0. If you Insert data, you see that the number of rows is no longer 0.

    Wlad_Masi_3-1587737439857.png

     

    For more detail information on using the Qlik Sense Wizard, please see the following resources:

    Manual Entry - Qlik Sense
    Inline load Delimiter


    Please give this post a like if you found it helpful! Also please let us know if you have any questions or leave your feedback in the comments.

    Show Less
  • qlik-blogssubscribe.jpg
    blog

    Explore Qlik Gallery

    Healthcare Dashboard (Oncology)

    Healthcare Dashboard AnyChart Unlock transformative insights in healthcare using Decomposition Tree, Gantt Chart, Combo Chart, Sunburst Chart, a... Show More

    🔗 >> VIEW LIVE <<

    🔗 >> SEE MORE APPS <<

    🔗 >> VISIT BOOTH 807 @ QLIK CONNECT & WIN IPAD <<

    Show Less
  • Image Not found
    blog

    Support Updates

    Release Cadence Update: Qlik GeoAnalytics

    We are introducing changes to the release cadence of our Qlik GeoAnalytics products, including: Server, Plus, Extensions, and Connectors for Qlik Sen... Show More

    We are introducing changes to the release cadence of our Qlik GeoAnalytics products, including:

    • Server,
    • Plus,
    • Extensions,
    • and Connectors for Qlik Sense Client Managed and QlikView.

     

    Beginning with May 2025, we will be releasing one yearly update, with a target release month of May. If needed, we will deliver service releases throughout the year on demand.

    As always, we recommend upgrading to the latest available release and SR (service release). If you are looking for information on version compatibility, see our official documentation. 

    This change was done to match with Qlik Sense Enterprise On Windows.

    General GeoAnalytics information

    About Qlik GeoAnalytics | Qlik GeoAnalytics Help 

    Version Compatibility

    GeoAnalytics for Qlik Sense supported versions | Qlik GeoAnalytics Help 
    GeoAnalytics for QlikView supported versions | Qlik GeoAnalytics Help 

     

    Don't hesitate to reach out with any questions you might have. 

    Thank you for choosing Qlik,
    Qlik Support

    Show Less
  • Image Not found
    blog

    Support Updates

    RESOLVED - Patch Error - Qlik Sense on Windows, February 2024 Patch 5

    Update as of June 4, 2024: Patch 5 has been fixed and is now available for download.Qlik Sense on Windows, February 2024 Patch 5 Update 1 addresses th... Show More

    Update as of June 4, 2024:

    Patch 5 has been fixed and is now available for download.

    Qlik Sense on Windows, February 2024 Patch 5 Update 1 addresses the broken text issue that was found with its original release. 

    Katie_Davis_0-1717520052455.png


    Please note: If you currently have Feb '24 Patch 5 installed, it is recommended you clear cache to solve font issue after installing the latest updated version, Feb '24 Patch 5 Update 1.

    --------------------------------------------------------------------------------

    To our February 2024 Qlik Sense on Windows users, 

    A UI issue has been detected with the Patch 5 release, where broken text is shown throughout the interface. 

    This patch has been temporarily removed from our Downloads page, and it will become available again when the root cause has been identified. 

    Investigation ID: QB-27190

    As a workaround, you can upgrade to the latest Qlik Sense on Windows version (May 2024) or use any other release from February 2024.

    We apologize for the inconvenience and appreciate your patience, 

    Qlik Global Support

    Show Less
  • Image Not found
    blog

    Support Updates

    OpenID Connect configuration in Qlik Cloud Services - Explained

    OpenID Connect configuration in Qlik Cloud Services - ExplainedOpenId Connect wants to be a simplified mechanism for modern web application authentica... Show More

    OpenID Connect configuration in Qlik Cloud Services - Explained

    OpenId Connect wants to be a simplified mechanism for modern web application authentication. But like most identity management schemes in software there are so many details to consider it can be hard to understand all the I/O. In this blog, I'll give my best effort to explain OpenId so you can speak about it intelligently, at least in context of configuring it for use with Qlik Enterprise SaaS.

    Authenta-what-now?

    Surprise

    Photo by Nathan Bingle on Unsplash

    OpenID Connect has more words and acronyms to try to explain what it is than letters in the word "authentication", including OAuth, JWT, claims, client, authorization server, and more, so it makes sense to begin with some basic definitions.

    TL;DR

    • OpenID Connect and OAuth 2 basic description
    • Qlik Cloud Service input fields for configuring an identity provider using OpenID Connect
    • Resources to learn more about Qlik Cloud Services and authentication

    Basic Definitions

    • OpenID Connect == aka OIDC, an authentication scheme for modern web applications
    • OAuth 2.0 == an authorization framework and the foundation of OpenID Connect
    • JWT == JSON web tokens contain the payload exchanged in an OAuth 2.0 handshake
    • Token == a JWT
    • Payload == Information in the form of claims to be exchanged
    • Claims == the information describing the subject of the JWT
    • Subject == aka "sub", a unique identifier, and claim, typically representing a user
    • Resource Owner == the user accessing a third-party application through OpenID Connect
    • Authorization Server == an identity provider, or the resource server storing information about the resource owner
    • Third-party Application == the "client" application requesting information about the resource owner from the authorization server
    • Client == for the purposes of this blog, Qlik
    • Scopes == permissions the authorization server grants the client, in many cases access to additional claims necessary to fulfill the client auth request

    Check out the links at the end of the blog to learn more about OpenID, OAuth 2.0, and JWT

    This is not an exhaustive list of terms in the OIDC orbit, however, it's a decent primer for what you need to know for integrating OpenID with Qlik.

    The Double-click

    If all I gave you were the basic definitions, you may feel bamboozled by the title of the blog. So here is some additional context for OpenID Connect and OAuth 2.0 before I get into Qlik-specific details.

    OpenID Connect

    OpenID Connect is an identity layer built on the OAuth 2.0 protocol. OIDC, as it is commonly referred, verifies identities between third-party applications like Qlik and an identity provider like Azure Active Directory, Okta, or Auth0. OIDC exchanges information using JWTs (aka JSON web tokens.)

    OAuth 2.0

    OAuth 2.0 is a framework for authorizing applications to share user profile information between a resource owner (the user), the authorization server (the identity provider), and the third-party application (aka the client, aka Qlik.) Exactly what information is shared depends upon the "scopes" the authorization server grants the client application.

    Qlik and the Identity Provider

    In Qlik SaaS, there are four different types of identity providers you can set up in an instance. This blog is interested in only discussing the Interactive option because it is the choice for connecting Qlik to an OIDC provider.

    Selecting Interactive populates the Provider drop-down list with a number of popular vendors who offer OIDC capabilities. Depending on the provider you select, common values in the Claims mapping and Advanced settings sections will auto-populate in the text boxes. I'll discuss Claims mapping in more detail below. For now, I'm going to move to the Application credentials section of the configuration

    Application credentials

    The Application credentials section of the configuration is where you enter in the information that identifies Qlik as a registered application with the identity provider.

    This blog doesn't cover the manual configuration options. Check help.qlik.com for information related to Application credential manual configuration.

    Provider configuration URI

    configuration-uri

    The configuration URI is a publicly accessible web address Qlik can navigate to access the OIDC metadata for the identity provider. The metadata informs Qlik of additional URIs to authenticate users and acquire JWTs containing supported claims, among other data describing the authorization server. Typically, the configuration URI will look like this:

    https://login.microsoftonline.com/<your-azuread-tenant-id>/v2.0/.well-known/openid-configuration

    Client ID

    client-id

    The Client ID is a public, unique string issued by the identity provider representing the application registration; in this case Qlik is the registered application with Microsoft Azure Active Directory. Qlik supplies the Client ID to Azure AD during authentication requests to route the request properly. Without the Client ID, Azure AD can't identify the app registration and responds with an error.

    Client secret

    client-secret

    The Client secret is a private, unique string issued by the identity provider, known only to the client and the authorization server. It is used in requests made to the identity provider to acquire the JWT token containing the authenticating user's profile information.

    identity

    Courtesy xkcd

    Realm

    realm

    The Realm is an optional value intended to contain a pattern to determine the validity of an OpenID authentication request. In Qlik, it is sometimes used to specify a Windows domain which gets prefixed to the userid.

    Claims mapping

    When a user authenticates successfully to Qlik, the authentication service generates a new "internal" token using the claims from the identity provider token. The claims are "mapped" to this new token based on the claim names in each of the text boxes for the corresponding claim.

    Certain claims, like the sub, email, and email_verifed are required claims from the identity provider token. Others, like groups and picture are optional claims. In Qlik SaaS, all of the claims listed in the mapping section are configurable, meaning you can set it to any claim name you know exists in the identity provider token.

    sub (Subject)

    sub

    The sub is a unique identifier representing the End-User at the identity provider.

    The sub claim value must be unique for each End-User accessing Qlik SaaS because the platform relies upon the sub claim to act as the unique UserId in Qlik.

    The typical sub value looks like a random string of characters like AItOawmwtWwcT0k51BayewNvutrJUqsvl6qs7A4. But as you can see, as a UserId the sub isn't readable. If you are migrating from an on-premises Active Directory to Azure AD, you may want to consider an alternate claim for the mapped sub.

    A Short Detour to AD Land

    If you are used to example\hardcoreharry representing a UserId, then chances are you have migrated from an on-premises Active Directory to Azure AD.

    The identifiable UserId in this pattern is known as the sAMAccountName. sAMAccountName is an available claim if your Azure AD synchronizes with an on-premises AD through AD-Connect. If you have Qlik Sense applications with Section Access script, consider changing the sub claim to map the sAMAccountName from the identity provider token.

    name

    name

    The name is a standard claim sent in OIDC JWTs. It represents the End-User's full name. Qlik will use this mapped claim as the friendly name used in greetings, user profile information, and in access control settings for artifacts like spaces.

    groups

    groups

    Groups is not a standard claim of OIDC. It is an optional claim that needs to be configured to be sent by the identity provider. Its name gives away the values the claim contains, but make sure you know the way the values appear. Certain identity providers like Azure AD do not send friendly names for native groups using an optional group claim, sending the unique identifier for the group instead.

    email

    email

    Email is a standard claim of OIDC, and is intended to represent the preferred email address of the End-User. Some providers do not send the email address in the email claim because their own services support the user having multiple preferred email addresses. For example, in my Azure AD there is no value in the email claim for my users, however, the upn contains the End-User email address because it is the user principal name for that user.

    client_id

    client_id

    The client_id claim contains the same value you entered in the Application credentials. It is required by OAuth 2.0 to be present in the payload of claims.

    picture

    picture

    The picture claim contains a url for the End-User's profile picture. If you configure the picture claim to map a different claim, the value must be a url and must refer to an image file. If no picture claim is sent by the identity provider, Qlik will not attempt a mapping.

    email_verified

    email_verified_claim

    The email_verified claim contains a boolean value confirming the user has verified their email with the identity provider. It is standard claim of OIDC, but it is not a requirement to be sent by the identity provider. This can cause problems for claims mapping with Qlik because Qlik requires the presence of an email_verified claim set to true to perform the complete claims mapping process.

    Each identity provider handles email verified differently

    • Okta and Auth0 send an email_verified claim because they require End-Users to verify their email address to access the service.

    • Onelogin does not send an email_verified claim in the default payload. You will need to add a custom claim to your configuration to send the email_verified claim to Qlik, and identify the claim name in this text box for Qlik to map it.

    • Azure AD does not send an email_verified claim in their token because Azure B2B users do not have to verify their email and because the user may have the same email address for accounts in different AZure Active Directory instances, it's not possible to provide a single verification mechanism which all ADs can read from. I address handling Azure AD email_verified claim challenges in the Advanced options section.

    Advanced options

    advanced-options

     

     

     

     

     

    For the majority of providers, there are two advanced options you can adjust. One is to specify the scopes the configuration should read from, and the other is a text box to supply a url to be navigated to when a user logs out of Qlik SaaS.

    There is one special advanced option that appears if you are using Azure AD as a provider, and that is a switch for the email_verified claim. I mentioned above that Azure AD does not supply an email_verified claim in the token sent to Qlik.

    email_verified-override

    You could set up a custom claim in Azure AD that sends a boolean value to Qlik. I've done it, and it's a pain. So I asked the R&D team to copy what our friends at Auth0 do and provide the switch. Once the switch is set to true, Azure AD claims map to Qlik without any issue.

    Recap

    So there you have it, clear as mud right? Hopefully you come away from reading this with a better understanding of the inputs for an OpenID Connect configuration with Qlik Enterprise SaaS. While filling in these inputs is straightforward, it's unfortunate that every provider out there implements OIDC differently. Along with reference links for OIDC and OAuth 2.0 below, check out the links related to configuring these different providers with Qlik.

    Happy Qlikking!

    References

    OpenID core specification - https://openid.net/specs/openid-connect-core-1_0.html

    Auth0 OpenID Connect Protocol - https://auth0.com/docs/protocols/openid-connect-protocol

    OAuth 2.0 RFC - https://tools.ietf.org/html/rfc6749

    OAuth 2 Simplified - https://aaronparecki.com/oauth-2-simplified/

    JWT Introduction - https://jwt.io/introduction/

    Qlik Enterprise SaaS Identity Provider Configuration Guides

    Azure AD - https://community.qlik.com/t5/Qlik-Sense-Documents/How-To-Configure-Qlik-Sense-Enterprise-SaaS-to-use-Azure-AD-as/ta-p/1704442

    Auth0 - https://community.qlik.com/t5/Qlik-Sense-Documents/How-To-Configure-Qlik-Sense-Enterprise-SaaS-to-use-Auth0-as-an/ta-p/1724074

    Okta - Coming soon!

    Keycloak - Coming soon!

    Show Less
  • Image Not found
    blog

    Support Updates

    Updates to Qlik Cloud Security Roles

    On April 16th, 2024, Qlik is launching a highly anticipated capability: custom security roles. What do custom security roles do? Custom security roles... Show More

    On April 16th2024, Qlik is launching a highly anticipated capability: custom security roles.

    What do custom security roles do?

    Custom security roles introduce fine control of data export and access permissions within Qlik apps. This allows you to tailor permissions to your specific needs, enhancing data security and compliance.

    The first delivery on April 16th includes the capability to control who can export content. Additional capabilities will be added soon after, such as who can create data connections, reports, and similar.

    What does this mean for me?

    As part of this update, the existing "has restricted view" space role will gain the ability to export data to Excel. This adjustment is in line with Qlik's capacity-based pricing model, ensuring basic users have essential tools.

    If you do not wish for users with the "has restricted view" space role to be able to export data, you will need to edit the User Default role to deny download for all users, and then create a custom role that allows if for specific users and groups.

     

    Stay tuned for more information and resources leading up to the April 16th launch. We are excited about these enhancements and the value they will bring to your data management and security efforts within Qlik.

    Thank you for choosing Qlik,
    Qlik Support

    Show Less
  • qlik-blogssubscribe.jpg
    blog

    Explore Qlik Gallery

    Hot Wheels Card Game

    Hot Wheels Card GameBildenThis application was built with the aim of practicing and exploring the possibilities of Layout Container in QlikSense. The ... Show More
    Show Less
  • Image Not found
    blog

    Support Updates

    Watch Q&A with Qlik: App Development

    Don't miss our previous Q&A with Qlik! Pull up a chair and hear from our panel of experts to help you get the most out of your Qlik experience.   Our ... Show More

    Don't miss our previous Q&A with Qlik! Pull up a chair and hear from our panel of experts to help you get the most out of your Qlik experience.

     

    Our Qlik experts helped with dashboard, app, and visualization related questions.

     

    See the recording here!

     

     

    Show Less
  • Image Not found
    blog

    Support Updates

    Check out the exciting changes to our Qlik Ideation Portal

    We're excited to share the key changes that have arrived to our Ideation portal, which will improve our user experience, our efficiency with reviewing... Show More

    We're excited to share the key changes that have arrived to our Ideation portal, which will improve our user experience, our efficiency with reviewing, and the scalability of our process.   

     

    For those new to Qlik Ideation:

    At Qlik Ideation, you (as a Customer, Partner Luminary or MVP) can vote for your favorite product ideas and suggest your own. All new ideas are reviewed by product management within 8 weeks of submission and consider all ideas for strategic fit. Product management also reviews hot and top ideas at the beginning of every planning cycle.

     

    What has changed?

    The Suggest and Browse page now has an embedded Qlik Sense app.

    ideation landing page.png

    From here you can easily:

    1. Navigate to the next sheet to search, filter, and engage with ideas
    2. Suggest a new Idea.
    3. Use our new dashboard to search and filter by status, product label, user, and more. It also enables you to vote for, comment on, or even indicate the priority of ideas you’re interested in, as well as track their status and subscribe to updates.

     

    Need more information?

     

    We're looking forward to hearing your ideas!

    Show Less