All Forums

Hi,

I am using Pixel perfect report where I need to add Pivot table, but I don't have direct Pivot table option.

And I don't have vertical Detail band also Kindly help how to achieve a Pivot table.

Thank You

Hello Qlik Community !

Environment
Product: Qlik Sense Cloud
Feature: GeoOperations / ScriptEval
Usage: Chart expression (not load script)

Data model

Table: Concurrents
Fields:

• ID_Concurrent

• [Coordonnées du concurrent]
  Format example:
  [1.0309 1.03848]
  (string)

Table: Magasins
Fields:

• ID_Magasin

• TravelArea
  Geometry type: POLYGON
  TravelArea is dynamically calculated based on selections (duration, transportation mode, etc.) and works correctly on maps.

Objective

On a map, I display stores (Magasins) and competitors (Concurrents).
The TravelArea (catchment area) changes dynamically based on variables.

Goal:
Display only competitors that are inside the selected TravelArea using a GeoOperations Within() directly inside a chart expression.

Expression used

GeoOperations.ScriptEval(' Within() DATASOURCE enclosed INTABLE keyField="ID_Concurrent", crs="auto", pointField="[Coordonnées du concurrent]" DATASOURCE enclosing INTABLE keyField="ID_Magasin", geometryField="TravelArea", geometryType="POLYGON" ', Concurrents)

Error message

grpc::StatusCode::INVALID_ARGUMENT: GEOOPS-401: Missing column in indata: ID_Concurrent

Issue / Questions

• ID_Concurrent clearly exists in the Concurrents table

• [Coordonnées du concurrent] also exists and contains valid point coordinates

• The error persists even when simplifying the expression

Questions:

1. Is GeoOperations.ScriptEval with Within() fully supported inside chart expressions in Qlik Cloud?

2. How does INTABLE resolve columns when multiple logical tables are involved?

Any help or working example would be appreciated.

Thanks,
Théo

Hi, 

We have on demand nprinting report that we are running from our inhouse tool. Report is setup with override filter values which business can change example. Client name, date range. 

We have a requirement, where we will create a flag filter as below

Data Complete Flag: (if Umbrella name is mapped in data for Client, it should be considered as 'Complete' and report will run and generate output). If Umbrella is not mapped to Client that is null or empty field and Business runs the report with Default value as Complete. They report should succeed without output. This will show business that there is nothing wrong with report they have to check their data mapping. 

Currently when we are running the report with Complete filter value. Nprinting is failing it with a generic error that "Qlik failed to run the report". when we run with Incomplete value in the flag it runs with empty report.  

can you please guide how to achieve this. 

Umbrellaname_Flag is the filter we will use as Data complete Flag. We are unchecked the Override box to run the report from nprinting designer. 

Also, we have option in Nprinting report setup: Do not generate report. Report generation will fail until issue is resolved. How does that work ? When we have empty report in above scenario it should not generate. 

Nprinting Version: Feb 2025 SR2

They fail with the error:

20251218T053000.193-0500 Information DistributeTask[9a00f324-5683-4dbb-aa1b-40b11dc529e8] ("Public/Parcs_Tier1_Yearly_Job.qvw"): TryStart - Starting task. Triggered by 'ScheduleTrigger'. Id:2236daf2-032d-46af-8cc4-a18d01d37f69. ExecID:09b2530b-d170-4aec-b085-f683caf1a809
20251218T053000.224-0500 Information Entering Task Execution.
20251218T053000.224-0500 Information ClusterID=1
20251218T053000.224-0500 Information QDSID=0e3bf7ce-ac85-88c6-d49a-1664c1dd3545
20251218T053000.224-0500 Information TaskID=9a00f324-5683-4dbb-aa1b-40b11dc529e8
20251218T053000.224-0500 Information ExecID=09b2530b-d170-4aec-b085-f683caf1a809
20251218T053000.224-0500 Information MaxRunTime=06:00:00
20251218T053000.224-0500 Information MachineName=VBZA15-IP19DS
20251218T053000.224-0500 Information Task execution max attempts=1
20251218T053000.224-0500 Information Task execution current attempt=1
20251218T053000.224-0500 Information Task Dependencies are OK
20251218T053000.242-0500 Information The task "Public/Parcs_Tier1_Yearly_Job.qvw" is starting
20251218T053000.323-0500 Error The task "Public/Parcs_Tier1_Yearly_Job.qvw" failed. Exception: || QDSMain.Exceptions.TaskFailedException: Task execution failed with errors to follow. ---> System.ArgumentNullException: Value cannot be null. || Parameter name: stringToUnescape || at System.Uri.UnescapeDataString(String stringToUnescape) || at QDSMain.DistributeTask.GetFileName(SourceDocumentFileName fileNameUrl) || at QDSMain.DistributeTask.PerformExecute(IExecutingTaskResult executingTaskResult) || --- End of inner exception stack trace --- || at QDSMain.DistributeTask.PerformExecute(IExecutingTaskResult executingTaskResult) || at QDSMain.Task.AbstractTask.TaskExecution(CurrentExecutionArgs args)
20251218T053000.323-0500 Information Task Execute Duration=00:00:00.0988558
20251218T053000.338-0500 Information TaskResult.status=Finished
20251218T053000.370-0500 Information Notifying all triggers of new state: "FinishedWithErrors"...
20251218T053000.370-0500 Information Notifying all triggers of new state: "FinishedWithErrors" - Completed

Hi All,

I have a data model where Sales and Inventory tables are concatenated into a single fact table. Both datasets share the same field name: StoreCode

Table Format:

StoreCode ItemCode ColorCode  Sales Inventory

A100          ABCD       red              1000  0

A100         XYZ          blue             500   0

A200         E               black           100    0

Now I would like to calculate Inventory. Currently, I use this formula:

Sum({<MyDate= {'>=$(start_date) <=$(=today_date)'},StoreCode={'WR-ON-008'}>}InventoryQTY)

The Problem: I am using a table with StoreCode as a dimension. I want to show a column for "Warehouse Inventory" specifically for warehouse 'WR-ON-008' regardless of the store on the current row.

When the table row is StoreCode = 'A100', the column returns zero because the engine tries to find rows where StoreCode is both 'A100' and 'WR-ON-008' simultaneously, which is impossible.

I know renaming the field to WarehouseCode in the script would solve this, but my model is too large to refactor right now.

Is there a way to ignore the dimension's selection on StoreCode but force the set analysis filter for 'WR-ON-008' on the same field in the frontend?

Hi everyone,

we’re experiencing a strange and recurring issue in one of our QlikView applications, and I’m wondering if anyone else has seen something similar or has any suggestions on how to prevent it.

We have a pivot table that contains a large number of metrics. Since expanding it to full width by default would be impractical, we’ve set its width manually to around 750 pixels. Above the table, we use a toggle button (styled as a collapsible/expandable arrow) that switches a variable vMaximize. Based on this variable, the table either expands to full width or stays collapsed – this setup works well and allows users to control the view as needed.

However, every few months, the application seems to "break" on its own. The pivot table suddenly expands to full width permanently (e.g., around 4000 pixels), the toggle arrow either disappears completely or stops responding, and when we inspect the object, the fixed width has changed – no one has touched the application or edited the layout in the meantime. It's as if QlikView silently overwrites the original object settings.

Has anyone else encountered this behavior?

• Is there a known bug or cause behind this kind of spontaneous layout change?

• Could it be related to server caching, corrupted object state, or QVW auto-save behavior?

• Is there any way to lock object dimensions or prevent QlikView from changing them unexpectedly?

Any insights or suggestions would be greatly appreciated – this issue is quite frustrating since we have to manually fix the layout every time it happens.

Thanks in advance!

Eva

I have this massive expression to work out a standard discount on 4 separate straight tables that is causing me a lot of problems when its being opened in Access Point or if its even opened like normal in QlikView (either doesn't load the table for about 15 minutes or crashes completely). It works fine without the expression so I know that is what is causing the problem but I don't know why its causing these problems.

Is there anything anyone can see in there that might be causing the problem?

=num(

1-(

(if(IsNull([Std Disc%]),1,(1-[Std Disc%]))*(Sum( {<PARTS_TYPE={'Wholegoods'},SHIP_FROM_ORGANIZATION_NAME={'IM','ID'},PD={'1'},DATE_TYPE={'SHIP_DATE'},CM={1},FiscalMonth=,FiscalQuarter=,FiscalYear=>}(UNIT_LIST_PRICE_GBP))))

     /

   Sum( {<PARTS_TYPE={'Wholegoods'},SHIP_FROM_ORGANIZATION_NAME={'IM','ID'},PD={'1'},DATE_TYPE={'SHIP_DATE'},CM={1},FiscalMonth=,FiscalQuarter=,FiscalYear=>}(UNIT_LIST_PRICE_GBP))

    )

,'#.0%')

Hello everyone,

I would like to calculate different routes in GeoAnalytics using the Routes operation. However, for some routes I get the error “NO_ROUTE_FOUND: No route found: Max Iterations”.

For example, I get the error for the route from Lisbon to Riga. But if I split the route and calculate Lisbon - Berlin and then Berlin - Riga, it works.

What is the reason for this? I suspect that too many steps have to be calculated for Lisbon to Riga.

Is there a workaround or alternative to get around this problem?

Transportation is "Car". The error occurs for both the shortest and fastest route.

Many thanks,

Best regards, Martin

Hello,

We have a growing number of customers who rely on Qlik NPrinting for their email reporting distribution via Office 365 (Exchange Online).

As many of you know, Microsoft has been proactively disabling Basic Authentication for SMTP AUTH, with a final deadline for full retirement currently set for April 2026.
Exchange Online to retire Basic auth for Client Submission (SMTP AUTH) | Microsoft Community Hub

Since NPrinting currently only supports Basic Authentication for its built-in SMTP connection, this presents a significant problem for many organizations.

The Problem

• NPrinting currently does not support OAuth 2.0 (Modern Authentication) for connecting to smtp.office365.com.

• As Microsoft retires Basic Auth, our current reporting setup for many customers will break entirely.

My Questions for the Community & Qlik

1. Is there any official roadmap information regarding the implementation of OAuth 2.0 / Modern Authentication for NPrinting's SMTP configuration?

2. What is the long-term, supported strategy for Qlik NPrinting to connect to Microsoft 365 mailboxes for report distribution?
   
   Qlik NPrinting

Hello Everyone,

I needed help in exporting single/all objects from one qlikview(.qvw) file to another Existing qlikview(.qvw) file.

The imported object should get appended to new sheet i.e. the existing objects on the file should not get deleted.

Is there any way out?

Please help.

Regards,

Pratik

I have pivot table which was created in one of the earlier versions of Qlikview file and somehow got removed in subsequent version.

I need that pivot table back in the latest version but I was not able to copy the pivot table object. I was able to create export file (QVO file) for the object. How could that file be imported into the latest version where I need the object to be?

Hi all,

I have used the examples from Connector Examples Qlik GeoAnalytics - Qlik Community - 1548148 and was able to run them fine. The code block that gets generated after successful completion of within operation is :

data:
load * Inline [
id,lat,lon
1,25.8587,-80.2094
10960,31.1073,-97.7479
22821,42.6722,-83.1335
];