Ask a Question

Welcome to
Qlik Community!

Recent Discussions

Sort By:

Qlik Enterprise Manager

mssql_execute_log_lsn_peeper(...) failed upon SQLExecute with LSN

Hi All, In my project using Qlik Data integration here as Source; Sql server, Target: snowflake After full load of the DB. Iam getting the below errro... Show More

Hi All,

In my project using Qlik Data integration here as Source; Sql server, Target: snowflake

After full load of the DB. Iam getting the below errror. Kindly share your suggestions as soon as possible.

Task is running (sorter.c:714)

00008272: 2024-05-09T09:08:52 [SOURCE_CAPTURE ]I: Throughput monitor: Last DB time scanned: 2024-05-09T10:08:48.357. Last LSN scanned: 00234240:0000621e:0005. #scanned events: 4. (sqlserver_log_utils.c:4994)

00008272: 2024-05-09T09:10:52 [SOURCE_CAPTURE ]I: Throughput monitor: Last DB time scanned: 2024-05-09T10:08:48.357. Last LSN scanned: 00234240:0000621e:0005. #scanned events: 0. (sqlserver_log_utils.c:4994)

00008272: 2024-05-09T09:12:52 [SOURCE_CAPTURE ]I: Throughput monitor: Last DB time scanned: 2024-05-09T10:08:48.357. Last LSN scanned: 00234240:0000621e:0005. #scanned events: 0. (sqlserver_log_utils.c:4994)

00008272: 2024-05-09T09:14:52 [SOURCE_CAPTURE ]I: Throughput monitor: Last DB time scanned: 2024-05-09T10:13:49.073. Last LSN scanned: 00234240:00006221:0005. #scanned events: 4. (sqlserver_log_utils.c:4994)

00008272: 2024-05-09T09:16:52 [SOURCE_CAPTURE ]I: Throughput monitor: Last DB time scanned: 2024-05-09T10:13:49.073. Last LSN scanned: 00234240:00006221:0005. #scanned events: 0. (sqlserver_log_utils.c:4994)

00008272: 2024-05-09T09:18:42 [SOURCE_CAPTURE ]E: mssql_execute_log_lsn_peeper(...) failed upon SQLExecute with LSN parameters '0x00234240:00006221:0005','0x00234240:00006221:0005' [1020102] (sqlserver_log_queries.c:840)

00008272: 2024-05-09T09:18:42 [SOURCE_CAPTURE ]E: Encountered an unexpeceted error. Aborting... [1020102] (sqlserver_endpoint_capture.c:785)

00016960: 2024-05-09T09:18:42 [TASK_MANAGER ]I: Task error notification received from subtask 0, thread 0, status 1020102 (replicationtask.c:3520)

00008272: 2024-05-09T09:18:42 [SOURCE_CAPTURE ]E: Error executing source loop [1020102] (streamcomponent.c:1942)

00008272: 2024-05-09T09:18:42 [TASK_MANAGER ]E: Stream component failed at subtask 0, component st_0_REGISBERMUDA_TEST- Financeapp1 [1020102] (subtask.c:1433)

00008272: 2024-05-09T09:18:42 [SOURCE_CAPTURE ]E: Stream component 'st_0_REGISBERMUDA_TEST- Financeapp1' terminated [1020102] (subtask.c:1602)

00016960: 2024-05-09T09:18:42 [TASK_MANAGER ]W: Task 'Regis BDA Qlik Replication' encountered a recoverable error (repository.c:6049)

00016528: 2024-05-09T09:18:42 [SORTER ]I: Final saved task state. Stream position 00234240:00006221:0005, Source id 170, next Target id 1, confirmed Target id 0, last source timestamp 1715260428863000 (sorter.c:781)

00016960: 2024-05-09T09:18:42 [TASK_MANAGER ]I: Subtask #0 ended (replicationtask_util.c:591)
Show Less

By gopikrishnanS 2024-05-09 / 07:44 AM

2 1 67

Converting Date to MonthYear

Hi, I have a date and time field. I want to convert the field to MonthYear and use it in a line chart. I used the expression below but the line chart ... Show More

Hi,

I have a date and time field. I want to convert the field to MonthYear and use it in a line chart. I used the expression below but the line chart is not showing the monthyear as expected. Can anyone help please. Thank you.

LOAD
"Submission Date",
date(MonthStart(date#([Submission Date], 'DD/MM/YYYY hh:mm')), 'MMM-YYYY') as MonthYearEX,

Submission Date	customer	Amount	Expected
30/01/2022 14:10	John Doe	23	Jan-22
01/08/2023 16:15	John Doe	56	Aug-23
02/07/2021 08:31	John Doe	42	Jul-21
02/03/2024 10:34	John Doe	87	Mar-24
02/06/2024 16:19	John Doe	26	Jun-24

Show Less

New to Qlik Analytics

Mastering Set-Expression

Hi Qlik-Experts, I want to generate a grid chart using two dimensions and calculate the relative fraction but aggregated by one of the dimension. Un... Show More

Hi Qlik-Experts,

I want to generate a grid chart using two dimensions and calculate the relative fraction but aggregated by one of the dimension.

Unforturnately I am struggling right now.

Attached screenshot shows, that the sum per each row seems to work.

The overall "aggregated sum" is also correct (2.540.234), but for my understanding it would need to be shown in each row of the last column.

Could you please help to push me in the right direction?

Thanks in advande
Show Less

By Enno86 2024-05-13 / 06:42 AM

1 0 29
New to Qlik Analytics

How to create YTD's (and MAT's) and create the chart as shown?

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... Show More

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).
Show Less

By DutchArjo 2024-05-13 / 07:14 AM

1 1 24
Mobile

Disable filter popups

Hello,On mobile devices filter clicks result in a popup window.My question;l how to disable this behaviour?The current view is clear enough, i want th... Show More

Hello,

On mobile devices filter clicks result in a popup window.
My question;l how to disable this behaviour?
The current view is clear enough, i want the selected value to be set without any additional popup.
Couldn't find the question/answer on the forum.

Thanx!

Best regards,
Sander Kolkman
Show Less

By SanderKolkman 2024-05-13 / 07:44 AM

0 0 6
New to Qlik Analytics

Only show the newest date (valid from)

Hi there 🙂 I have a list of products with list prices and different valid-from dates to this prices. Now I simply want to show only the newest valid-... Show More

Hi there 🙂

I have a list of products with list prices and different valid-from dates to this prices. Now I simply want to show only the newest valid-from dates (one per product). Thats it 😄

Coud you please help me out with the script function. Attached you find the table load.

Thanks a lot!
Pesche
Show Less

By PescheSwitzerland 2024-05-13 / 02:40 AM

8 0 133
App Development

How to only view records with 1 source

Hi, I need your help quite urgently. I have 2 sources, so 2 fields with the name 'code'. I need to compare them so I added a 'flag' into the sources:... Show More

Hi, I need your help quite urgently.

I have 2 sources, so 2 fields with the name 'code'. I need to compare them so I added a 'flag' into the sources: 'Source 1' as Flag and 'source 2' as Flag.

I need to find the codes who only have 'source 1'. So they are missing in source 2.

All those codes have 2 sources in this example: source 1 and 2.

I only need the codes with source 1 (and not source 2).

load script example (basic):

load

code as 'check code'

Source 1 as Flag

From source 1

load

code as 'Check code'

Source 2 as Flag

From source 2

If I filter on dimension 'Flag' on 'source 1' and select a code, then I remove the filter 'source 1' (so only the code filter left), then there are 2 sources: source 1 and source 2.. Those are the codes I DON'T need..

Can anyone please help me?

Many thanks!

Show Less

By Femke_DPG 2024-05-13 / 07:14 AM

1 2 42
Integration, Extension & APIs

Connect to Engine API from Python script

Hi there 🙂 We are trying to connect to the Engine API of our Qlik Sense Enterprise (on Windows) installation from a Python script, using a websocket.... Show More
Hi there 🙂

We are trying to connect to the Engine API of our Qlik Sense Enterprise (on Windows) installation from a Python script, using a websocket. Qlik is running in a virtual machine in Azure.

After following these instructions on how to call Qlik Sense Engine API with Python (thanks @Damien_Villaret) I get this response:
```
{"jsonrpc":"2.0","method":"OnAuthenticationInformation","params":{"loginUri":"https://server.domain.com/internal_forms_authentication/?targetId={someID}","mustAuthenticate":true}}
```
I understand from other posts that this means that there is a problem at the authentication stage. I have checked our certificates many times and everything seems to be normal there.

In the other hand, we have managed to connect to the QRS from a Python script with "requests". But the authentication through certificates failed again. We could only make it through by using Windows authentication. Which is an option not available to connect to the Engine API using a websocket, if I am not mistaken.

So, it seems that there is indeed a problem with the certificates, although Qlik is working flawlessly (if this helps, I am running the scripts from the same server where Qlik is installed, which is already whitelisted in Qlik).

So the question is: where should I start troubleshooting this issue? The virtual proxies? Security rules? Any kind of additional validation of the certificates I must do in Qlik?

Any orientation will be hugely appreciated.

Best,

Ginés - Solvica

Show Less
By Solvica 2022-12-12 / 10:24 AM

5 1 2162
Qlik Cloud Data Integration

Synced users not able to authenticate

I created 2 tables(qlik_users and qlik_attribute) in database (screenshot attached) and successfully synced then using user directory connector , But... Show More

I created 2 tables(qlik_users and qlik_attribute) in database (screenshot attached)
and successfully synced then using user directory connector ,

But these synced users are failing to authenticate / login to Qlik hub and QMC

Tried different ways to resolve this , -

1. allocated license to user (Analyser and Professional)

2. allocated the role (root admin)

3. tried to check/uncheck "Sync user data for existing users" option

4. create and modify security rules and license allocation rules.

But nothing worked, please help if anyone can provide suggestions

Show Less

By koustubh 2024-05-09 / 11:33 PM

1 1 64
Qlik Application Automation

Compare field value to list of values

Hi everyone, I am currently working on one of my first automations. I have used this very good knowledge base article to create a Loop and reduce auto... Show More

Hi everyone,

I am currently working on one of my first automations. I have used this very good knowledge base article to create a Loop and reduce automation

https://community.qlik.com/t5/Official-Support-Articles/How-to-Loop-and-reduce-with-Qlik-Application-Automation-advanced/ta-p/1834378

I have a working solution. The field I use to loop over has more values than I want to use to create apps from.
To filter them I use a condition. I wanted to list all the values in one condition. For this I tried to separate them by comma or semicolon, but this doesn't work. I also tried to compare with list contains or contains.

Does anyone have a working solution on how to compare to a list of values?

Thanks a lot for your help!

Show Less

By Benno 2024-05-03 / 05:48 AM

3 1 142

High Five

Meet Maxime

Our featured member for May 2024

Leaderboard

igoralcantara

marksouzacosta

Heinvandenheuvel

TomBond77

mpc

Lech_Miszkiewicz

Popular Resources

View All

Customer Story

Qlik Data Integration & Qlik Replicate story

Qlik enables a frictionless migration to AWS cloud by Empresas SB, a group of Chilean health and beauty retail companies employing 10,000 people with 600 points of sale.