Skip to main content

Welcome to
Qlik Community!

cancel
Showing results for 
Search instead for 
Did you mean: 
  • 215,360 members
  • 4,717 online
  • 1,991,724 posts
  • 149,210 Solutions
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW

Welcome to Qlik Community

Recent Discussions

  • forum

    Qlik NPrinting

    Qlik entity reports generate without PDF but Word based reports export to PDF ju...

    Hi, I'm running a new installatoin of Npriting May 2023.   HTML reports, Word to PDF reports works fine.  however, entity reports are not.  The email ... Show More

    Hi,

    I'm running a new installatoin of Npriting May 2023.   HTML reports, Word to PDF reports works fine.  however, entity reports are not.  The email gets sent without the PDF attachment with a message "some reports failed to generate"

     

    this is what I found in the log file of the NPrinting engine:

    Content request Qlik.Reporting.Engine.Messages.Requests.SomethingReportNodeRequest 886b52d1-42b0-4cd4-82ff-9376e8dec3f1: resolution ended unsuccessfully with exception System.Exception: Qlik NPrinting PDF Printer not installed or not properly registered

    I tried reinstalling the NPrinting Engine but that did not help.

    Show Less
  • forum

    Qlik Replicate

    Failed to produce message to exception stream while using kinesis as a target

    Hi team,  We are transferring data from oracle to kinesis. In one of the task which contained 38 tables got failed due to error that is failed to prod... Show More

    Hi team, 

    We are transferring data from oracle to kinesis. In one of the task which contained 38 tables got failed due to error that is failed to produce message to the exception stream. After giving warning for data error in one of the table that is A data error was encountered.refer to the attrep_apply_exceptions table for details.

    Please let us know in which scenario this happens. Is there any workaround for this issue.

    Attaching error screenshot for your reference.

    Regards,

    Sushant 

    Show Less
  • forum

    Qlik Cloud Data Integration

    Can't install Qlik Sense Entensions on Qlik Cloud

    The extensions used in qlik sense on premise can't install on Qlik Cloud. It shows a message like "Invalid File". The extension is this:   Can anyone... Show More

    The extensions used in qlik sense on premise can't install on Qlik Cloud. It shows a message like "Invalid File". The extension is this:

    ironwill_1-1711571885079.png

     

    Can anyone help me please?

    Regards,

    Show Less
  • forum

    New to Qlik Analytics

    Display Aggregate values

      I have a visualization with State, City and Sales . In 4th column I want to display total sales for individual State.     Instead of displaying "-"... Show More

     

    I have a visualization with State, City and Sales . In 4th column I want to display total sales for individual State.

     

    MH376_0-1711676138636.png

     

    Instead of displaying "-" at city level I want to display total sales as shown below:

    State City Sales
    CA SFO 100 600
    CA LAX 200 600
    CA SDF 300 600
    TX DFW 100 1600
    TX AUS 500 1600
    TX HOU 1000 1600

     

    How can I change the visualization ?

    Also I have a State and City Filter. Can it display all states and cities by ignoring the filter values?

     

     

     

    Show Less
  • forum

    App Development

    Why is the include variable executed?

    Dear All The include variable is located behind the exit clause.This script is not interrupted in the exit clause.Why is the include variable executed... Show More

    Dear All

    The include variable is located behind the exit clause.

    This script is not interrupted in the exit clause.

    Why is the include variable executed?

     

    *********** Script  new *****

    vServername = ComputerName() ;
    trace $(vServername);
    if '$(vServername)' = 'QlikDev' then 
    trace '------1';
    else
    trace '------2';
    end if
     
    exit script;
     
    vTargetPath_qvs = 'lib://File_Folder ;
    $(Must_Include=[$(vTargetPath_qvs)/AUTH/Authorization.qvs]);
     
    exit script;

     

    *************** Script end

     

    Qlik Sense Version : Nov 2023 patch 7

     

    Best Regard

    Hanna.choi

    Show Less
  • forum

    App Development

    Help with MoM % expression (Month-over-Month growth percentage)

    Hello! I would like help with a code about MoM %, percentage of growth compared to the previous month. In this case, my code is this one, but it didn'... Show More

    Hello! I would like help with a code about MoM %, percentage of growth compared to the previous month. In this case, my code is this one, but it didn't bring me any result. I believe the problem is in the date code itself. Thank you in advance.

    Sum({<ds_estrutura = {"Ativos"}, ds_tipo = {"QUADRO_INDICADOR"},dt_calendario = {"$(=Date(dt_calendario))"}>} vl_indicador)
    /
    Sum({<ds_estrutura = {"Ativos"}, ds_tipo = {"QUADRO_INDICADOR"},dt_calendario = {"$(=Date(AddMonths(dt_calendario, -1)))"}>} vl_indicador) - 1

    joaognoatto_0-1711678907136.png

    joaognoatto_1-1711679226305.png

    Show Less
  • forum

    Installing and Upgrading

    Talend Open Studio 8.0.1 Error Opening a job

    I get the following error message when I try to open an existing job:An error has occurred. See error log for more details.JsonIoException setting fie... Show More

    I get the following error message when I try to open an existing job:

    An error has occurred. See error log for more details.

    JsonIoException setting field 'flags' on target: Property: null with value: {}

    I didn't make any migration and I've this exact same error message while opening a job.

    I specify that I work on a project that I did not develop myself.

    But the thing is : this job was opening really well last week and nothing has changed in the meantime.

    I'm completely stuck right now 👾

    Environment :

    TOS 8.0.1

    JDK 17

    Thank you by advance

    CTouu

    Show Less
  • forum

    Installing and Upgrading

    Connexion à une base de données HFSQL

        Bonjour, Je rencontre actuellement un problème de connexion à une base de données hfsql Type de base de données : JDBC généralURL : jdbc :... Show More
     
     

    Bonjour,

    Je rencontre actuellement un problème de connexion à une base de données hfsql

    Type de base de données : JDBC général
    URL : jdbc : odbc : nom du serveur 
    Jar Pilote : rt (à partir de jre 7 64 bits)
    Nom de la classe : sun.jdbc.odbc.JdbcOdbcDriver
    Lorsque je vérifie la connexion, j'obtiens ce message d'erreur :

    Aucun pilote approprié trouvé pour jdbc

    J'ai besoin d'aide à ce sujet. Merci d'avance .

    Show Less
  • forum

    New to Qlik Analytics

    IF Statements Help

    I'm currently working on the data load using IF statements below but keep getting an error for line 3 & 4. Can someone help point out what I'm doing w... Show More

    I'm currently working on the data load using IF statements below but keep getting an error for line 3 & 4. Can someone help point out what I'm doing wrong? I've included the sample data attached for reference of what I want as an outcome. Thank you in advance.

    1: date(CREATED_DATE, 'MM/DD/YYYY') as [Date Opened],

    2: STATUS_C as [Status],

    3: if([STATUS_C]= 'Closed', 'Closed','Open') as [Status Flag],

    4: If ([STATUS_C] ='Open',today()-Created Date as [Days Aged from Open Date],

    5: If ([STATUS_C] ='Open',If( [Days Aged] >= 0 and [Days Aged] < 90, replace( class([Days Aged],30),'<= x <','-') & ' Days', If( [Days Aged] >= 90, '90 Days+'))) as [Open Timeframe],

    kimdiep503_0-1711473433831.png

     

    Show Less
  • forum

    New to Qlik Analytics

    Combining if into set analysis

    Hi all, below is a snapshot of my data which starts in Jan 1st 2023.  I wish find total using set analysis with the following criteria: 1. If(Actual >... Show More

    Hi all, below is a snapshot of my data which starts in Jan 1st 2023.  I wish find total using set analysis with the following criteria:

    1. If(Actual > Planned, Actual, Planned) and

    2. Between Monday and Friday.  Therefore, the correct total planned would be 11.

    I don't wish to create a new variable or using the load editor.

     

    Jobid Date Day Planned Widgets Actual Widgets if Actual > Planned,Actual,Planned
    1 18-Mar-24 Mon 0 1 1
    2 19-Mar-24 Tue 2 2 2
    3 20-Mar-24 Wed 2 1 2
    4 21-Mar-24 Thu 1 1 1
    5 21-Mar-24 Thu 0 1 1
    6 22-Mar-24 Fri 2 2 2
    7 22-Mar-24 Fri 2 2 2
    8 23-Mar-24 Sat 2 2 2
    9 24-Mar-24 Sun 2 2 2
          13 14 15
               
        Mon to Fri 9 10 11

     

     

    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!