community.qlik.comHome | Qlik Community

Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you. Expand Qlik.com | Qlik Help | Resources Ask a Question All community Knowledge base Users Products cancel Turn on suggestions Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type. Showing results for Search instead for Did you mean: Help Sign In / Register All community Knowledge base Users Products cancel Turn on suggestions Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type. Showing results for Search instead for Did you mean: Forums Support Discover Greenway Opens new window Qlik.com Qlik Help Resources Welcome to Qlik Community! All community Knowledge base Users Products cancel Turn on suggestions Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type. Showing results for Search instead for Did you mean: 219,386 members 6,070 online 1,998,258 posts 149,820 Solutions Announcements Qlik Community Office Hours - Bring your Ideation questions- May 15th, 11 AM ET: REGISTER NOW Welcome to Qlik Community Recent Discussions Select Board(s)... Clear Go Recent Unanswered Unsolved Solved Sort By: Select Filters Most Popular Most Viewed Most Recent Thread Most Recent Reply App Development Can I use the new version of the visualization bundle without a QS upgrade? Hi, I’m using the November 2023 version of QS.And I want to use the February 2024 version visualization bundle without a QS upgrade.Is it possible? By MeehyeOh 2024-05-13 / 07:25 PM 2 6 76 Qlik Replicate ODBC with CDC backend is progressDBwith update expression. We are trying to do CDC process in qlik with ODBC connection and backend is ProgressDB. For CDC we found in source connections, under Change processin... Show More We are trying to do CDC process in qlik with ODBC connection and backend is ProgressDB. For CDC we found in source connections, under Change processing we have Context Column settings and Expressions to identify Update and Delete Operations. What is the definition of context column, what if we have all the column at source apart from primary key any non-primary key changes how will qlik identify the changes. Is it possible or do we have to ive update expression. and if we have to provide update expression please let provide us an example how the update expression. Thanks, snigdha Show Less By Snigdha174 2024-05-09 / 01:33 PM 2 2 95 Featured Members Qlik sense connect snowflake hello everyone, An error occurred when I was creating a snowflake connection : "Connections are only allowed to *.snowflakecomputing.com hosts. " . It... Show More hello everyone, An error occurred when I was creating a snowflake connection : "Connections are only allowed to *.snowflakecomputing.com hosts. " . It seems that the official snowflake driver does not support ".cn" ending hosts. How can I avoid this problem? Do I need to modify the driver configuration file? Show Less By WangFei 2024-05-13 / 09:00 PM 0 0 4 Qlik Cloud Data Integration How to connect PostGres SQL database hosted on GCP using QlikSense on prem We are trying to connect to PostGres SQL database hosted on GCP (Google Cloud Platform). We tried using ODBC connector but GCP does not allow static p... Show More We are trying to connect to PostGres SQL database hosted on GCP (Google Cloud Platform). We tried using ODBC connector but GCP does not allow static password for the connection. How do we connect to PostGres Database on GCP using QlikSense connector? @gcp @postgresSQL @qliksense Show Less By ni3surnar 2024-05-13 / 08:58 PM 0 0 8 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 3 1 92 Qlik Replicate sys.dm_database_encryption_keys migration Is there a way to migrate sys.dm_database_encryption_keys from source, to target database?I have ’always encrypted keys’ - column master keys, and col... Show More Is there a way to migrate sys.dm_database_encryption_keys from source, to target database? I have ’always encrypted keys’ - column master keys, and column encryption keys in source database. However, when I finish the migration, at target, I don’t see these information. As well as at target, the "sys.dm_database_encryption_keys" don’t have any encryption information. Show Less By janezhang401 2024-05-07 / 08:09 AM 5 2 192 Qlik Replicate Date format issue Hi Team, Facing date issue. In the source the date column values are 04/30/2023, 04/23/2023...... , But in the target we are getting in this way Targ... Show More Hi Team, Facing date issue. In the source the date column values are 04/30/2023, 04/23/2023...... , But in the target we are getting in this way Target : 1970-01-01, 1970-02-05............. source : SAPHANA Target : snowflake Its a full load task Request your help. Thanks. Show Less By suvbin 2024-05-13 / 07:43 PM 1 1 61 New to Qlik Analytics If Statement Can anyone please tell me what If statement I need to use in Bar Chart measure, where Count only shows "BRKDWN"? I need Barchart to ignore "PM". ... Show More Can anyone please tell...