Skip to main content

Welcome to
Qlik Community!

cancel
Showing results for 
Search instead for 
Did you mean: 
  • 215,281 members
  • 5,655 online
  • 1,991,577 posts
  • 149,200 Solutions
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW

Welcome to Qlik Community

Recent Discussions

  • forum

    New to Qlik Analytics

    Qlik Sense Analyzer Capacity usage

    Hello, I am a little confused about the Analyzer Capacity license usage. I have found a link Qlik Sense for administrators Help but one image caught m... Show More

    Hello,

    I am a little confused about the Analyzer Capacity license usage.

    I have found a link Qlik Sense for administrators Help but one image caught my attention.

    Isn't that support to be 24 min?

    Or does the block start when the request is made?

    Can anyone explain this scenario? 

    MindaugasBacius_0-1711528530038.png

    Thank you, Community!

     

    Show Less
  • forum

    New to Qlik Analytics

    Script error: Invalid expression

    I have employee data - EmpName, Joining Date, Exit Data and added Flag value status as current, New and exit. Each month there are new and exit employ... Show More

    I have employee data - EmpName, Joining Date, Exit Data and added Flag value status as current, New and exit. Each month there are new and exit employees. The next month current is a calculated value using previous month data.

    I am getting Invalid Expression for the below script. Can someone please help me understand what is missing in the below.

    Load
    count(if(status='Current',"EmpName")) as JanExisting,

    count(if(status='Current',"EmpName"))
    +count(if(status='New' and Month='Jan',"EmpName")) -
    count(if(status='Exit' and Month='Jan',"EmpName"))
    as JanFinal
    Resident MyTable;

    Load
    JanFinal +
    count(if(status='New' and Month='Feb', "EmpName", null())) -
    count(if(status='Exit' and Month='Feb', "EmpName", null()))
    as FebFinal

    Resident MyTable;

    Load
    FebFinal +
    count(if(status='New' and Month='Mar', "EmpName", null())) -
    count(if(status='Exit' and Month='Mar', "EmpName", null()))
    as MarFinal
    Resident MyTable;

    Show Less
  • forum

    Qlik Replicate

    Setting up a SQL server endpoint connection with a custom port

    I would like to setup a new SQL Server endpoint that uses a customize port.   How shall I specify the value under Server text box in "Manage Endpoint ... Show More

    I would like to setup a new SQL Server endpoint that uses a customize port.

     

    How shall I specify the value under Server text box in "Manage Endpoint Connetions"?

    I have attached a screenshot showing that I input as

    --> 10.20.30.40,1450

    (IP: 10.20.30.40, Port: 1450)

     

     

    Show Less
  • forum

    New to Qlik Analytics

    Qlik FIlter pane

    Hi Guys, I want to how to filter max date from a field and when opening the dashboard it should get bookmark according to it. =Num(InspectionDate2)=Nu... Show More

    Hi Guys,

    I want to how to filter max date from a field and when opening the dashboard it should get bookmark according to it.

    =Num(InspectionDate2)=Num(Max(InspectionDate2)) I have tried this but it filters all dates but not pick max date.  

    Show Less
  • forum

    App Development

    Default Max Date selection in Filter pane when app opens

    When I open my app, I wanted to see my max date selection in my Date field. Some one can help me on this.
  • forum

    Catalog and Lineage

    Full hub access with bookmarks exception?

    Is there a (simple) way to grant full access to the hub (all actions, all resources) for my RootAdmin role, except to see (edit, etc.) other users' bo... Show More

    Is there a (simple) way to grant full access to the hub (all actions, all resources) for my RootAdmin role, except to see (edit, etc.) other users' bookmarks?

    Show Less
  • forum

    Design and Development

    How to load external tJasperReportExec component?

    Hi everyone,   I wonder how I can load this tJasperReportExec component? I unzipped all files into a folder but  when I go Preferences --> Talend --> ... Show More

    Hi everyone,

     

    I wonder how I can load this tJasperReportExec component? I unzipped all files into a folder

    but  when I go Preferences --> Talend --> Components and select the folder which contains the files

    and click on apply. I don't find tJasperReportExec even when I restart Talend.

    Did I something wrong?

     

    pawe84_0-1711614419790.png

     

    Thanks in advance for any help.

    Show Less
  • forum

    New to Qlik Analytics

    Coloring measures by dimension for employee tenure gantt chart

    Hello,I'm currently putting together employee tenure gantt chart and I've managed to make some progress thanks to the Qlik Community. My current emplo... Show More

    Hello,

    I'm currently putting together employee tenure gantt chart and I've managed to make some progress thanks to the Qlik Community. My current employee tenure chart sorted by joining date order looks like below, but I'd like to use a blue color for male employees and a red color for female employees in order to distinguish and visualize gender in the chart below.  I'd greatly appreciate it if you could let me know how I can do that.  

     

    Newbie7_0-1623566754528.png

    Thanks a lot for your help!

     

    Show Less
  • forum

    Deployment & Management

    SSL Certificate Trust and Self-Signed Certificate Removal in Qlik Sense Environm...

    Currently, our setup involves a single-node installation of November 2022 Qlik sense Enterprise. The vulnerability scanning tool on the client side, s... Show More

    Currently, our setup involves a single-node installation of November 2022 Qlik sense Enterprise.

    The vulnerability scanning tool on the client side, such as Nessus, has issued multiple warning stating, "The SSL certificate for this service cannot be trusted." It's important to note that we restrict user access to Qlik Sense from external sources. Instead, we solely rely on the Engine API with certificate trust for data retrieval and access the Hub exclusively from the server. This warning has been raised for multiple ports, including 3389 and 4239.

     The recommendation from the tool is to "Purchase or generate a proper SSL certificate for this service." 

    Although we understand that third-party SSL certificates can be employed for accessing the Hub, I'm uncertain whether this warning will persist unless we delete the self-signed certificate generated by Qlik. Could someone provide guidance on the best approach to resolve this issue?

    Show Less
  • forum

    New to Qlik Analytics

    difference in meaning in (set) expressions

    For a Qlik sense training course I have created a gauge displaying the ratio of males as a percentage of the total population. Because I wanted to hav... Show More

    For a Qlik sense training course I have created a gauge displaying the ratio of males as a percentage of the total population. Because I wanted to have a benchmark, I set a limit which is dynamic with the use of a set-expression.

    Whenever I select a different age group, the gauge changes to display a new number.

    I have created a master item (measure) for this ratio and added this expression:

     

    count(distinct(if(Gender='Male',PatientID)))
    /
    count(distinct(PatientID))
    
    
    

     

    I don't know why but I thought of finding out a different way to write this expression. I tried some things and finally ended up with this:

     

    count({1<Gender={'Male'}>} distinct(PatientID))
    /
    count(distinct(PatientID)) 

     

    Can I conclude that both expressions actually do the same and performance-wise: does one way have an advantage over the other?

    Show Less
Leaderboard

Customer Story

Qlik Data Integration & Qlik Replicate story

Qlik enables a frictionless migration to AWS cloud by Empresas SB, a group of Chilean health and beauty retail companies employing 10,000 people with 600 points of sale.

Customer Story

Building a Collaborative Analytics Space

Qlik Luminary Stephanie Robinson of JBS USA, the US arm of the global food company employing 70,000 in the US, and over 270,000 people worldwide.

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!