Skip to main content

Welcome to
Qlik Community!

cancel
Showing results for 
Search instead for 
Did you mean: 
  • 219,240 members
  • 4,179 online
  • 1,998,060 posts
  • 149,800 Solutions
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE

Welcome to Qlik Community

Recent Discussions

  • forum

    New to Qlik Analytics

    Showing extra 0 values in the line chart even though there is no 0 in the source

    HI, I attached the source data and I dont have any values or 0 in the source for the year 2023. but when i use the line chart, I can see that value 0 ... Show More

    HI, 

    I attached the source data and I dont have any values or 0 in the source for the year 2023. but when i use the line chart, I can see that value 0 is populated for the year 2023 and for the months mar till dec. 
    so I dont want to populate 0 in the line chart if it is not available in source, if 0 exists in the source then only i want to populate it in the line chart. Please help me to solve this issue.
    Dimension used is : MasterMonth
    Measure used is : 1 )  2022: sum({<MasterYear = {"2022"}>}distinct NumOFPolicies)
                                 2 )  2023: sum({<MasterYear = {"2023"}>}distinct NumOFPolicies)

    PoojaS_0-1715565967519.png

    PoojaS_1-1715566012318.png

    Show Less
  • forum

    Deployment & Management

    Explanation about Audit, System & Trace logs

    Hi Can any one please explain about Audit, System & Trace logs? May more specifically Engine,  Repository & Proxy logs.   Thanks in advance. Show More

    Hi

    Can any one please explain about Audit, System & Trace logs?

    May more specifically Engine,  Repository & Proxy logs.

     

    Thanks in advance.

    Show Less
  • forum

    Qlik NPrinting

    Nprinting is not working

    I know there are a ton of topics about it, but I'm the next to get this problem: the connection between office and nprinting does not work. It used to... Show More

    I know there are a ton of topics about it, but I'm the next to get this problem: the connection between office and nprinting does not work. It used to work on my old computer but fails there - even as I did install (and now reinstalled twice) office 2019 especially for that goal.
    I don't get it working on my new computer with office 365, including trying the tips on this forum and two nPrintingDesigner versions.
    Has anybody an idea what to try next? Or is there any help out there?

     

    JesseWit_0-1715420413344.png

     

    Show Less
  • forum

    Qlik Replicate

    Identifying when Down stream tasks have finished processing changes from the sta...

    Hi Qlik Support,   In a Log Stream setup, when a Down stream task receives the warning "Changes are not being captured", does that warning indicate th... Show More

    Hi Qlik Support,

     

    In a Log Stream setup, when a Down stream task receives the warning "Changes are not being captured", does that warning indicate that the down stream task has processed all the staged changes from the staging folder or does it simply mean that the staging task has been stopped?

    We are trying to determine a method to identify when a down stream task has processed all the changes in the Log stream staging folder after the staging task has been stopped.

     

    Thanks,

    Nak

    Show Less
  • forum

    Qlik Replicate

    Error Handling of CDC task

    Hello Experts Our customer has upgraded v2022.05 to v2023.11 and encountered the problem below: In 2022.05, when the following warning occurred, CDC t... Show More

    Hello Experts

    Our customer has upgraded v2022.05 to v2023.11 and encountered the problem below:

    In 2022.05, when the following warning occurred, CDC task continued without any errors.

    [TARGET_LOAD ]I: Load finished for table 'ADM'.'XXXXX' (Id = 1). 85627944 rows received. 0 rows skipped. Volume transferred 98611582288. (streamcomponent.c:3976)
    [TARGET_LOAD ]I: TPT statistics for table 'REP.YYYYY': Operator=LOAD, CPU time=1115.296875, Received Rows=85627944, Sent Rows=85627944, Applied Rows=85627917 (teradata_tpt_engine.cpp:778)
    [TARGET_LOAD ]W: Not all rows have been loaded successfully for 'REP'.'YYYYY' due to possible 'TPT LOAD' errors. Consult Target 'xxxx_E?' / 'xxxx_L?' Error / Log tables contents. (teradata_tpt_engine.cpp:786)
    [TARGET_LOAD ]I: teradata_terminate_tpt(...) successfully applied conn->Terminate() method for task identified by UUID '74a9fd96-8335-5944-bb67-6aaa83fb3782' (teradata_tpt_engine.cpp:839)
    [TASK_MANAGER ]I: Loading finished for table 'ADM'.'XXXXX' (Id = 1) by subtask 1. 85627944 records transferred. (replicationtask.c:3012)
    [TARGET_LOAD ]I: teradata_stop_imp(...) stopping task identified by UUID '74a9fd96-8335-5944-bb67-6aaa83fb3782' (teradata_endpoint_imp.c:857)
    [TARGET_LOAD ]I: teradata_free(...) freeing resources for task identified by UUID '74a9fd96-8335-5944-bb67-6aaa83fb3782' (teradata_endpoint_imp.c:878)
    [TARGET_LOAD ]I: teradata_disconnect(...) disconnecting for task identified by UUID '74a9fd96-8335-5944-bb67-6aaa83fb3782' (teradata_endpoint_imp.c:92)
    [TARGET_LOAD ]I: teradata_disconnect(...) disconnecting Data Connection succeeded for task identified by '74a9fd96-8335-5944-bb67-6aaa83fb3782' (teradata_endpoint_imp.c:104)
    [TARGET_LOAD ]I: teradata_disconnect(...) No active Lookup Connection to disconnect from was detected for task identified by '74a9fd96-8335-5944-bb67-6aaa83fb3782' (teradata_endpoint_imp.c:122)
    [TASK_MANAGER ]I: Subtask #1 ended (replicationtask_util.c:591)


    However the behavior has changed after upgrading to v2023.11.
    After the same warning occurred, it is detected as an error and the table is suspended.

    [TARGET_LOAD ]I: Load finished for table 'ADM'.'XXXXX' (Id = 1). 85986652 rows received. 0 rows skipped. Volume transferred 99014228864. (streamcomponent.c:4076)
    [TARGET_LOAD ]I: TPT statistics for table 'REP.YYYYY': Operator=LOAD, CPU time=1126.937500, Received Rows=85986652, Sent Rows=85986652, Applied Rows=85986625 (teradata_tpt_engine.cpp:781)
    [TARGET_LOAD ]W: Not all rows have been loaded successfully for 'REP'.'YYYYY' due to possible 'TPT LOAD' errors. Consult Target 'xxxx_E?' / 'xxxx_L?' Error / Log tables contents. (teradata_tpt_engine.cpp:789)
    [TARGET_LOAD ]I: teradata_terminate_tpt(...) successfully applied conn->Terminate() method for task identified by UUID '74a9fd96-8335-5944-bb67-6aaa83fb3782' (teradata_tpt_engine.cpp:846)
    [TARGET_LOAD ]E: TPT data acquisition failed [1020403] (teradata_endpoint_imp.c:1480)
    [TARGET_LOAD ]E: Handling End of table 'REP'.'YYYYY' loading failed by subtask 1 thread 1 [1025000] (endpointshell.c:3069)
    [TASK_MANAGER ]W: Table 'ADM'.'XXXXX' (subtask 1 thread 1) is suspended. TPT data acquisition failed; Handling End of table 'REP'.'YYYYY' loading failed by subtask 1 thread 1 (replicationtask.c:3208)

    Is there any options to ignore the warnings/errors and continue the task like v2022.05?

    Any advice would be appreciated.

    Regards,
    Kyoko Tajima

    Show Less
  • forum

    Qlik Replicate

    What comes first, the lookup or the filter?

    Hi, I am wondering when I have a source lookup on a column in a table, then I also have a filter on the table. What comes first? Are the records filte... Show More

    Hi,

    I am wondering when I have a source lookup on a column in a table, then I also have a filter on the table. What comes first? Are the records filtered then the source lookup occurs? or does the source lookup occur then the rows are filtered?

    Regards,

    Mo

    Show Less
  • forum

    New to Qlik Analytics

    The Paris 2024 Olympic Games with Qlik sense 🥇🥈🥉

    Hello, The Paris Olympics are in 426 days! In the meantime, we have just developed a mashup made with #Qlik and #Talend to analyze data from all the O... Show More

    Hello,

    The Paris Olympics are in 426 days!

    In the meantime, we have just developed a mashup made with #Qlik and #Talend to analyze data from all the Olympic Games since 1896️ : 51 editions, 223 countries, 729 events, +19k medals, + 140k athletes…

    link : https://www.acssi.fr/jo2024/

    2023-05-27_06h46_54.png

    In progress : English language, font optimization, new Data, optimizations, addition of Winter Olympics data for the last 2 editions, Paris Olympics calendar, live statistics of the Paris Olympics...

    Do not hesitate to share your feedback and your ideas with us so that we can evolve the web site.

    Many Thanks,

    Olivier

     

    Qlik Sense Enterprise on Windows #sport #talend

    Show Less
  • forum

    Deployment & Management

    How can I global search a data connection used in an app

    As we have many many apps, there is a server going to be decommissioned. I found the related data connection name.  How I can search across all apps i... Show More

    As we have many many apps, there is a server going to be decommissioned. I found the related data connection name. 

    How I can search across all apps if that Data Connection been used?

    Thanks in advance.

    Show Less
  • forum

    New to Qlik Analytics

    Book Time Slot Qlik Sense Script

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

    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 

    5/13/2024 09:00 - 09:15
    5/13/2024 09:15 - 09:30
    5/13/2024 09:30 - 09:45
    5/13/2024 09:45 - 10:00
    5/13/2024 10:00 - 10:15
    5/13/2024 10:15 - 10:30
    5/13/2024 10:30 - 10:45
    5/13/2024 10:45 - 11:00
    5/13/2024 11:00 - 11:15
    5/13/2024 11:15 - 11:30
    5/20/2024 09:00 - 09:15
    5/20/2024 09:15 - 09:30
    5/20/2024 09:30 - 09:45
    5/20/2024 09:45 - 10:00
    5/20/2024 10:00 - 10:15
    5/20/2024 10:15 - 10:30
    5/20/2024 10:30 - 10:45
    5/20/2024 10:45 - 11:00
    5/20/2024 11:00 - 11:15
    5/20/2024 11:15 - 11:30

     

    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,

     

    Show Less
  • forum

    GeoAnalytics

    capas de mapa e icono

    Hola como asocio una imagen de la capa dentro del título de la capa
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!