Hi All,

We are currently on May 2023 Patch10 version with Postgres12.

Understand from our security team that there are the below two vulnerabilities for Postgres

1. Cross-Site Scripting Vulnerability (CVE-2024-4216)

This vulnerability exists in pgAdmin, specifically inside the /settings/store API response json payload. Exploiting this vulnerability could allow a threat actor to execute malicious script on the client end and steal sensitive cookies.

1. Multi-Factor Authentication Bypass (CVE-2024-4215)

This vulnerability affects pgAdmin, which could allow a threat actor to bypass multi-factor authentication on affected versions.

Is anyone aware if it affect Qlik Sense enterprise on windows?

Thanks & Regards

Amar Shedage

I have Project and time slot in seperate tables.

I want to schedule time slot for group of projects based on certain condition.

If 1. Project review is 1st review schedule 45 mins

   2. Project review is not 1st review schedule 15 mins

Schedule Time (9:00 am to 11:300 am) for every monday.

Project Data:

Project ID, Review, Date, Region,  Time Slot, Status

A, 1st Review, 5/13/2024, AP,<Fill the Time slot> , <USED- if alloted, Otherwise BLANK>,

A, 2st Review, 5/13/2024, AP,<Fill the Time slot> , <USED- if alloted, Otherwise BLANK>,

A, 3st Review, 5/20/2024, AP,<Fill the Time slot> , <USED- if alloted, Otherwise BLANK>,

A, 4st Review, 5/20/2024, AP,<Fill the Time slot> , <USED- if alloted, Otherwise BLANK>,

B, 1st Review, 5/13/2024, AP,<Fill the Time slot> , <USED- if alloted, Otherwise BLANK>,

B, 2st Review, 5/20/2024, AP,<Fill the Time slot> , <USED- if alloted, Otherwise BLANK>,

C, 1st Review, 5/13/2024, AP,<Fill the Time slot> , <USED- if alloted, Otherwise BLANK>,

C, 2nd Review, 5/13/2024, AP, <Fill the Time slot> , <USED- if alloted, Otherwise BLANK>

Timeslot Table 

Output:

Project ID, Review, Date, Region,  Time Slot, Status

A, 1st Review, 5/13/2024, AP,9:00 - 9:45 , USED,

A, 2nd Review, 5/13/2024, AP,9:45 - 10:00 , USED,

B, 1st Review, 5/13/2024, AP,10:00 - 10:45, USED,

C, 1st Review, 5/13/2024, AP,10:45 - 11:30, USED,

C, 2nd Review, 5/13/2024, AP, No Slot available, Not Confirmed,

Hello all,

We have a replicate job that uses postgreSQL as source and both Kafka and Oracle as endpoint.

Some columns in our tables have a single space as value. (So " ") This is replicated fine to Oracle, we can see the length is 1 and the columns in questions are non nullable so that works.

However in our Kafka message for the same action the value is given as "", so no single space anymore but NULL. I only found a mention of this type of behavior for Oracle as source in case of CHAR columns so it comes unexpectedly to us.

Is there a way to keep the space (so the actual value) in the Kafka message? 

Hello,
we are migrating a lot of applications from QlikView to Qlik Cloud (Qlik Sense).
and following Qlik's best practices, we have a lot of different spaces on different tenants.

As a consequence, user management is a huge task and we need to use user's group to handle this. As far as I know we can't create users groups natively (?) ,
we tried Google authentication and it not seems possible either to create group (to be precise, it's seems not possible to use directly a group from Google in the Qlik Cloud interface). If we need to change right or to delete an user, I don't want to manually check hundreds of space / applications properties to check if the user have some rights on it

Do you have recommendations on how to be able to manage Space security with group ? How can we do this ? If you doesn't use groups, do you have others ideas to handle it ?

Best regards

Hello,

I am trying to input more than one string in a variable and the best I could come with is this...

Hi there,

I am trying to compute a 5-weeks moving average correctly to display it in a graph in a Nprinting report.

Basically my data looks like the attached example : 

- week id

- Nb is my measure

- Moving average 5 weeks : the 5-week moving average of the measure "Nb"

I want to display "Nb" and its "Moving average 5 weeks" only over the last 10 weeks, so between week 202411 and 202420 in my example.

But for weeks 202411 to 202415, I need older data points to be able to compute properly the 5 weeks rolling average, example : 

Moving average 5 weeks for week 202411 = (120 + 200 + 27 + 128 + 625 )/5 = 220

Problem : if I filter on the last 10 weeks only, I miss older data required to compute properly the 5-weeks rolling average. For 202411, I will only get 120/5 = 24 which is wrong.

How can I do to compute properly the moving average for each point and only then, filter to display only the 10-week period of my interest ?

What I have already tried without success :

- compute the moving average in QlikSense and then filter on 10 last weeks in Nprinting graph : FAILED

- filter on 20 last weeks in Nprinting graph to get correct moving average value and then apply an additional filter on 10 last weeks at task level (hoping the aggregation would be performed before the final filter on period) : FAILED

Thanks for your help

Hi all

I have a published QS application that's being reloaded every morning. The reload finishes around 05:15 local time.
I have a Qlik NPrinting report based on that application that generates the report at 06:20 local time.

Issue at hand is that the report at 06:20 does not contain the latest data.
If I run the report again at a later time, without reloading the Qlik Sense app, reloading any meta data,... the report does contain the latest data.

I'm baffled how  this is possible.
Is there any kind of delay between QS Enterprise en Qlik NPrinting? Can I resolve the issue if I schedule a metadata reload task?
Any help is appreciated.

Kind regards,
Tim P.

I've been trying all day to create YTD perios in order to create a chart showing figures compared over the current year period. I'm used to having YTD's in my data and simply adding them to my chart in Excel but in Qlik, I can't seem to work this out.

Below is how I would have it created in Excel:

This makes an easy year on year comparison possible.

But how can I get ytd's and add them to a grouped bar chart like above AND have these refreshed automatically upon a new data load?

I' ve been puzzling with expressions for dimensions in the chart but that didn't work out, I tried to add a variable containing the YTD (add wanting to add YTD-1 and YTD-2 later on).

Hi,

I have migrated a .nsq file from NP-v16 to the Qlik Nprinting 2021 and changes to reports.

Now i want to import only one specific Report from .nsq zip file to overwrite the recent changes.

When i clicked on Import NP 16 Report(as in below screenshot), it shows all the other report except the report I want to replace. 

Any suggestions, please.