Skip to main content

Welcome to
Qlik Community!

cancel
Showing results for 
Search instead for 
Did you mean: 
  • 233,094 members
  • 3,915 online
  • 2,016,228 posts
  • 151,384 Solutions
Announcements
Qlik Connect 2025: 3 days of full immersion in data, analytics, and AI. May 13-15 | Orlando, FL: Learn More

Welcome to Qlik Community

Recent Discussions

  • forum

    Women Who Qlik

    Qlik is Celebrating Ada Lovelace Day!

    Before the day ends, I wanted to draw your attention to this inspiring LinkedIn post from Ruthann Wry, Chief People Officer at Qlik. As a leader in th... Show More

    Before the day ends, I wanted to draw your attention to this inspiring LinkedIn post from Ruthann Wry, Chief People Officer at Qlik. As a leader in the WomenWhoQlik community, Ruthann's post celebrates:

    • The Qlik Women in Tech Employee Resource Group and its amazing leaders @Katie_Davis and @BeaBright-Davies 
    • External organizations that champion women leaders like Women in Data and Women Leaders in Data & AI 
    • Qlik's donation of 10 Women in Data scholarships to support future leaders
    • Snapshots of some of #WomenWhoQlik and their stories

    What are you most proud of as part of this community? What else do you hope to see from Women Who Qlik in the future? 

    Show Less
  • forum

    New to Qlik Analytics

    15 min interval time

    Hi community, Seeking your assistance in creating an chart dimension, which shows 15 min interval time for the max date. Thanks in advance
  • forum

    New to Qlik Analytics

    complex section access scenario for masking columns

    Hi All, I have data with some PII fields. I have three user role which are defined in the section access data with USERID, ROLE field. Three roles are... Show More

    Hi All,

    I have data with some PII fields. I have three user role which are defined in the section access data with USERID, ROLE field. Three roles are PII,SEMI_PII,NON_PII. In data I have around 3 PII fields. When user with role PII logs in, he should see all PII field values as is. When user with role SEMI_PII logs in, he should see all PII field values partially masked. When user with role NON_PII logs in, he should see all PII field values fully masked. Masking could be anything but masked values should be unique for each field value. for eg. I have Client Name A,B & C, so masked values could be like xAnvBgH, HnbvFTb & hhGVcDr which is unique to each Name as values will be repeating.

    Definition of SEMI_PII is that we have indicator in our data, if indicator value is 1 PII fields should be masked, otherwise original values should be displayed. for eg. Let's say we have Client Name A, B & C. for values A & B indicator is1 and for C it is 0. So when user logs in he should see values cHbbVch,BngVbhjK & C. Which means A & B values will be masked.

    Note: I have around 1000 users and PII field values for some field might have 5 million distinct values. 

    I don't know how to approach this

    Show Less
  • forum

    Qlik NPrinting

    Assistance Needed with NPrinting User Access Issue

    Dear Experts, I am facing an issue with one of our users (USER1) who is unable to download an on-demand report by clicking the on-demand button. Anoth... Show More

    Dear Experts,

    I am facing an issue with one of our users (USER1) who is unable to download an on-demand report by clicking the on-demand button. Another user (USER2), with identical access rights, is able to download the report without any issues.

    USER1 already has all the necessary access in the QMC, similar to USER2. However, USER1 was not present in NPrinting, so I added them. Upon doing so, I encountered the error: "Not NT Domain user, it can be used for JWT and SAML authentication" (screenshot attached).

    To troubleshoot, I logged into the server and added USER1 under "Local Users and Groups" in computer management. Unfortunately, the error persists. I suspect that there might be a sync issue between Qlik Sense and NPrinting, but I’m not certain.

    Could you please provide guidance on what I might be overlooking?


    I am using Qlik NPrinting February 2021

    Version: 21.0.0.0

    and 

    Qlik Sense Feb 2021 Patch 4
    qliksenseserver: 14.5.10

     

    Thank you for your help!

    Show Less
  • forum

    Design and Development

    Type mismatch: cannot convert from String to boolean

    Talend Data Services Platform Version: 8 Build id: 20240524_0800-patch     Hi, I have this expression in tMap.   /if the work email is null row7.E... Show More

    Talend Data Services Platform

    Version: 8

    Build id: 20240524_0800-patch

     

     

    Hi,

    I have this expression in tMap.

     

    /if the work email is null

    row7.EMAIL==null

    //or the work email is blank

    ||StringHandling.BTRIM(row7.EMAIL).isEmpty()==true

    //then return empty string

    ?""

    //else return the email string

    :StringHandling.DOWNCASE(StringHandling.BTRIM(row7.EMAIL))

     

     

    I am trying to replace the null vlaue to "" in the EMAIL field.

     

    I am getting the error:

    Type mismatch: cannot convert from String to boolean

     

    The EMAIL columns is defines as varchar2(30) in Oracle (source).

     

    Appreciate any suggestions.

    Thank you

    Show Less
  • forum

    App Development

    Qliksense Button Issue

    Hello Everyone,  I have created a 'Mark as Final' Button in a report using variables and Vizlib buttion actions in qlik.   i.e vStatus = 0 (Button no... Show More

    Hello Everyone, 

    I have created a 'Mark as Final' Button in a report using variables and Vizlib buttion actions in qlik.

    Anjaneya_prasad_Chattu_0-1728422170972.png

     

    i.e vStatus = 0 (Button not clicked)
         vStatus =1 (Button clicked)

    When user clicks on the reports it , it will show as below

    Anjaneya_prasad_Chattu_1-1728422347413.png

    But when after page refreshing also button is getting active .  

    Once the button is finalized it should not become active untill the app next refresh.

    Need some suggestions and ideas to implement this.

    Thank you.

    Show Less
  • forum

    QlikView App Dev

    populate data

    HiI have following data in my QV document      POLICY_NOYEARPERIOD_FROMPERIOD_TONEW_RENLAST_REN_YEAR7M00111C0000087201221-Oct-201220-Oct-2013REN-7M001... Show More

    Hi

    I have following data in my QV document

         

    POLICY_NOYEARPERIOD_FROMPERIOD_TONEW_RENLAST_REN_YEAR
    7M00111C0000087201221-Oct-201220-Oct-2013REN-
    7M00111C0000087201321-Oct-201320-Oct-2014REN2013
    7M00141A0000245201404-Nov-201403-Nov-2015NEW-
    7M00141A0000245201504-Nov-201503-Nov-2016REN2015
    7M00141W0000022201406-Mar-201405-Mar-2015NEW-
    7M00141W0000022201506-Mar-201505-Mar-2016REN2015
    7M00131D0000089201310-Jun-201309-Jun-2014NEW-
    7M00131D0000089201410-Jun-201409-Jun-2015REN-
    7M00131D0000089201510-Jun-201509-Jun-2016REN2015
    7M00141A0000253201431-Dec-201430-Dec-2015NEW-
    7M00141A0000253201531-Dec-201530-Dec-2016REN2015
    7M00151D0000140201508-Jan-201507-Jan-2016NEW-
    7M00151D0000140201608-Jan-201607-Jan-2017REN2016
    7M00144F0000002201429-Nov-201428-Nov-2015NEW-
    7M00144F0000002201529-Nov-201528-Nov-2016REN2015
    7M00141C0000155201428-Aug-201427-Aug-2015NEW-
    7M00141C0000155201528-Aug-201527-Aug-2016REN2015

    LAST_REN_YEAR IS MISSING IN SOME RECORDS I WANT TO POPULATE THE MISSING LAST_REN_YEAR WITH LAST_REN_YEAR OF THE CORRESPONDING POLIICY_NO

    EG:

    POLICY_NOYEARPERIOD_FROMPERIOD_TONEW_RENLAST_REN_YEAR
    7M00111C0000087201221-Oct-201220-Oct-2013REN                     2013
    7M00111C0000087201321-Oct-201320-Oct-2014REN2013

    PLS HELP

    Show Less
  • forum

    New to Qlik Analytics

    Can't export to excel

    Hi, I'm trying to export a pivot to excel in QS and I get the error "Corrupted data".It is possible to export from another pivot in the same sheet.I t... Show More

    Hi,

    I'm trying to export a pivot to excel in QS and I get the error "Corrupted data".
    It is possible to export from another pivot in the same sheet.
    I tried to solve it with some posts here but it didn't work.
    What could be the problem and how to solve it?

    Show Less
  • forum

    New to Qlik Analytics

    How to apply Entropy Analysis in the qlik sense?

    Hi , It is a open discussion. I met the below case , need your help. Thanks in advance.  I need to show the work load analysis by different people.  T... Show More

    Hi ,

    It is a open discussion. I met the below case , need your help. Thanks in advance. 

    I need to show the work load analysis by different people. 

    Their daily job include Job1 , Job2 , Job3 , Job4 , Job5 , ( these job is independent, no association)

    the daily job workload is linked with the sql server, so it will added day by day;

    People Job1 Job2 Job3 Job4 Job5
    A 6 7 60 43 16
    B 91 85 13 34 6
    C 96 73 46 46 90
    D 36 19 60 65 91
    E 12 76 22 53 54
    F 18 44 17 70 68

    Currently , my boss told me the sheet is difficult to read . So , I want to use Entropy Analysis . 

    I know how to do in excel. But , I don't how to do in QLIK Sense . 

    Beside it , the data will added day by day . So, the number is dynamic.

    Pls....

     

    Show Less
  • forum

    App Development

    Conditional Concatenation/Appending

    I want to append latest/current week's data to a file wherein we have 6 month's data(excluding the current week) , to do that I am using a peek functi... Show More

    I want to append latest/current week's data to a file wherein we have 6 month's data(excluding the current week) ,

    to do that I am using a peek function to look for the max date in the 6months data,

    and then wants to compare it with the latest week's max date , if the date matchs that means we have concatenated the data if it doesn't match then we have to concatenate the latest week's file to 6 Month's file.

    For getting latest week's data we are using a REST Connector, 6 months data is stored as qvd

    $(maxdate_latest) is the variable to peek into latest max date and $(vmaxdate) is the variable for the 6months max date

    I'm using this script

    if '$(maxdate_latest)' <> '$(vmaxdate)' then
    Reference_data:
    load * from reference_qvd2;

    concatenate

    Streaming_data:

    load * from reference_qvd2;

    Else

    0;

    Endif;

    Show Less
X
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!