Skip to main content

Welcome to
Qlik Community!

cancel
Showing results for 
Search instead for 
Did you mean: 
  • 257,718 members
  • 2,348 online
  • 2,040,236 posts
  • 153,538 Solutions
Announcements
Week 5: Getting Answers With AI + A New Era of Data Governance - WATCH NOW

Welcome to Qlik Community

Recent Discussions

  • forum

    App Development

    Calculating a percentile for a student test score

    I have an app that contains a list of students with their test scores.  When I select a single student, I would like to have a text box on the screen ... Show More

    I have an app that contains a list of students with their test scores.  When I select a single student, I would like to have a text box on the screen show me a calculation of the student's test score percentile.  In other words, I would like to know what percentage of other student's test scores are equal than or lower to the selected student's test score.  

    The field that will be selected to identify the specific student is called [student_ID], and the test score field is called [test_score].  Unfortunately, I can't post a screen shot of the data due to privacy concerns.

    Is this possible?  

    Show Less
    Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
  • forum

    Qlik NPrinting

    Data Type in an Excel Nprinting Report - Qlik NPrinting May 2021 SR3

    Hey everyone, I'm running into a data type issue with an NPrinting report in Excel. When I drop a simple measure likenum(sum(Amount), '#.##0,00')) Exc... Show More

    Hey everyone,

     

    I'm running into a data type issue with an NPrinting report in Excel. When I drop a simple measure like

    num(sum(Amount), '#.##0,00'))

     

    Excel correctly recognizes it as a number and keeps the formatting. However, I need to apply different KPI and formats based on a field value using a pick(match()) or an if() expression. Here's a sample:

    pick(match(Dim, 'Value1', 'Value2'),
        num(sum(Amount), '#.##0,00'),
        num(sum(Amount) / $(vAuxDenominator), '#,##%')
    )

    The problem is, when I use this expression, NPrinting seems to lose the formatting. In the generated Excel report, the KPI is treated as text. It's aligned to the left, and there's a green symbol indicating it's a number stored as text. This is strange because the KPI is correctly recognized as a number within Qlik Sense. Here's a screenshot from the Excel report:

    alexquimu_3-1754655195652.png

     

    I don't really have a problem with the alignment, but with the green symbol.

     

    Some of my attempts:

    • Enabling/disabling the Keep Source Format option for the object in the NPrinting template.

    • Converting the object to a number directly in the Excel template.
    • Using num# outside of the if or pick/match function..

     

    Has anyone ever faced a similar scenario as the described? 

     

    Thanks in advance.

    Greetings,

    Alex

    Show Less
    Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
  • forum

    App Development

    Extract JSON Payment information from SQL DB in QlikView

    Good morning. I am hoping someone is able to assist or advise me if it is possible to get data from a field that contains payment information. I have ... Show More

    Good morning. 
    I am hoping someone is able to assist or advise me if it is possible to get data from a field that contains payment information. 

    I have data in a SQL DB and one on the fields, Payments, is either empty or has JSON as below. 

    I am trying to extract the Date and Amount portions. I found a couple of examples on the Community, but so far my attempts are not working out. 

    Looking at the below, is it all possible to extract the Date and Amount? 

    [
    {
    "PaymentID": "121d3a27-84be-416a-837c-6707d88ede6d",
    "Date": "2025-07-30T02:00:00+02:00",
    "Amount": 1300.0,
    "Reference": "Payment",
    "CurrencyRate": 1.0,
    "HasAccount": false,
    "HasValidationErrors": false
    }
    ]

    Thank you very much. 

     

     

    Show Less
    Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
  • forum

    Qlik Replicate

    Is it possible to script transformations for many tables?

    A vendor recently updated their database and increased the varchar length on 178 fields across 131 tables.  As a quick fix, we are going to trim and t... Show More

    A vendor recently updated their database and increased the varchar length on 178 fields across 131 tables. 

    As a quick fix, we are going to trim and truncate the fields using the built in transformation options, but with this many I wanted to know if there was a way to script these changes in Qlik Replicate? We are using Qlik Replicate May 2023 (2023.5.0.285)

    (Very beginner here, the people that were trained in Qlik have recently left the company and I'm being asked to fix this)

    Thanks in advance!

    -Brian

    Show Less
    Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
  • forum

    App Development

    Properly handle missing value in dimension

    Hello,  I am trying to create a condition a null field for the field "Key Confirm". This is my mesure : =IF(ISNULL(Key_Confirm), 'Not Confirmed', 'Con... Show More

    Hello, 

    I am trying to create a condition a null field for the field "Key Confirm".

    This is my mesure :

    =IF(ISNULL(Key_Confirm), 'Not Confirmed', 'Confirmed')
    But for null key_confirm, it doesn't work, and only display a empty field with '-'.

    What I am missing ? 


    Show Less
    Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
  • forum

    Talend Studio

    Talend Studio - Elasticsearch Components

    Hello, wir currently hold a license for the "Talend Data Management On-Premise Platform".Version: 8Build id: 20250730_0900-patch To connect jobs to ou... Show More

    Hello,

    wir currently hold a license for the "Talend Data Management On-Premise Platform".
    Version: 8
    Build id: 20250730_0900-patch

    To connect jobs to our monitoring system we are looking to use the component for Elasticsearch that are documented here:

    https://help.qlik.com/talend/en-US/components/8.0/elasticsearch/elasticsearch-component

    Weupdated the Studio to the latest version and installed every available features and also activated all features in the project setting. The add feature then shows everything available as installed.

    But wether in the feature list nor in the components view we find the elasticsearch components we are looking for.

    Hopefully somebody can guide us here how to get this components into the studio.

    BR,

    Tim

     

    Show Less
    Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
  • forum

    App Development

    Need Help in Qlik

    Hi,I have a field EXTRA and Value is like this :AOB 327, AOB 328, Case Drain 103, Case Drain 107, FLIB 110, FLIB 319I need only alphabetically charact... Show More

    Hi,

    I have a field EXTRA and Value is like this :

    AOB 327, AOB 328, Case Drain 103, Case Drain 107, FLIB 110, FLIB 319

    I need only alphabetically character from this field; How I can derive in Qlik.

    Like AOB, Case Drain, FLIB.

    Thanks

     

    Show Less
    Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
  • forum

    Installing and Upgrading

    Installing Qliksense Enterprise on New Scheduler Server

    I am trying to install Qliksense Setup on a new server that we are going to use as a Scheduler. Our current environment has 1 repository, 3 engines, a... Show More

    I am trying to install Qliksense Setup on a new server that we are going to use as a Scheduler. Our current environment has 1 repository, 3 engines, and 3 schedulers, and we have been having performance issues with our schedulers since our migration from SQL Server to Databricks for our Data Warehouse. So we are adding a new scheduler to assist with the added CPU and Memory usage, but I am unable to install the initial setup of Qliksense because it says database could not be reached. Anyone ever experience this issue or know of a solution?

     

    tylermann1011_0-1754502217423.png

     

    Show Less
    Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
  • forum

    App Development

    Three-dot menu (⋮) is not visible on charts

     The three-dot menu (⋮) also known as the hover menu or object menu — is not visible on charts or other visualizations in Qlik Sense.As a result, opti... Show More

     

    • The three-dot menu (⋮) also known as the hover menu or object menu — is not visible on charts or other visualizations in Qlik Sense.

    • As a result, options like Full Screen Mode, Export, Maximize, Explore, or Object Details are missing

     

     

     

    nidheesh_2-1754472530864.png

     

    We have verified that below both options are already enabled.

    "Show Mouse Over Menu"
    "Show Over Menu on Visualizations" 

     

     

    Show Less
    Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
  • forum

    App Development

    Calculate Previous completed week total sales

    I am using the following dimensions to calculate previous week sales in Pivot table. Also by default we have WeekEnd_Date trigger set to max Week EndD... Show More

    I am using the following dimensions to calculate previous week sales in Pivot table. Also by default we have WeekEnd_Date trigger set to max Week EndDate. Based on the selection it should change.

    Variable is already defined : =Date(max (WE_Date)-7,'MM/DD/YY')


    Dimesnion 1: =ValueList('Prior Week Sales','Prior Week Cases','Prior Week Case Cost')
    prior week sales dimension 2
    =ValueList(
    Date(Date#('$(vPreviousWeekEnd)', 'MM/DD/YY') - 6, 'MM/DD/YY'), // Sunday
    Date(Date#('$(vPreviousWeekEnd)', 'MM/DD/YY') - 5, 'MM/DD/YY'), // Monday
    Date(Date#('$(vPreviousWeekEnd)', 'MM/DD/YY') - 4, 'MM/DD/YY'), // Tuesday
    Date(Date#('$(vPreviousWeekEnd)', 'MM/DD/YY') - 3, 'MM/DD/YY'), // Wednesday
    Date(Date#('$(vPreviousWeekEnd)', 'MM/DD/YY') - 2, 'MM/DD/YY'), // Thursday
    Date(Date#('$(vPreviousWeekEnd)', 'MM/DD/YY') - 1, 'MM/DD/YY'), // Friday
    Date(Date#('$(vPreviousWeekEnd)', 'MM/DD/YY'), 'MM/DD/YY') // Saturday
    )

    Expression :

    Pick(
    Match(
    ValueList(
    'Prior Week Sales','Prior Week Products','Prior Week Product Cost'
    ),
    'Prior Week Sales','Prior Week Products','Prior Week Product Cost'

    ),
    Sum(sales_amount), Sum(Product_Cost), Sum( sales_amount) /Alt(Sum( Product_Cost), 0))

    But, Getting the same values for the entire dates. Images attached

    qvqs_0-1754652030352.png

     

    Show Less
    Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Weekly Leaderboard

Customer Story

Catalyst Cloud (Fusion)

Catalyst Cloud developed Fusion, a no-code portal that integrates with existing Qlik licenses to deliver critical insights across the organization. The results? Time savings, transparency, scalability to expand, and increased adoption.

Location and Language Groups

Choose a Group

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

Collaborate

Forums

Qlik Automate

Less manual work, more data flow. Welcome to Qlik Automate.