Skip to main content

Welcome to
Qlik Community!

cancel
Showing results for 
Search instead for 
Did you mean: 
  • 215,420 members
  • 2,794 online
  • 1,991,794 posts
  • 149,214 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 Application Automation

    "Do lookup" not working on Add a Chart to Report block

    hi, I am using Add a Chart to Report block and when I try to find the object using "do lookup". It doesnt find my object. The object is in a published... Show More

    hi,

    I am using Add a Chart to Report block and when I try to find the object using "do lookup". It doesnt find my object.

    The object is in a published sheet and I also got the object id using /options/developer mode.

    Any clue about that?

    Thanks in advance

    suggestion: maybe this block should first select the sheet and then do a lookup on the elements inside the selected sheet. Because there are lots os elements in the app, so the lookup takes too long

    Show Less
  • forum

    New to Qlik Analytics

    Does this code make sense?

    I'm an intern and I'm trying to determine whether a file was created today before 6.15 am or not. I'm using vfileexists as a counter. I have a Nprinti... Show More

    I'm an intern and I'm trying to determine whether a file was created today before 6.15 am or not. I'm using vfileexists as a counter. I have a Nprinting app through which I'm trying to shoot a mail if the condition is not satisfied. Any help is appreciated! Thanks!

    Show Less
  • forum

    Connectivity & Data Prep

    500 Internal Sever Error for SharePoint Metadata connector

    I am Trying  to connect SharePoint list to Qlik using Qlik's SharePoint Metadata connector.  As there are multiple view present in the SharePoint li... Show More
    I am Trying  to connect SharePoint list to Qlik using Qlik's SharePoint Metadata connector. 
    • As there are multiple view present in the SharePoint list, I want to retrieve data from particular view 
    • while  previewing data from a particular view, I am getting a "Internal Server error" with error code 500.
      subham_0-1708079261051.png

       

    • One possible reason might be number of columns as these two view have too  many columns(>50) and records(>20k), but I am able to retrieve data from other views where number of columns are significantly less.
    • I tried manually to retrieve 2 columns with 10 record using script but the error remains the same.
      subham_1-1708079261052.png

       

      I am not sure whether number of fields is an issue here, as the connector is not allowing to connect with the SharePoint list with particular view.
    Show Less
  • forum

    Qlik Replicate

    Replicate data from last 24 months

    Hello, My Source connection is an Oracle database. I have audit tables in my Replicate task "Full Load + Apply Changes" the tables are huge and by nat... Show More

    Hello,

    My Source connection is an Oracle database. I have audit tables in my Replicate task "Full Load + Apply Changes"

    the tables are huge and by nature there is heavy DML operations. 

    My target is Snowflake "Extra Small Size", I see significant amount of latency when i tried replicating audit tables. 

    Is there a way I can limit the date range to be at most 24 months of history data in the replicate task ?

     

    Thank you.

    Show Less
  • forum

    Qlik Application Automation

    Automation to receive selections from App and pass it to a report

    Good day Qlik community, I have an unusual requirement. I want my users to be able to click on a button on an app and call an automation sending their... Show More

    Good day Qlik community,

    I have an unusual requirement. I want my users to be able to click on a button on an app and call an automation sending their selections to the automation and applying the selections to the report. The first part is easy and it is working. I can pass and receive the selections in the automation.

    The part that I cannot get it right is the one to pass the selection to the report. For some strange limitation, if I apply a bookmark to my automation, the report totally ignores it. I have to explicitly pass each field selection to the report using the Add Selections to report.

    It does work if I create one of these blocks for each field but would require for me to know fields the user will select, which I don't. What I want is to loop through each field and apply the selection for that field.

    I am using the block "List Current Selections" to loop these fields. This seems to work. Inside that loop, I am trying to use the block Add Selectiction to Report". That one does not work. It forces me to pick a field by the index (0, 1, 2) instead of do what any loop does and get the index for the corresponding loop iteration.

    Ideas?

    These are some screenshots that might help:

    igoralcantara_1-1711725061434.png

    igoralcantara_2-1711725085340.png

     

    igoralcantara_3-1711725107227.png

     

    Show Less
  • forum

    Qlik Enterprise Manager

    Reload QEM task using Python API with filters

    Hi,   I am trying to reload a Qlik Replicate task using QEM Python API.  I am using reload_table method to achieve my goal. However, I do not see any ... Show More

    Hi,

     

    I am trying to reload a Qlik Replicate task using QEM Python API. 

    I am using reload_table method to achieve my goal.

    However, I do not see any option to define filters using the above method. 

    I have tried the below:

    reload_table(server, table, filters:{col1:value1,value2})

    but that doesn't work.

    Is there any way to achieve my said requirement using the above method or is there any other method which I can use to reload the task with table filters. 

    Kindly assist. 

    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

    Qlik Compose for Data Warehouses

    Mapping expression results not pushing through to data warehouse

    I have updated the mapping for a particular field but can't figure out how to convince Compose to make the changes on previously written records. New ... Show More

    I have updated the mapping for a particular field but can't figure out how to convince Compose to make the changes on previously written records. New records to the table are correct.

    Testing the expression in the GUI gives the expected result:

    JacobTews_0-1710522998871.png

     

    However, after loading, only newly-written values are correct in the table in the data warehouse:

    JacobTews_1-1710523046137.png

     

    I have tried running an incremental load as well as a full load on the table, have cleared the metadata cache and the landing cache. It seems like I'm missing something obvious...any ideas?

    Qlik Compose for Data Warehouses Qlik Compose 

    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

    Installing and Upgrading

    download talend desktop

    hello everyone, i want to know if i can download the TOS desktop after january 2024, if anyone have a truc or something please tell me 
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!