Skip to main content

Welcome to
Qlik Community!

cancel
Showing results for 
Search instead for 
Did you mean: 
  • 242,883 members
  • 6,007 online
  • 2,026,052 posts
  • 152,427 Solutions
Announcements
Get Ready. A New Qlik Learning Experience is Coming February 17! LEARN MORE

Welcome to Qlik Community

Recent Discussions

  • forum

    Qlik NPrinting

    Requirement to send out a static Report as Email

    Hi Experts, How can I send PDF reports via email from Qlik Sense (November 2022 release) without using NPrinting?Are there any alternative methods or ... Show More

    Hi Experts,

    How can I send PDF reports via email from Qlik Sense (November 2022 release) without using NPrinting?
    Are there any alternative methods or workarounds to automate the process of emailing reports?

    Thank you for your responses.

    #QS NOV22

    Show Less
  • forum

    Qlik Replicate

    Managing Kinesis streams for Replicate control tables

    Hi Support,   When using Amazon Kinesis as a target endpoint in a Replicate task, there is a prerequisite to create a stream called 'attrep_apply_exce... Show More

    Hi Support,

     

    When using Amazon Kinesis as a target endpoint in a Replicate task, there is a prerequisite to create a stream called 'attrep_apply_exceptions' so that the Apply Exceptions control table can be written to the target.

    NakulanR_0-1738628559262.png

    If the remaining control tables (attrep_status, attrep_history, etc.) are required, does a stream need to be created for each using the exact name of the control table? i.e. If you want to enable attrep_status, would you need to create a stream called 'attrep_status'?


    Thanks,
    Nak

    Show Less
  • forum

    Qlik NPrinting

    Display filters with no data

    Is it possible to display filters with no data when generating a Word report? I know you can use getCurrentSelections() to display the current filters... Show More

    Is it possible to display filters with no data when generating a Word report?

    I know you can use getCurrentSelections() to display the current filters, but it only shows the filters that have data.

    For example, if you include all months in the filter, getCurrentSelections() will only show the months that have data, and omit the ones with no data.

     

     

     

     

    Show Less
  • forum

    Visualization and Usability

    Make a text bold using text color expression field in pivot table

    I have created the attached dummy application in Qlik Sense Cloud, and I want to make the result of a measure and the value of a ValueList() both bold... Show More

    I have created the attached dummy application in Qlik Sense Cloud, and I want to make the result of a measure and the value of a ValueList() both bold.

    pivot tablepivot table

     

    In the above screenshot the text Total is coming from this ValueList('Total', 'Customer A', 'Customer B') while the sales measure is calculated using this expression:

    if(ValueList('Total','Customer A','Customer B')='Total',sum(Sales),
    if(ValueList('Total','Customer A','Customer B')='Customer A',sum({$<Customer={'A Superior System'}>}Sales),
    if(ValueList('Total','Customer A','Customer B')='Customer B',sum({$<Customer={'A-2-Z Solutions'}>}Sales),
    Null())))

     

    What I want is to make both the Total  label and the total sum Bold and Red. What I have tried at least for the measure expression is the below statement in the Text Color Expression box:

    if(ValueList('Total','Customer A','Customer B')='Total',rgb(255,0,0) and '<b>',DarkGray())

    However, the above statement does not return the expected result because this bold expression '<b>' works in QlikView only, while I use QlikSense. Is there any workaround?

    I have attached the qvf file and the two xlsx files with the dummy data.

    Show Less
  • forum

    Move to Qlik Cloud Analytics

    Real-time Monitoring of "Capacity" License Usage in Qlik SaaS

    Hello, I need to know in real-time the minutes that users with a "Capacity" license are consuming. I can't find the application within "Monitoring" in... Show More

    Hello, I need to know in real-time the minutes that users with a "Capacity" license are consuming. I can't find the application within "Monitoring" in Qlik SaaS. Can you help me?

    Thanks in advance

    Show Less
  • forum

    Reporting Service & Alerting

    App ID not found in Tabular Reporting

    Good morning Qlik Community. I am having problems implementing Qlik Tabular Reporting on a client. I have the following problem as an example:"This Ql... Show More

    Good morning Qlik Community.

    I am having problems implementing Qlik Tabular Reporting on a client. I have the following problem as an example:
    "This Qlik Sense app could not be loaded: test with alen app tabular. Please verify the following app ID: 69b3bd8f-efef-4841-a52d-89a2787c3434"
    This happens with all, all apps, for all users, even in personal spaces... it goes without saying that also in Shared spaces with all permissions, including the tenant admin with all the permissions and roles required with a professional license...Even with apps created on the fly with a simple inline table without section access.
    This occurs when selecting an app to build the report.

    Screenshot_2.png

    I have a ticket with Qlik Support in progress, however, has anyone in the community faced this issue?

    Thank you very much for taking the time to review this post.


    If we manage to resolve the problem with Qlik Support, I will put the resolution in this post so everyone can solve the problem.

    Show Less
  • forum

    App Development

    Problems with order and accumulated in tables

    Hello everyone. I would like to ask for your help with a very important topic: I want to create a cumulative total in a table. The problem I have is t... Show More

    Hello everyone.

    I would like to ask for your help with a very important topic: I want to create a cumulative total in a table. The problem I have is that when I perform the cumulative calculation, the RowNo() function distorts a column that should be sorted in descending order.

    Now I am going to show you a table that is working.

    DeanW_0-1738957736864.png

    You can see that I have a table of quantity sorted in descending order, your participation and the cumulative participation all in percentages.
    Quantity: Sum({<%Flag_Invoice={1}>} QUANTITY * If(IsNull(MENGE.STPO), 1, MENGE.STPO) * Sign)

    Cumulative %Participation:
    Sum({<%Flag_Flag_Invoice={1}>} QUANTITY * If(IsNull(MENGE.STPO), 1, MENGE.STPO) * Sign)
    /
    Sum(TOTAL{<%Flag_Invoice={1}>} QUANTITY * If(If(IsNull(MENGE.STPO), 1, MENGE.STPO) * Sign)

    %Accum:
    RangeSum(Above($(v%_Accumulated_Quantity),0,RowNo(TOTAL)))

    Being the variable $(v%_Accumulated_Cant) equal to %Accum Share I did it this way just to make it look neater.

    BUT!
    When I add an extra dimension, my quantity gets messed up and doesn't look right.

    DeanW_1-1738958066659.png

    NOTES:
    In the sort tab I set the first dimension to sort by expression and the rest I unsorted the sorts and it didn't work either.

    DeanW_2-1738958106926.png

    What can you do!

    Please!!!

     

    Regards

     

     

     

     

    Show Less
  • forum

    Qlik Replicate

    Qlik Task Unavailability Post Qlik disaster recovery

      Environment Details: Qlik Environment: Operating System: Windows Server 2022 Qlik Version: 2024.5.0.144 Data Source Environment: Database: SQ... Show More

     

    Environment Details:

    • Qlik Environment:

      • Operating System: Windows Server 2022
      • Qlik Version: 2024.5.0.144
    • Data Source Environment:

      • Database: SQL Server
      • SQL Server Version: 2019
      • Operating System: Windows Server 2019

    Issue Description:

    We are encountering an issue following the recovery process of disaster recovery by moving the file to a different Qlik server.

    Steps Followed:

    1. Stopped both active Qlik_SERVER_1 and passive Qlik_SERVER_2 Qlik servers.
    2. Stopped any running tasks (60+ tasks).
    3. Performed Qlik disaster recovery by moving the file from Qlik_SERVER_1 to Qlik_SERVER_2.
    4. Started Qlik services successfully on Qlik_SERVER_2.
    5. Attempted to start the Qlik tasks on the new active Qlik_SERVER_2.
    6. Sometimes the Qlik tasks cannot start with any of the options (Normal Resume, Reload, Reprocess with X LSN).

    Additional Observations:

    • After stopping the Windows process of each Qlik task, we can restart them successfully, but only 2-5 tasks together at a time.

    Error Message:

    Upon changing the log level to trace, the following error messages were observed:

     

    00002188: 2025-02-10T16:34:35:924215 [IO ]V: combine_path: rootPath=<f:\mware\Attunity\Replicate\data\logs>, addPath=<f:\mware\Attunity\Replicate\data\logs> (at_dir.c:1014)
    00002188: 2025-02-10T16:34:35:924215 [IO ]V: combine_path: result before canonize=<f:\mware\Attunity\Replicate\data\logs\clean_old_logs.bat> (at_dir.c:1025)
    00002188: 2025-02-10T16:34:35:924215 [IO ]V: combine_path: result=<f:\mware\Attunity\Replicate\data\logs\clean_old_logs.bat> (at_dir.c:1031)
    00002188: 2025-02-10T16:34:35:924215 [IO ]V: combine_path: rootPath=<f:\mware\Attunity\Replicate\data\logs>, addPath=<f:\mware\Attunity\Replicate\data\logs> (at_dir.c:1014)
    00002188: 2025-02-10T16:34:35:924215 [IO ]V: combine_path: result before canonize=<f:\mware\Attunity\Replicate\data\logs\reptask_UNI-SRC-FSHD-01-TGT-FRPT-UV.log> (at_dir.c:1025)
    00002188: 2025-02-10T16:34:35:924215 [IO ]V: combine_path: result=<f:\mware\Attunity\Replicate\data\logs\reptask_UNI-SRC-FSHD-01-TGT-FRPT-UV.log> (at_dir.c:1031)
    00002188: 2025-02-10T16:34:35:924215 [IO ]V: combine_path: rootPath=<null>, addPath=<null> (at_dir.c:1014)
    00002188: 2025-02-10T16:34:35:924215 [IO ]V: combine_path: result before canonize=<F:\mware\Attunity\Replicate\data\logs\reptask_UNI-SRC-FSHD-01-TGT-FRPT-UV.log> (at_dir.c:1025)
    00002188: 2025-02-10T16:34:35:924215 [IO ]V: combine_path: result=<F:\mware\Attunity\Replicate\data\logs\reptask_UNI-SRC-FSHD-01-TGT-FRPT-UV.log> (at_dir.c:1031)
    00002188: 2025-02-10T16:34:35:924215 [IO ]V: combine_path: rootPath=<f:\mware\Attunity\Replicate\data\logs>, addPath=<f:\mware\Attunity\Replicate\data\logs> (at_dir.c:1014)
    00002188: 2025-02-10T16:34:35:924215 [IO ]V: combine_path: result before canonize=<f:\mware\Attunity\Replicate\data\logs\reptask_UNI-SRC-FSHD-01-TGT-FRPT-UV__250210163435.log> (at_dir.c:1025)
    00002188: 2025-02-10T16:34:35:924215 [IO ]V: combine_path: result=<f:\mware\Attunity\Replicate\data\logs\reptask_UNI-SRC-FSHD-01-TGT-FRPT-UV__250210163435.log> (at_dir.c:1031)
    00002188: 2025-02-10T16:34:35:924215 [INFRASTRUCTURE ]I: Crypto mode: Standard. (at_logger.c:1573)
    00002188: 2025-02-10T16:34:35:924215 [INFRASTRUCTURE ]V: thread allocation for converter <0> (at_text.c:725)
    00002188: 2025-02-10T16:34:35:924215 [INFRASTRUCTURE ]V: cloning converter, cd 0 (at_text.c:581)
    00002188: 2025-02-10T16:34:38:925173 [IO ]T: rep_net_server_select: Server poll timeout. failed (at_repnet.c:489)
    00002188: 2025-02-10T16:34:38:925173 [IO ]V: rep_net_server_select:489: Failed (at_repnet.c:550)
    00002188: 2025-02-10T16:34:41:925582 [IO ]T: rep_net_server_select: Server poll timeout. failed (at_repnet.c:489)
    00002188: 2025-02-10T16:34:41:925582 [IO ]V: rep_net_server_select:489: Failed (at_repnet.c:550)

     

     

    Request for Assistance:

    We seek assistance in diagnosing and resolving the following:

    • Understanding why Qlik tasks are not available after the recovery process.
    • Steps to make the tasks available for startup without manually stopping the Windows process of each task.
    • Any necessary configurations or checks that we might have missed during the recovery process.

    Additional Information:

    • Environment details (OS, Qlik, and SQL Server versions).
    • Error messages from the trace log (as provided above).

    We appreciate your prompt assistance in resolving this issue.

    Show Less
  • forum

    Francophones

    Créer un KPI antidaté

    Bonjour à tous,   Je calcule la moyenne de mes ventes sur l'ensemble de mes données. Et j'aimerais avoir en deuxième mesure, la moyenne de mes ventes ... Show More

    Bonjour à tous,

     

    Je calcule la moyenne de mes ventes sur l'ensemble de mes données. Et j'aimerais avoir en deuxième mesure, la moyenne de mes ventes qui s'arrêtent à la semaine dernière. 

    Faire comme ça, mais au lieu de "last month" que ça soit "last week". 

    MattThoms_0-1739202702521.png

     

    Show Less
  • forum

    Connectivity & Data Prep

    Data load with OLEDB Provider for oracle post Qlik upgrade to May2024 is very sl...

    Data load with OLEDB Provider for oracle post Qlik upgrade to May2024 is very slow   We have 67 million records to load from Oracle database, but data... Show More

    Data load with OLEDB Provider for oracle post Qlik upgrade to May2024 is very slow

     

    We have 67 million records to load from Oracle database, but data load is not completing even after waiting for 15+ hours

    We tried different configurations for FETHSIZE, but it is not working. Could anyone help. 

     

     

     

     

     

    Show Less
Leaderboard

Customer Story

Accelerating Decision-Making with Qlik Insights

Qlik enhances decision-making with high-speed insights, as Mayborn Group integrates data from various functions across their global operations, gaining a competitive edge in the childcare industry.

Customer Story

Efficiency in Agriculture: Nortera's Qlik Triumph

Nortera leads agricultural manufacturing analytics and automation with Qlik, reducing short-shipment rates and annual savings in water consumption.

Customer Story

Revolutionizing aircraft production through Data Analytics

Qlik Data Integration transforms Airbus' aircraft production, leading to over 150 replication tasks and informing more efficient analysis.

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!