Skip to main content

Welcome to
Qlik Community!

cancel
Showing results for 
Search instead for 
Did you mean: 
  • 214,312 members
  • 5,208 online
  • 1,989,530 posts
  • 149,021 Solutions
Announcements
Qlik Community Office Hours, March 20th. Former Talend Community users, ask your questions live. SIGN UP

Welcome to Qlik Community

Recent Discussions

  • forum

    Qlik Replicate

    Qlik Replicate Filter Expression

    Hi everyone, I wanted to apply the below filter on replicate but dont know whats the correct syntax for that , can someone help me on this select * fr... Show More

    Hi everyone,

    I wanted to apply the below filter on replicate but dont know whats the correct syntax for that , can someone help me on this

    select * from CMS_BDR_AGG_GROUP where keysum not in (select distinct '%X'||agg_id||'X%' as keysum from CMS_REF_AGG where (agg_type=3 and NAME='HBCA') OR (agg_type=2 and NAME like '%HBCA%')) ;

    MSSOT_RIVA_HSBC1_0-1710822642487.png

    MSSOT_RIVA_HSBC1_1-1710822844065.png

     

    Show Less
  • forum

    Qlik Compose for Data Warehouses

    How to connect SQL server into QlikView

    Hi, I have databases in PostgreSQL, and I want to import data from PostgreSQL into QlikView. How can I do that? Thanks
  • forum

    New to Qlik Analytics

    Color Expression issue with Dimension group

    Hi Team, I've created a bar graph in Qlik, where I've organized the data by month to visualize both January and February. Each bar represents four mon... Show More

    Hi Team,

    I've created a bar graph in Qlik, where I've organized the data by month to visualize both January and February. Each bar represents four months of data; for example, in the January bar graph, I'm displaying data from October, November, December, and January. I've implemented a condition in the graph where the color of the bar changes based on certain criteria. If the percentage of the smallest month's classification is less than 100%, the bar turns red. If it equals 100%, the bar turns green. Otherwise, all other months will be represented in blue. This condition is working correctly for January, but not for February. What might be the reason for this discrepancy?
     
    Formula used in Color expression:
     
    if((['Month-Year']) = Min(total(['Month-Year'])) and [Percentage Classified] < '100.0%' and ['Month-Month'] = 'January' or ['Month-Month'] = 'February', 'Red', 
    If((['Month-Year']) = Min(total(['Month-Year'])) and [Percentage Classified] = '100.0%' and ['Month-Month'] = 'January' or ['Month-Month'] = 'February', 'Green', 'Blue'))

     

    Attached are the visualization that i need and currently i am getting

     

    @sunny_talwar Qlik Sense Business 

    Show Less
  • forum

    Qlik Replicate

    AWS RDS for Postgres as source - supported versions

    Hi Qlik Community Replicating from a Postgres read replica is merely impossible on the currently supported versions. However, Postgres 16.1 does allow... Show More

    Hi Qlik Community

    Replicating from a Postgres read replica is merely impossible on the currently supported versions. However, Postgres 16.1 does allow read/write on read replicas which enables setting the wal level to 'logical' on the read replica. This is significant progress as Teams opt to use read replicas instead of replicating directly from the primary instance.

    That said, there's limitations like enabling 'Create DDL events' and 'WAL heartbeats'. We'd like to capture the DDL events, and also benefit from keep the slots alive. But these require a 'create statement being run, and Postgres 16.1 is also not supported. Currently we don't have a solution for reading from a Postgres read replica if we want to replicate changes - 'cause full load works but not viable for large databases.

    Can I ask if there's plans to include Postgres 16.1 on the supported source endpoints. If so, when? And if we'd be able to replicate from a read replica, plus benefit from 'Create DDL events' and 'WAL heartbeats'.

    Regards.

    Show Less
  • forum

    Qlik Replicate

    Handling LOB columns w/o PK

    I'm trying to replicate a table from MS SQL Server to SF, and setting the task to be Full Load only. This table has an LOB column and it has no PK. Pe... Show More

    I'm trying to replicate a table from MS SQL Server to SF, and setting the task to be Full Load only. This table has an LOB column and it has no PK.

    Per the post attached below: "A full load-only task can get around a limitation with LOB columns that are in a table with no primary key.", I followed the post to set the task so that "Full Load Processing is ON", but the LOB column is still skipped when loading.
    https://community.qlik.com/t5/Official-Support-Articles/An-Introduction-to-Qlik-Replicate-Tasks-Full-Load-vs-CDC/ta-p/2019167

    Could you please kindly advise if this is not a valid walkaround, and the only solution is to add PK to the source table? 

    Show Less
  • forum

    Qlik Replicate

    Disable a task so that it cannot be resumed or restarted

    Hi team, Do you have any functionality in Qlik Replicate or AEM to disable few tasks or a particular task when an issue occurs at the source to preven... Show More

    Hi team,

    Do you have any functionality in Qlik Replicate or AEM to disable few tasks or a particular task when an issue occurs at the source to prevent the data corruption at the target so that it cannot be resumed or restarted manually.

    Please suggest.

    Thank you,

    Pranathi

     

     

    Show Less
  • forum

    Qlik Replicate

    Running the same query on Postgres DB and Qlik Replicate but the output is diffe...

    Hi All, I'm running the same query directly on the Postgres DB and from Qlik replicate Postgress DB source, the output the data returned are different... Show More

    Hi All,

    I'm running the same query directly on the Postgres DB and from Qlik replicate Postgress DB source, the output the data returned are different.

    Does anyone know, what is the logic and why it is different?

    Here is my query:

    text='' OR text is NULL) and timestamp >'2023-06-30 12:56:28.714588' and  (1=1) order by 1 ASC LIMIT 100;--?

     

    Show Less
  • forum

    Installing and Upgrading

    Talend does not open after update

    Hello, I use Talend 7.3.1 and today, when I open Talend, I have a red message telling me update is required, and the button "update". After click in t... Show More

    Hello,

    I use Talend 7.3.1 and today, when I open Talend, I have a red message telling me update is required, and the button "update". After click in this button, Talend does not open any more.

    A log file is created in configuration folder after I click on Talend-Studio-win-x86_64.exe.

    but no error inside, only:

    !SESSION 2024-03-18 18:21:26.978 -----------------------------------------------
    eclipse.buildId=unknown
    java.version=1.8.0_202
    java.vendor=Azul Systems, Inc.
    BootLoader constants: OS=win32, ARCH=x86_64, WS=win32, NL=en_US
    Command-line arguments: -os win32 -ws win32 -arch x86_64

    !ENTRY org.talend.platform.logging 1 0 2024-03-18 18:21:30.564
    !MESSAGE 2024-03-18 18:21:30,557 INFO org.talend.platform.logging.Activator -
    !!------------------------------------------------------------------------------!!
    !! !!
    !! TALEND !!
    !! Starting Talend's platform log system.VERSION= 7.3.1.20220906_1110-patch !!
    !! !!
    !!------------------------------------------------------------------------------!!

    how can i fix this?

    Thanks in advance

    Show Less
  • forum

    Design and Development

    javax.net.ssl.SSLHandshakeException: PKIX path building failed

    Hi Team I was having a job which was running without any issues for last few months. But suddenly the job got failed with the below issue. Exception i... Show More

    Hi Team

    I was having a job which was running without any issues for last few months. But suddenly the job got failed with the below issue.

    Exception in component Common_Access_token_Generator_1_tREST_2
    com.sun.jersey.api.client.ClientHandlerException: javax.net.ssl.SSLHandshakeException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target
    at com.sun.jersey.client.urlconnection.URLConnectionClientHandler.handle(URLConnectionClientHandler.java:155)
    at com.sun.jersey.api.client.Client.handle(Client.java:652)
    at com.sun.jersey.api.client.WebResource.handle(WebResource.java:682)
    at com.sun.jersey.api.client.WebResource.access$200(WebResource.java:74)
    at com.sun.jersey.api.client.WebResource$Builder.post(WebResource.java:570)

    Please help in resolving this issue.

    Show Less
  • forum

    Qlik Reporting Service

    Pages and Levels - Sorting

    Hi!  I have a requirement to generate a report with Excel sheets for a set of months.  This works fine but how do I show the most recent month as the ... Show More

    Hi!  I have a requirement to generate a report with Excel sheets for a set of months.  This works fine but how do I show the most recent month as the first worksheet?

    Show Less
Leaderboard

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.

Customer Story

Building a Collaborative Analytics Space

Qlik Luminary Stephanie Robinson of JBS USA, the US arm of the global food company employing 70,000 in the US, and over 270,000 people worldwide.

Location and Language Groups

Choose a Group

Join one of our Location and Language groups. Find one that suits you today!

Collaborate

Healthcare User Group

Healthcare User Group

A private group is for healthcare organizations, partners, and Qlik healthcare staff to collaborate and share insights..

All are welcome

Japan Group

Japan

Qlik Communityの日本語のグループです。 Qlik製品に関する日本語資料のダウンロードや質問を日本語で投稿することができます。

Request to join

Brasil Group

Brazil

Welcome to the group for Brazil users. .All discussions will be in Portuguese.

open to all

Blogs

Community News

Hear from your Community team as they tell you about updates to the Qlik Community Platform and more!