Recent Discussions
-
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 MoreI 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?
-
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 MoreHey 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:
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
-
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 MoreGood 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.
-
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 MoreA 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
-
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 MoreHello,
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 ?
-
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 MoreHello,
wir currently hold a license for the "Talend Data Management On-Premise Platform".
Version: 8
Build id: 20250730_0900-patchTo 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
-
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 MoreHi,
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
-
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 MoreI 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?
-
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 MoreThe 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
We have verified that below both options are already enabled.
"Show Mouse Over Menu"
"Show Over Menu on Visualizations" -
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 MoreI 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