I've created a table in Qlik Cloud with a column representing images from a URL. This works fine. But when I create a tabular report, refering to the created table, the images are not presented in the output of the report. 

Is there are solution for this? 

Hello there!

I have two tables, one called Packages and the other called Sales. Packages has 40 items in only one field and Sales has 10,000 items with different fields. 

For the sake of simplicity I will use “examples”, not the real, long field contents. 

Packages has these items: A1, X3, W6, H8.

Sales has one field (out of many) that often contains, among long strings of texts, the items listed in Packages and others, called Purchased, as follows:

SaleNo… Purchased

721.    A1,,,,

5.    X3;;; H8::: Z7 asdfghjkl Q4

36.    A1;; .. W6 fgdshg H8

807.    Sawtfcd hgfd kkklg sddfd

15. ssdfd X3 gfgdddljj poiigvf C5 H7 V2

205. H8.cvc hbbb A1

At load script I need to find and tag all Sales.Purchased the items where the items in Packages are found. It can be in one additional field or more than one, as long as I get, for instance, that SaleNo 5 contains X3 and H8, SaleNo 807 has no matches, SaleNo 205 contains A1 and H8, etc. And it is not a binary tag, I need to know which Package is in Purchased. 

My problem is to go through each item in Packages browsing all items in Sales to find out what Package matches within Purchased.

Any hints are appreciated. Thanks!

Hi all,

I am wanting to show the sum of what my projections are up to today, so I can compare them to the actual. My [Gross Collections WB VAF12] is my projected values. I am from an R background so I was thinking of using a 'where' statement but I am unsure how to do this in Qlik. I have attached the chart and a snippet of the code for this section below. I basically want the sum of the total predicted collections up to today.  I am hoping to show the value in a text box.

Thank you in advance.

Hi,

I just wanted to know, is it possible to user Service Now as a source endpoint in Qlik Replicate? I saw a prior Community case saying that it is possible using the ODBC endpoint yet there is no other information about it.

Are there any issues or pitfalls to it? Has anyone configured it before? Thank you.

Regards,

Mohammed

Has anyone created a Replicate task for ServiceNow? More specifically, have you implemented the ServiceNow ODBC driver? 

When we replicate tables now, we don't see the tables as it would look with the ODBC connector. I see there's a connector for Sense, but not sure if that would work the same.

Session Monitor not showing older than May, 2024. 

Where it gets/reads from?

From Central Log folder, all nodes log folder and/or ArchvedLogs?

Platform: Multi node Qlik Sense February 2024 P5 Windows Enterprise.

Thanks

Hello,
We have a language difference for error messages when there is no data, the message is different between the QlikView application and the report generated by Nprinting.
The application was loaded correctly, as was the metadata, but there is a language difference.
we have test :
- Modification of the expression: in Qlikview it's in French, but in Nprinting it's in English.
- Modification of calculation conditions: in this case, the correct language is taken into account.
However, in this case we have to create a new expression for each case.

can you help me

here are the screenshots

In qlikview  :

In nprinting : 

Thanks in advance

Hello, Qlik Compose community. I just discovered (after months of interacting with type 2 dimensions in our data warehouse) that the FromDate and ToDate timestamps are in UTC, not server time.

Stumbled upon a record with a FromDate that looked like it had a timestamp a few hours in the future, thus uncovering the issue. Didn't see anything in the documentation clarifying this, so figured y'all would want to know.

Qlik Compose for Data Warehouses Qlik Compose 

Hi everyone,

I recently switched from NPrinting 16 to NPrinting May 2023 SR3 and QlikView May 2023 SR1. My QVF/QVW document gets refreshed daily on the QlikView server.

Initially, I noticed that my NPrinting report worked once, but the next day it was sent empty (charts and tables were present, but no data). After tinkering in the NPrinting web console, it worked again once, but then the next time it was empty again.

Later, I discovered that I needed to schedule a metadata refresh to run before the publishing task. Is this the correct approach, or am I doing something wrong?

If scheduling a metadata refresh is necessary, is there a way to automatically trigger the report publishing right after the metadata gets refreshed?

Thanks for your help!

I'm not sure if this is relevant or not. The data in the report is dependent on a date parameter that gets passed from NPrinting filter which is usually today(1)-1  with evaluate ticked.