I have struggled with this for a while. Having read the Nprinting docs and gone through the 'what to do when dollar sign expansion doesn't work' and it still appears to not be working. I have other reports built in Nprinting that work well, this is the first I've tried to use Qlik Sense Variables in.

Nprinting version: Qlik NPrinting May 2026 Version: 26.19.3.0

Qlik Sense Enterprise November 2025.

Scenario: I have several variables in my Qlik Sense App: vCSDReportName, vCSDPeriodStart, vCSDPeriodEnd.

3 Variable Input objects

I have added them to my template as so:

3 variables in Template

I have created a variable filter thusly:

variable selected and value set.

And yet when I run a preview of the report in design mode I get this:

Nothing comes across..

 I've read through this article: https://community.qlik.com/t5/Qlik-NPrinting/Setting-variable-in-Nprinting-report/td-p/2496221 several times and I simply don't understand what I am missing.

If anyone can shed light on my ignorance I'd greatly appreciate it!

A clear vision, candid communication, strong execution, and a focus on creating value together. 

In his first interview as Qlik CEO, Saugata Saha shares what customers and partners can expect from his leadership and why collaboration across the Qlik ecosystem will be central to the opportunity ahead. 

In the full conversation, Saugata also discusses: 

• What drew him to Qlik  

• His perspective on data and AI  

• The importance of Qlik’s customers and partner ecosystem  

• His priorities for the first 90–100 days  

Watch the full conversation:

As Saugata shares, the future is bright! To help you look ahead in style, we're sending Qlik sunglasses to our Qlik Community members 😎 

Please join us in welcoming Saugata to Qlik and the Qlik Community. Share your reactions and thoughts with Saugata below, and we will send you a pair of Qlik shades (while supplies last). 

Hello !!!!

I have a requirement that I hope you can help me with. 

What I want to achieve is to carry over the final total from 2025 in an Income and Expenses table, so that this total is reflected in the STA line when selecting 2026.

Ideally, this should work automatically for future years as well. For example, when 2027 becomes the new year, the final total from 2026 should automatically be carried over to the STA line for 2027.

What I have achieved so far is to carry over the 2025 final total to the STA line. However, when I move to 2026, the value changes, whereas I need the value to remain fixed based on the previous year's final total.

I have attached my current formula, which achieves the first part of the requirement, along with the variables and an Excel file for better understanding of the expected behavior.

If(
af_estado_cuenta_item = 'Egresos'
and af_estado_cuenta_concepto = 'Saldo temporada anterior',

Sum(Total
Aggr(
(
If(
af_estado_cuenta_item = 'Ingresos'
and af_estado_cuenta_descripcion_estado_ingresos <> 'R',

Pick(
Match(
af_estado_cuenta_concepto,
'Ingreso Cerezas',
'Ingreso Ciruelas',
'Ingreso Kiwis',
'Ingreso Manzanas'
),

Sum(
{<
af_especie={'Cerezas'},
af_estado_cuenta_concepto={'Ingreso Cerezas'}
>}
Aggr($(v_cajasdn) * $(v_rnp_Ingresos_I), af_variedad)
),

Sum(
{<
af_especie={'Ciruelas'},
af_estado_cuenta_concepto={'Ingreso Ciruelas'}
>}
Aggr($(v_cajasdn) * $(v_rnp_Ingresos_I), af_variedad)
),

Sum(
{<
af_especie={'Kiwis'},
af_estado_cuenta_concepto={'Ingreso Kiwis'}
>}
Aggr($(v_cajasdn) * $(v_rnp_Ingresos_I), af_variedad)
),

Sum({<af_temporada={2025}>}
{<
af_especie={'Manzanas'},
af_estado_cuenta_concepto={'Ingreso Manzanas'}
>}
Aggr($(v_cajasdn) * $(v_rnp_Ingresos_I), af_variedad)
)
),

If(
GetFieldSelections(rnp_tipo) = 'RNP Ppto',
Sum(af_estado_cuenta_rnp_ppto_monto),

If(
GetFieldSelections(rnp_tipo) = 'RNP Real Acum Ppto',
Sum(af_estado_cuenta_rnp_rap_monto),

If(
GetFieldSelections(rnp_tipo) = 'RNP Prom',
Sum(af_estado_cuenta_valor_total_ingreso_real)
)
)
)
)
),
af_estado_cuenta_item,
af_estado_cuenta_concepto
)
),
)

Variables:
$(v_cajasdn) = sum(if(af_estado_analisis_financiero_produccion = 'P',af_cajas_vigente_real,af_cajas_produccion_real))
$(v_rnp_Ingresos_I) = Avg(resultado_neto_productor_unitario_caja_NRNP)

Thank you!

Hi All,

When exporting data that includes a time column formatted as 'hh:mm' into an Excel sheet, I encounter an issue where the format is not preserved correctly. 

Requirement- 

• Time Format Preservation: The exported data should maintain the 'hh:mm' format as shown in the QlikSense report.

• Table Header: The exported table should include "Total" at the top.
• Color Formatting: The color formatting in the "Flag" column should also be preserved.

Here's the situation and what I've tried so far:

Expression: Total Hours = interval(sum(Hours),'hh:mm')

1. Export with Table Formatting Enabled:

When exporting data with "Table Formatting" enabled, the time column "Total Hours" displays in a 24-hour format instead of the intended 'hh:mm' format.

For instance, a total of "45:21" hours appears as "21:21" after subtracting 24:00 hours

[ (45:21) - (24:00) = (21:21)]

2. Export without Table Formatting:

Exporting without enabling "Table Formatting" preserves the time format as 'hh:mm'. However, this method causes other issues, such as the loss of color formatting in another column called "Flag."

I attempted using the "Text" function instead of just the "Interval" function to achieve the desired export format. Here’s what I did and the issue that arose:

Attempted Solution

• Expression Used: Total Hours = Text(interval(sum(Hours),'hh:mm'))
• Result: This approach allowed me to export the data with "Table Formatting" enabled, preserving the 'hh:mm' format as required.

Issue Encountered

• Calculation Problem: When this format is used, the total hours displayed at the bottom of the Excel sheet only show the count of records, not the sum of the selected records. For example, if the user selects records 4th and 5th row in excel, the bottom of the sheet displays a count (highlighted in yellow) rather than the sum. Additionally, the top of the page shows the format as "General," making it difficult for users to calculate the total hours for selected records.
• User Frustration: Business users have to manually convert these text values into hours, which involves complex calculations and is frustrating for them.

Requirement

• The export should display the total hours in 'hh:mm' format while allowing users to easily calculate totals for selected records. Ideally, users should be able to see the sum of selected rows in the Excel sheet without additional complex steps.

Hence, I need a solution to export the data so that the "Total Hours" column maintains the 'hh:mm' format, while also retaining color formatting in the "Flag" column if "Table Formatting" in either ways enabled or not enabled and also enable business see the custom "Sum" of the records.

Hello
got the following requirement:
the user has to select one fiscal year 
Current fiscal year is 2026
if the user selects 2026 or above
then the chart has to display Budget Amount
but is the user selects any fiscal year before 2026 then chart should display Actual Amounts
I wrote the below expression:

sum
    (
        {
            <scenario={actual},fiscal_year*={"<2026"}>
            +
           <scenario={budget},fiscal_year*={">=2026"}>

       }
amount)
but some suggest that I write the following:
sum({<scenario={actual},fiscal_year*={"<2026"}>}amount)
+
sum({<scenario={budget},fiscal_year*={">=2026"}>}amount)

which approach has better performance

Getting below error when trying to connect to DB2 zOS directly within the endpoint connection using Use connection properties

• SYS-E-HTTPFAIL, Cannot connect to DB2 zOS Server.
• SYS,GENERAL_EXCEPTION,Cannot connect to DB2 zOS Server,RetCode: SQL_ERROR SqlState: HY000 NativeError: -1042 Message: [IBM][CLI Driver] SQL1042C An unexpected system error occurred. SQLSTATE=58004

Use Connection properties

Server (system)  lpar7

Port 5031

Location L7DB2I

Provider IBM DB2 ODBC DRIVER

We have a customer currently using Qlik Replicate with an on-premises Oracle database as the source. The customer is planning to migrate their source Oracle database to an IaaS environment on IBM Cloud (Bare Metal or Virtual Server Instance (VSI)) in the near future.

Could you please advise if there are any specific limitations, considerations, or prerequisites from a Qlik Replicate perspective when migrating to an Oracle source hosted on IBM Cloud IaaS?

Based on our review of the official documentation, there do not appear to be any specific limitations for IaaS environments. However, as there are noted limitations for Oracle on Oracle Cloud as referenced below, we would like to confirm with you just in case: https://help.qlik.com/en-US/replicate/May2026/Content/Global_Common/Content/SharedReplicateHDD/Oracle/oracle_cloud_prerequisites.htm

Could you please confirm if our understanding is correct?

Best regards,
Hironori Fujihira

Hi, I'm creating a map in GeoAnalytics with an area layer and a point layer. The area layer separates the UK into 4 sectors relevant to our company. I want to be able to make selections in the point layer or other filters and for this to not affect the area layer whatsoever.

Currently when I make selections, areas with no values disappear. To fix this I added {1} in front of the area code in the location field so that it will ignore selections, which keeps all the areas when I click on it, but their colours all change to the null colour, rather than what any expression or dimension value I set for the colours tells them.

Using the same technique of placing {1} infront of it doesn't work either, the colours all still appear NULL() red when I make any selections that don't include them.

Here's what it looks like when I select 3 areas. Instead of this red NULL() colour, I need each area to remain the original colour.

I understand I can create these areas as an island table in my script editor so that selections arent linked to them at all, however this isn't optimal as I'd prefer the user to be able to select an area and it will show all points in that area, which wouldnt work if the area is derived from an island table.

Any suggestions on a workaround for this?