Skip to main content

Welcome to
Qlik Community!

cancel
Showing results for 
Search instead for 
Did you mean: 
  • 218,445 members
  • 6,852 online
  • 1,996,765 posts
  • 149,688 Solutions
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE

Welcome to Qlik Community

Recent Discussions

  • forum

    Qlik Replicate

    Failure in associating MetadataManager TABLE_DEF with CDC_TABLE_ENTRY"

    One of on our tasks, we periodically get the following error messages:Unable to get TABLE_DEF for capture table [dbo.TableNAme]Failure in associating ... Show More

    One of on our tasks, we periodically get the following error messages:
    Unable to get TABLE_DEF for capture table [dbo.TableNAme]
    Failure in associating MetadataManager TABLE_DEF with CDC_TABLE_ENTRY"

    We are using  SQL Server RDS as an Endpoint - NOT MS-CDC.  

    Any help is appreciated!

     

    Show Less
  • forum

    Qlik Replicate

    Qlik replication - Filter condition

    My Task without filter condition has already completed full load, now I want to add a new filter condition for CDC records to exclude some records bas... Show More

    My Task without filter condition has already completed full load, now I want to add a new filter condition for CDC records to exclude some records based on source column value.

    I tried with adding below filter condition and record selection condition but both scenarios I am  getting weird results:

    Col Name is Cloud_migrt_ind.

    • CLOUD_MIGRT_IND

      STRING(1)

      Regular

      Exclude

      'Y'

    •  $CLOUD_MIGRT_IND != 'Y'

    Can you suggest the best way to add filter condition to exclude record based on column value ?

     

    Thanks,

    Srinivas 

    Show Less
  • forum

    New to Qlik Analytics

    Question: Creating a calculated measure from a dimension

    Hi everyone, new here and first of what I'm sure will be many questions from me. I have an app which contains a dimension called 'elapsed time until..... Show More

    Hi everyone, new here and first of what I'm sure will be many questions from me.

    I have an app which contains a dimension called 'elapsed time until...'. What I need is a way to calculate what the average is of that dimension.

    Specifically, I have transaction data which can be categorized by Team, Case #, case rating, and elapsed time until first reply.

    I need the average elapsed time until first reply by team and average elapsed time for each possible rating. 

    Any hints? Thanks in advance everyone.

    Show Less
  • forum

    Qlik Cloud Data Integration

    I HAVE 2 DATE FUNCTION IN ONE TABLE

    hi  In my table i am having two date  1.order date 2.Delivery date  but when i am using Canonical Date the count of delivery not coming correct as per... Show More

    hi 

    In my table i am having two date 

    1.order date

    2.Delivery date 

    but when i am using Canonical Date the count of delivery not coming correct as per my source 

    Show Less
  • forum

    Qlik NPrinting

    NPrinting Engine Offline and RabbitMQ Error

    Hi, All, Our NPrinting DEV server (May 2023 IR) has been running well for months. But yesterday I noticed its engine status is offline. Meanwhile, a t... Show More

    Hi, All,

    Our NPrinting DEV server (May 2023 IR) has been running well for months. But yesterday I noticed its engine status is offline. Meanwhile, a task hangs (with 'Running' status) there forever.

    So far I have checked/done the following but they do not help:
    . All NPrintng services are running.
    . I have rebooted the server a couple of times.

    I found this error in engine.log and scheduler.log: RabbitMq service is not connected - trying again in 60 seconds. ERROR: RabbitMQ.Client.Exceptions.BrokerUnreachableException: None of the specified endpoints were reachable

    I followed the instruction in this link (https://help.qlik.com/en-US/nprinting/May2023/Content/NPrinting/Troubleshooting/Qlik-NPrinting-Messaging-Service-startup-connection-problems.htm) and executed ''rabbitmqctl.bat status' command, it gave me error saying I need to run 'rabbitmqctl start_app' command first. So I ran that 'rabbitmqctl start_app' command. It only displayed a message 'Starting node xxxxx...' and then returned. But the problem remains.

    I have submitted Qlik support ticket. Just want to seek advice from the community while I am waiting.

    Thanks

    Show Less
  • forum

    Connectivity & Data Prep

    Add a Calculated Column through Load Script

    I need to add a column to a table, based on data from within that table itself.  Let's use this example, Table Name [Invoice Details]:  Invoice Num... Show More

    I need to add a column to a table, based on data from within that table itself. 

    Let's use this example, Table Name [Invoice Details]: 

    Invoice Number Item Cost Item Sale Price
    123456 $5.00 $10.00
    987654 $7.50

    $20.00

    I need to add a new column to the [Invoice Details] table that is [Item Profit] that will be [Item Sale Price] - [Item Cost].

    Now, I know I could do this when I initially load the table, but in my example Item Cost and Item Sale Price are both pretty complex calculations to begin with, and I don't want to copy both of those expressions into yet another field to complete the [Item Profit] calculation. Said another way, if in the future, the [Item Sale Price] calculation changes, I would like that change to "cascade" to the [Item Profit] calculation without needing the developer to remember to copy his changes to both fields.

    So, how do I essentially LEFT JOIN a table to itself?

    Essentially, I think I need to do this:

    LEFT JOIN ([Invoice Details])
    LOAD [Item Sale Price] - [Item Cost] as [Item Profit]
    Resident [Invoice Details]

    But that obviously doesn't work out for me. What am I missing here?

    Show Less
  • forum

    Security & Governance

    "Qlik Sense Exploited in Cactus Ransomware Campaign": Is this true? Does Qlik h...

    Greetings! I just saw this article about a supposed ransomware security risk in QliK Sense and would like to receive instructions on what to do (if tr... Show More

    Greetings!

    I just saw this article about a supposed ransomware security risk in QliK Sense and would like to receive instructions on what to do (if true):

    https://www.arcticwolf.com/resources/blog/qlik-sense-exploited-in-cactus-ransomware-campaign/

    Customers are asking us about it, but I can't find anything related to this issue in the community.  Please advise and referer to @diagonjope in your note, so that I can get a notification.

    Cheers,

    ++José

    Show Less
  • forum

    Water Cooler

    Qlik Meetup Groups - Join the Green side of the Force

    Are you part of a Meetup Group? I highly recommend it. If your city does not have a Qlik Meetup group, reach out and I can help to arrange one. I am c... Show More

    Are you part of a Meetup Group? I highly recommend it.

    If your city does not have a Qlik Meetup group, reach out and I can help to arrange one. I am currently managing with a colleague 4 groups: Atlanta, Boston, Dallas and Portland. We have so far 29 groups in 17 countries.

    You can find the full list in the following link:

    https://www.meetup.com/pro/qlik/

    Show Less
  • forum

    Qlik Enterprise Manager

    Trying to connect to MS Sql Server 2022 Standard version

    Tried to upgrade Qlik enterprise manager to 2023.5, but still getting the same error SYS-E-HTTPFAIL, Unsupported server/database version: 0. SYS,GENE... Show More

    Tried to upgrade Qlik enterprise manager to 2023.5, but still getting the same error

    • SYS-E-HTTPFAIL, Unsupported server/database version: 0.
    • SYS,GENERAL_EXCEPTION,Unsupported server/database version: 0

      no issue with the source, able to telnet source and able to login the database using the same username and password
    Show Less
  • forum

    New to Qlik Analytics

    2 Triggers for a task

    Hi Everyone, I have a requirement to schedule a task on 15th of every month after the dependent tasks are executed . In this example, 2 triggers are t... Show More

    Hi Everyone,

    I have a requirement to schedule a task on 15th of every month after the dependent tasks are executed . In this example, 2 triggers are to be created :

    1. Trigger - Task Event : on successful of dependent tasks

    2. Trigger - Schedule Event : 15 th of every month : But here the start time has to be linked to the previous trigger . 

    How does the triggers in reload task work ? Is there a way to include AND condition between the triggers ?

    Regards,

    Malar

    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!