All Forums

Hi there,

I'm trying to calculate an a !verage per month (= the sum of ... divided by number of months available) but it doesn't work. Anyone any suggestions what I'm doing wrong?

If (in a text box) I apply the calculation "count(distinct(Month))" it gives me the number "2" which is correct since there are only two months of data available. However, applying the same expression in a pivot table doesn't work.

Much appreciated if someone can guide me into the right direction.

Cheers!

Hi all,

How can I use the expression bellow in  include.qvs file?

SET vLast12Months = Sum ({<[Ano Mes Retorno] = {">=$(=date(Max(addmonths(today(),-12)),'YYYYMM'))"}>}[Valor Realizado Cob - Coop]);

When executed, the variable vLast12Months appears like this in the .qvw file:

"Sum ({<[Ano Mes Retorno] = {">="}>}[Valor Realizado Cob - Coop])"

Thanks

Rafael

hello, 

since may 2026 version of nprinting, my reports in high quality fail to generate with an error "object reference not set to an instance... "

the same report in normal quality generates without any problem... 

any suggestions ? 

already increased the rendering and scheduling timeouts

Qlik NPrinting #may2026 @Ruggero_Piccoli 

Hello, 

My use case: I need to highlight all Austrian postal codes (area layer) in a QlikView Geoanalytics map. I tried different ways, but at the moment I have a huge part not colored at all. 

• Taking into consideration Postal Code there is just the Eastern and Northern Part (Lower Austria and Upper Austria) marked in red (standard color for the moment).
• If I use the names of the locations, its either mixing up postal codes, communitiy and regions - so not working.
• Using the community code is not working neither for part of Austrian area.

So for me...mission failed and I really do not understand why! I hope to find somebody here having experience with Austrian maps and is able to support me here.

Thanks in advance!

Gerlinde

Hello, I am trying to create a visual in qlik sense that is a stacked bar chart where there are three measures. I want each measure to be a static color say measure one is revenue (minus profit and expenses) and is to be grey, measure two is profit and is to be green, and measure three is to be red. These measures are calculated within the chart.

Thank you!

INPUT:

Column1

Column2

Column3

Column4

Test1

Test2

2855791

40309730

446057

6119057848

6119057848

6119057848

2855791

40309730

446057

6119057848

6119057848

-

2855791

40309730

446057

6119057848

6119057848

-

2855791

40309730

446057

6119057848

6119057848

-

2855791

40309730

446057

6119057848

6119057848

-

2855791

40309730

446057

6119057848

-

6119057848

2855791

40309730

446057

6119057848

-

6119057848

2855791

40309730

446057

6119057848

-

6119057848

2855791

40309730

446057

6119057848

-

6119057848

2855791

40309730

446057

6119057848

-

6119057848

2855791

40309730

446057

6119057850

6119057850

6119057850

2855791

40309730

446057

6119057850

6119057850

-

2855791

40309730

446057

6119057850

6119057850

-

2855791

40309730

446057

6119057850

6119057850

-

2855791

40309730

446057

6119057850

6119057850

-

2855791

40309730

446057

6119057850

-

6119057850

2855791

40309730

446057

6119057850

-

6119057850

2855791

40309730

446057

6119057850

-

6119057850

2855791

40309730

446057

6119057850

-

6119057850

2855791

40309730

446057

6119057850

-

6119057850

OUTPUT REQUIRED FOR CHART EXPRESSION IN QLIKVIEW:

Column1

Column2

Column3

Column4

Test1

Test2

2855791

40309730

446057

6119057848

6119057848

6119057848

2855791

40309730

446057

6119057850

6119057850

6119057850

Till column 4 data from Table1,  column1 , column2,column3 taken as key from Table 1 , Table2, Table3.

column4 value should match with Test1,Test2 or can be null. Table 2 and Table3 one field name is similar which contains the above values mentioned in the Test1 teast2. Alias field name1 & field name2 

From Table 2 :Tast1 chart condition applied : if (sum(num( column4)=sum(num(field name1),field name1) 

From Table3 :Tast2 chart condition applied : if (sum(num( column4)=sum(num(ffield name2,field name2) 

 I just wanted to show the missing value in the test1 and test2 corresponding to column4

After generating a report on Nprinting, I realized that some of the objects are not present in the final PDF file. Specifically container objects, which I use to group together several objects in an organized way. This happens rather randomly, meaning that it has happened for some containers one day and for others in some other day, both on local and on server (Testing).

I would greatly appreciate any advice on how to solve this matter.

Thank you all in advance.

Regards.

Hello

I want to create an Nprinting report not based on an existing table in Qlik app
the report is very simple
I want to add 4 dimensions and an expression
I know that the expression is created in teh formulas node on the left
but how can I add dimensions to the report (excel format)
Kindly advise

also is there a way to reference a master measure in Nprinting?

Hello
got 3 dimensions in my Qlik sense app:
Month, currency, scenario
I want to create the follwing simple report:

MONTH        CURRENCY        SCENARIO
202601          EUR                    ACTUAL
202601          USD                    ACTUAL
202601          EUR                    BUDGET
202601          USD                    BUDGET

202602          EUR                    ACTUAL
202602          USD                    ACTUAL
202602          EUR                    BUDGET
202602          USD                    BUDGET
...

I create 3 levels in Nprinting report editor as follows:

Now I want to use these in the excel sheet:
which I used as follows:

and the result is not as expected:

kindly advise on how to put the levels on the excel template
@Lech_Miszkiewicz 

How to lease license without port 80? our connection to port 80 is blocked because of security reason, port 4747 and 443 is open
I tried using qvp url, my qlikview desktop still personal edition :

Connected to server OK, No reply received
Switching to HTTPS tunneling
Connected to server OK, Security settings denies access
Switching to HTTP tunneling
Connected to server OK, Negotiations Timed Out

QlikView Version : 12.100

We are trying to hand off more control to our business units and were curious if QlikView has the ability in the QMC to allow for custom admin roles. I know there are options in Qlik Sense, but based on our experience, it seems as though you cannot setup a document admin without giving them the ability to modify (add/remove) users and/or groups from distribution on a task / QVW. Is that something that's possible or is there no such option? 

Hi All,

I've been trying to upgrade Nprinting Feb 2024 SR1 to SR4,  but in most of the after making all the recommended steps, I execute the installer and instead of say "Upgrade" just says "Install".

If I do the install, it creates a new instance of Nprinting along the current install, If I delete the previous version (SR1) and keep SR4, when I restore the repository and start the services, It requires me the licencing again, which I dont have (yet) and I thought it should be automatically.

Please if anyone had the same issue or know what could be I'd really appreciate your help.

Thanks

Hello together,

after experiencing some reload issues, the services were restarted on QlikView November 2017 SR3.

All services except the one mentioned above no longer start. According to the service, the error message “1067: Process terminated unexpectedly” appears.

Unfortunately, the instructions at https://community.qlik.com/t5/Official-Support-Articles/QlikView-Distribution-Service-error-on-start-up-1067-Process/ta-p/1712527 did not help me.

The service user has full permissions on the folder.

The QlikView Events log contains the following:
Server Started Timestamp SeverityID EventID Severity Message
20260612T112119.000+0200 20260612T112120.000+0200 1 300 Error EXPIRED: This engine has expired! Please upgrade to a newer version! Expiry date: 2018/08/30

Strangely, the license information states "PRODUCTLEVEL; 10;;2024-02-29" (Maintenance has already been canceled)

Is there still a way to fix this problem? I also read that I can still update to the latest version UNTIL February 29, 2024—is that correct? Does that date refer to the release of major versions or also to SRs?

Thanks and greetings

Hello Team

   I am using this following link  for creating the DenDiagram, Once i copied and opened the html file i could not able to see any output. Is this code is incomplete

i copied the code at the same folder is R/d3.v3.min.js

                                                              R/flare.json    - this is copied from the site

                                                              R/Den.html

The html code is as followes. Am i need to do any other stuff rather than these three codes.Looking your kind advice