Skip to main content

Welcome to
Qlik Community!

cancel
Showing results for 
Search instead for 
Did you mean: 
  • 221,682 members
  • 5,321 online
  • 2,001,998 posts
  • 150,122 Solutions

Welcome to Qlik Community

Recent Discussions

  • forum

    Deployment & Management

    Integrating Okta with Qlik Sense for user groups

    We need to integrate Okta with Qlik Sense for user groups. We followed the document below to configure this, but it is still failing. Could you please... Show More

    We need to integrate Okta with Qlik Sense for user groups. We followed the document below to configure this, but it is still failing. Could you please share any other methods to achieve this?

    https://community.qlik.com/t5/Design/User-Environment-What-Session-Attributes-in-Qlik-Sense/ba-p/1476590 - This document discusses SAML using Session Attributes. Any attributes that need to be linked to a User Directory Connector to store attributes for a UserId will operate the same way (OIDC / Header / JWT).

    Show Less
  • forum

    New to Qlik Analytics

    How to Remove unwanted 0 Values in a Chart.

    Hi Experts, Please refer the below screen shot. I just want to "remove this light blue line". How do I solve this? In my data set there is no such zer... Show More

    Hi Experts,

    Please refer the below screen shot. I just want to "remove this light blue line". How do I solve this? In my data set there is no such zero values for the evening shift ( Light Blue Line). Only contains the vales for the "General Shift". Could you please explain why it happens and How do I fix this? 

    Nethu_Rajapaksha_1-1717647666314.png

     

     

     

    Show Less
  • forum

    App Development

    Change Qlik Selection Color in Qlik Sense / Qlik Cloud

    Hello, is there a way to change default selection color (to change the Qlik green by a blue or a red). I know how to do this in Qlik Sense / Qlik Clou... Show More

    Hello,

    is there a way to change default selection color (to change the Qlik green by a blue or a red).

    I know how to do this in Qlik Sense / Qlik Cloud.

    Best regards

    Show Less
  • forum

    Qlik Enterprise Manager

    Qlik asked for Windows Credentials when we start new session on browser

    When we login to Qlik, we are being asked for our Windows username and password. This didn’t used to happen as we would be logged into the Insight hub... Show More

    When we login to Qlik, we are being asked for our Windows username and password. This didn’t used to happen as we would be logged into the Insight hub automatically? can someone help me on this Many Thanks

    Currently I am using Qlik Sense Nov 2022 Patch 12.

    umerfa_0-1717668051114.png

     

     

    Show Less
  • forum

    App Development

    Button to open a file

    Hi, in qlik sense (v. May2021)  I created a button which has a URL to open a file in the server like this:  'file:/serverName/Folder1/Folder2/Folder3/... Show More

    Hi,

    in qlik sense (v. May2021)  I created a button which has a URL to open a file in the server like this: 

    'file:/serverName/Folder1/Folder2/Folder3/document.docx'

    when i click the button it opens the link in chrome (or same in other web browser)  but omit the colon (:).

    when i paste it manuely in the address bar it works good (it downloads the file). or when i add the colon back into the url it also works.

    does someone has an idea how to resolve it? why qlik omit the colon?

     

    Show Less
  • forum

    Security & Governance

    Section Access

    Hi   I am new to Qlik and want to know more about section access. I am tasked with writing a section access code which is suppose to provide reduction... Show More

    Hi

     

    I am new to Qlik and want to know more about section access. I am tasked with writing a section access code which is suppose to provide reduction on two fields. When i use blank for GROUPS and later check the testing sheet i dont get correct values i the filter. However, if i use * , then it seems to work. What is the difference between using blank and *.

    Show Less
  • forum

    QlikView App Dev

    Section Access

    I have the following section access script in my hidden script -  Section Access; LOAD * INLINE [ACCESS,  NTNAME,              OMIT,       SLRLEVEL8, ... Show More

    I have the following section access script in my hidden script - 

    Section Access;


    LOAD * INLINE [
    ACCESS,  NTNAME,              OMIT,       SLRLEVEL8,    SLRLEVEL7
    ADMIN,     DOMAIN\USER1,   *,             *,                       *
    ADMIN,     DOMAIN\USER2,   *,             *,                       EMERGENCY DENTAL SERVICE
    ADMIN,     DOMAIN\USER3,   NHSNO,  *,                       EMERGENCY DENTAL SERVICE
    ADMIN,     DOMAIN\USER3,   NHSNO,  *,                       SPECIAL CARE DENTAL SERVICE
    ];

    Section Application;

     

    When opening the dashboard my log in - DOMAIN\USER1, I can only see EMERGENCY DENTAL SERVICE and SPECIAL CARE DENTAL SERVICE and cannot see NHSNO.

     

    Why is this happening? I should be able to see everything

     

    Thanks

     

    Kev

    Show Less
  • forum

    App Development

    creating an expression to sum two values together and return results greater tha...

    Hi guys, I'm trying to create an expression to sum two values together and return results greater than 1 My expression works but it also returns null ... Show More

    Hi guys,

    I'm trying to create an expression to sum two values together and return results greater than 1

    My expression works but it also returns null or missing values and suppressing them on the presentation tab doesn't work  

    =if(sum([Overtime FTE])+sum([FTE])>1,sum([Overtime FTE])+sum([FTE]))

    My report also has 4 dimensions: Employee Code, Pay Period, Award Category and Hospital.

    The report is set up as a pivot table. It works ok as a straight table but I need to pivot by Pay Period.

    Any help would be greatly appreciated!

    Cheers,

     

    Mike

     

     

    Show Less
  • forum

    New to Qlik Analytics

    Link table for accounting data in OLE DB data and budget data from Excel File

    Hi, I have a problem where I need to get Transaction data from a OLE DB data source and then add en Excel file with manually entered Budget data for f... Show More

    Hi,

    I have a problem where I need to get Transaction data from a OLE DB data source and then add en Excel file with manually entered Budget data for four different companies, the load data look like this compressed with the relevant fields for two of the companies as below.

    I add the company name as Client field for every company and the joined data for Transactions table is working as supposed.

    My problem is that the budget data is added on the last day of the month because it's mainly relevant to look at this aggregated per month. But since there are multiple transactions in the Transaction data the last day of the month every month the Budget data get multiplied for every occurrence of that date.

    What I've found is that I should use a Link table to solve this issue but it seems that my skills is not enough to get the script right.

    I would like to group interval of accounts for example revenue, material cost, gross profit etc. for set analysis and add a master calendar (or similar) to do analysis on different time periods. Is it possible to have a Link table for Client, account and date fields and then add grouping and master calendar connected in the Link table or do you have to do this in the Load for the original data sources?

    LIB CONNECT TO 'Briljantdata - MGA (ad_ext_kons)';
     
    Transactions:
     
    LOAD 
     
    'MGA' as Client,
        bel, // (amount field)
        kto, // (Account field)
        trdat; // (Date field)
    SQL SELECT
        bel,
        kto,
        trdat
    FROM rtr;
     
     
    LIB CONNECT TO 'Briljantdata KJ (ad_ext_kons)';
     
    join(Transactions)
    LOAD
    'KJ' as Client,
        bel, // (amount field)
        kto, // (Account field)
        trdat; // (Date field)
    SQL SELECT
        bel,
        kto,
        trdat
    FROM rtr;
     
    LOAD
    'MGA' as Client,
        kto, // (Account field)
        trdat, // (Date field)
        Budget_belopp // (Amount field)
    FROM [lib://AttachedFiles/Qlik sense Budget MGA 22-23 & 23-24.xlsx]
    (ooxml, embedded labels, table is Budgetdata_MGA);
     
    LOAD
    'KJ' as Client,
        kto, // (Account field)
        trdat, // (Date field)
        Budget_belopp // (Amount field)
    FROM [lib://AttachedFiles/Qlik sense Budget KJ 22-23 & 23-24.xlsx]
    (ooxml, embedded labels, table is Budgetdata_KJ);
     
    Help is much appreciated!
    Show Less
  • forum

    Qlik Cloud Data Integration

    Export total row in Qlik Cloud

    Currently, the total row is missing when exporting data from Qlik Cloud to excel. This function is available in Qlik Sense Enterprise but not in Qlik ... Show More

    Currently, the total row is missing when exporting data from Qlik Cloud to excel. This function is available in Qlik Sense Enterprise but not in Qlik Cloud. Most of users need this value.

    Show Less
Leaderboard

Customer Story

Accelerating Decision-Making with Qlik Insights

Qlik enhances decision-making with high-speed insights, as Mayborn Group integrates data from various functions across their global operations, gaining a competitive edge in the childcare industry.

Customer Story

Efficiency in Agriculture: Nortera's Qlik Triumph

Nortera leads agricultural manufacturing analytics and automation with Qlik, reducing short-shipment rates and annual savings in water consumption.

Customer Story

Revolutionizing aircraft production through Data Analytics

Qlik Data Integration transforms Airbus' aircraft production, leading to over 150 replication tasks and informing more efficient analysis.

Location and Language Groups

Choose a Group

Join one of our Location and Language groups. Find one that suits you today!

Collaborate

Healthcare User Group

Healthcare User Group

A private group is for healthcare organizations, partners, and Qlik healthcare staff to collaborate and share insights..

All are welcome

Japan Group

Japan

Qlik Communityの日本語のグループです。 Qlik製品に関する日本語資料のダウンロードや質問を日本語で投稿することができます。

Request to join

Brasil Group

Brazil

Welcome to the group for Brazil users. .All discussions will be in Portuguese.

open to all

Blogs

Community News

Hear from your Community team as they tell you about updates to the Qlik Community Platform and more!