Skip to main content

Welcome to
Qlik Community!

cancel
Showing results for 
Search instead for 
Did you mean: 
  • 215,373 members
  • 4,323 online
  • 1,991,748 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

    New to Qlik Analytics

    Run task in business hours

    Hello, Could anyone explain me a little I got confused about Custom increment and Custom filter in Task Manager. I want to reload the app every two ho... Show More

    Hello,

    Could anyone explain me a little I got confused about Custom increment and Custom filter in Task Manager.

    I want to reload the app every two hours between 08:00-18:00. The app should reload on 08:15, 10:15, 12:15... 17:15.

    I have read the article but yet cannot come up with a solution.

    Reload tasks - Custom option | Qlik Sense for administrators Help

    Thank you!

    Show Less
  • forum

    New to Qlik Analytics

    Qlik sense license

    Hi Guys, I bought qlik sense license I received three lef one is special edition - Developmenet , Another is Special Edition - Test with different con... Show More

    Hi Guys,

    I bought qlik sense license I received three lef one is special edition - Developmenet , Another is Special Edition - Test with different control number how to use this and what is the use of this

    Show Less
  • forum

    Component Development

    Talend Data Integration Certified Developer Exam

    Hello everyone, I trust this message finds you well. I am reaching out because I am interested in obtaining certification in the "Talend Data Integrat... Show More

    Hello everyone,

    I trust this message finds you well.

    I am reaching out because I am interested in obtaining certification in the "Talend Data Integration Certified Developer Exam." However, I am unsure about the types of questions that will be asked, and I would greatly appreciate any examples or guidance to help me prepare effectively before taking the exam.

    If anyone could provide assistance or share some sample questions, it would be immensely helpful.

    Thank you in advance for your support.

    Best regards,

    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

    Stitch

    Talend Data Integration Certified Developer Exam

    Hello everyone, I trust this message finds you well. I am reaching out because I am interested in obtaining certification in the "Talend Data Integrat... Show More

    Hello everyone,

    I trust this message finds you well.

    I am reaching out because I am interested in obtaining certification in the "Talend Data Integration Certified Developer Exam." However, I am unsure about the types of questions that will be asked, and I would greatly appreciate any examples or guidance to help me prepare effectively before taking the exam.

    If anyone could provide assistance or share some sample questions, it would be immensely helpful.

    Thank you in advance for your support.

    Best regards,

    Show Less
  • forum

    App Development

    Qlik reload fails -&gt; getting data from data gateway

    Hi all, We have an automation which kicks off various apps for reload. The data loader connects to an azure sql db using qlik data gateway (1.5.2).  R... Show More

    Hi all,

    We have an automation which kicks off various apps for reload. The data loader connects to an azure sql db using qlik data gateway (1.5.2). 

    Running manually works fine. However we have gotten the following error when running through the automation:

    (Connector error: 'D' is an invalid start of a value. LineNumber: 0 | BytePositionInLine: 0.)

    What could be the problem?

    Show Less
  • forum

    Integration, Extension & APIs

    Access Qlik NPrinting API's using JWT auth token

    I am trying to trigger an NPrinting task externally using API's. Using the JWT authentication token I send a GET request to api/v1/apps endpoint, to g... Show More

    I am trying to trigger an NPrinting task externally using API's.

    Using the JWT authentication token I send a GET request to api/v1/apps endpoint, to get a list of all the apps my user can see in NPrinting.

    I get a 403 error. 

    I tested that the auth token works from browser. But on the api request I get a 403.

    Any leads on how to use JWT auth to call any Nprinting API's?

    Show Less
  • forum

    App Development

    Null values in If Statements

    Hi all, I'm using the following calculated dimension to compare two columns that contain quite a few nulls. =IF(IF(ISNULL([t1.col]), 'Val', [t1.col])=... Show More

    Hi all,

    I'm using the following calculated dimension to compare two columns that contain quite a few nulls.

    =IF(
    IF(ISNULL([t1.col]), 'Val', [t1.col])
    =
    IF(ISNULL([t2.col]), 'Val', [t2.col]),
    0,
    1)

    The columns are basically both the same and as a result, I'm getting a lot of NULL values where both columns contain null values but I want the expression to print 0 if the two values are equal (and I'd consider them to be equal if they are both null).

    I've tried this method, and I've also tried using ALT, as well as LEN(t1.col)<1 but neither of these has corrected the issue.

    I found this article:

    https://help.qlik.com/en-US/sense/February2024/Subsystems/Hub/Content/Sense_Hub/Scripting/null-value-handling.htm

    which says that comparing any two null values with any relational operator will result in a null value. But I thought I could circumvent this issue by converting all of my null values into text, however this doesn't seem to work.

    Any help on this would be appreciated, I've tried pulling out each side of the operator in order to confirm that this code:

    IF(ISNULL([t1.col]), 'Val', [t1.col])

    will in fact convert null values into text and it seems to be working just fine but for some reason the if statement still doesn't work.

    Thanks in advance for the help!

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

    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
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!