Skip to main content

Welcome to
Qlik Community!

cancel
Showing results for 
Search instead for 
Did you mean: 
  • 215,370 members
  • 4,591 online
  • 1,991,738 posts
  • 149,212 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

    Integration, Extension & APIs

    Jira API with REST Connector

    I've been using the REST Connector with different API's but I just can't figure out how to use it with Jira API? I was given this information which I ... Show More

    I've been using the REST Connector with different API's but I just can't figure out how to use it with Jira API?

    I was given this information which I suppose should be enough.

    URL: https://developer.atlassian.com/console/myapps/
    App Name: xxxxxx
    Redirect URI: https://xxx.xxxxxx.com/Client/MVC/Site/Login
    Client id: xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
    Client Secret: xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx

    Show Less
  • forum

    Qlik Replicate

    Enterprise manager REST API PUT call not working

    HI   I am trying to call below API  curl -i -k -v -X PUT --header "EnterpriseManager.APISessionID: wCo0_KvjEUFROvfHF5KGrw" --header "Content-Length: 2... Show More

    HI

     

    I am trying to call below API 

    curl -i -k -v -X PUT --header "EnterpriseManager.APISessionID: wCo0_KvjEUFROvfHF5KGrw" --header "Content-Length: 242" https://computer.network.net/attunityenterprisemanager/api/v1/servers/myrepsrv1/def -T "C:\myrepsrv1.json"

     

    I have put my APISessionID  and url  and its connecting fine. At the end of log message, it says 

    > Content-Type: application/json
    > Content-Length: 242
    > Expect: 100-continue
    >
    < HTTP/1.1 100 Continue
    HTTP/1.1 100 Continue

    * We are completely uploaded and fine

     

    and then gets stuck.

    Any idea, whats going on. I am able to run REST API GET commands. I see below line in enterprise manager log when GET command is successful

    25 2024-03-29 02:21:48 [Manager ] [INFO ] Executing public api AemGetServer.

    Show Less
  • forum

    New to Qlik Analytics

    How to calculate "Balance Due"

    Hello, I have following data- If above scenario, balance due is $60. Because the payment made by CC somehow did not go through even though status sho... Show More

    Hello,

    I have following data-

    pgloc2020_0-1711563758168.png

    If above scenario, balance due is $60. Because the payment made by CC somehow did not go through even though status shows "Paid".  

    How I can calculate the "Balance Due" in Qlik?

    I used the following expression but it is not working in above example.  I am getting Balance Due = 0 instead of 60

    IF(([PAYMENT_STATUS] = 'Paid' OR [PAYMENT_STATUS] = 'Blank') ,
    SUM(TOTAL_RATE) - SUM(ALLOCATION_AMOUNT))

    I also used following but not getting correct Balance due amount-

    IF(([PAYMENT_STATUS] = 'Paid' OR [PAYMENT_STATUS] = 'Blank') AND [2nd_LOCK] = 'Y', SUM(TOTAL_RATE) - SUM(ALLOCATION_AMOUNT), 0 )

    Please help me to correct my formula to calculate the correct "Balance Due"

    I have this column in a straight table chart as a measure. 

    Many thanks!

    Show Less
  • forum

    Design and Development

    how to create dynamic schema in Talend Studio 8

    I need to load 100+ files (pipe delimited) with different schemas to DB tables. I have created a mapping using Dynamic Schema and it is able to iterat... Show More

    I need to load 100+ files (pipe delimited) with different schemas to DB tables.

    I have created a mapping using Dynamic Schema and it is able to iterate the files , create table and load the data.

    But issue is , All the column data types are created as VARCHAR2 .

    What I want is that the column datatype in the output tables should be created as per data present in the input files.(say NUMBER for values like 1,2,3 etc and DATE for values like 1/1/2020 etc).

    Please suggest how to make this happen.

    Talend Studio 

    Show Less
  • forum

    App Development

    set analysis expression to show sales of previous year if I select an year

    Hi, I'm looking for a set analysis expression where if we select an year it has to show previous year sales. Below example data. Date Market Sales ... Show More

    Hi,

    I'm looking for a set analysis expression where if we select an year it has to show previous year sales. Below example data.

    Date Market Sales
    1/1/2024 IND 100
    1/21/2024 NAM 200
    1/16/2024 AUS 600
    12/15/2023 IND 300
    9/16/2023 NAM 400
    8/26/2023 AUS 500
    4/13/2022 AUS 600
    5/18/2022 IND 900
    6/10/2022 NAM 700

     

    So I'm looking for a set analysis or a flag in the back end where if I select year it has to show previous year values. Below example.

    If I select 2024 from year filter it has to show 2023 values.

    Year Sales 2024 Sales 2023
    2024 900 1200

     

    If I select 2023 from year filer it has to show 2022 values

    Year Sales 2023 Sales 2022
    2023 1200 2200
    Show Less
  • forum

    Connectivity & Data Prep

    Error noFileSize for QVD from a SFTP connector

    Loading a QVD file from a SFTP connector (not from webconnector) occurs an error: noFileSize Any file format doesn't have an error when loading.I tri... Show More

    Loading a QVD file from a SFTP connector (not from webconnector) occurs an error: noFileSize

    t_donnet_0-1711638845891.png

    Any file format doesn't have an error when loading.
    I tried to load with an other QVD, the same issue persist.

    Antivirus doesn't scan the SFTP folder.
    There is not file access restrictions, antivirus software locking the file, or resource bottlenecks

    Any idea to fix it?

     

     

    Show Less
  • 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

    Connection Dataproc

    Bonjour,  Je n'arrive pas a me connecté au cluster Dataproc depuis Qlik replicate.  Erreur veut dire que l'adresse host et le numéro du port  pour se... Show More

    Bonjour, 

    Je n'arrive pas a me connecté au cluster Dataproc depuis Qlik replicate. 

    ELHARRAS_0-1711467658369.png

    Erreur veut dire que l'adresse host et le numéro du port  pour se connecter à Hive qui bloque par contre la config pour le cloud Storage est OK . 

    Cordialement.

    Cordialement. 

    Show Less
  • forum

    Qlik Replicate

    TSWP Files

    Can I manually apply tswp files from terminal ?
  • 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
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!