Skip to main content

Welcome to
Qlik Community!

cancel
Showing results for 
Search instead for 
Did you mean: 
  • 245,176 members
  • 5,308 online
  • 2,028,456 posts
  • 152,634 Solutions
Announcements
Qlik Connect 2025! Where innovative solutions turn your data visions into reality: REGISTER TODAY

Welcome to Qlik Community

Recent Discussions

  • forum

    Qlik Enterprise Manager

    How to add Groups/Users to admin capabilties during automated installation

    The Qlik Enterprise manual states "By default, the user under whose account youinstall Enterprise Manager is associated with the Admin role".  But in ... Show More

    The Qlik Enterprise manual states "By default, the user under whose account you
    install Enterprise Manager is associated with the Admin role".  But in our scenario we are provisioning a server via the cloud and installing the product as part of the bootstrap process under the local Administrator account.  

    How can we specify initial groups with access as part of the bootstrap process?  Are there command line calls we can call that will add AD groups to the different Qlik roles, especially the Admin role?  

    Show Less
    Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
  • forum

    QlikView Connectivity

    Connecting to a PostgreSQL data base

    I'm in trouble when attempting to extract data from a PostgreSQL data base. I've received the following message: "SQL##f - SqlState: S1001, ErrorCode:... Show More

    I'm in trouble when attempting to extract data from a PostgreSQL data base. I've received the following message: "SQL##f - SqlState: S1001, ErrorCode: 4, ErrorMsg: Out of memory while reading tuples." I'm using PostgreSQL30 odbc driver. But, even when using PostgreSQL35 odbc driver the same issue accurs. Anyone knows how to fix this issue?

    Show Less
    Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
  • forum

    Move to Qlik Cloud Analytics

    Assistance with Qlik Sense

      I am a student trying to access Qlik Sense, but I am encountering an issue. After logging in, I receive the message "No Tenants to manage", and I am... Show More

     

    I am a student trying to access Qlik Sense, but I am encountering an issue. After logging in, I receive the message "No Tenants to manage", and I am unable to proceed. I have attached a screenshot of the error for reference.

    Could you please help me understand why I do not have access and how I can resolve this issue?

    Thank you in advance for your support!

     

     

     

    Show Less
    Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
  • forum

    App Development

    Change in column Title visualization.

    How can i change a title in a visualization Dinamic Table, in irder to read it  in tu line. Ie: Sell Date , must end with Sell in the upper line and d... Show More

    How can i change a title in a visualization Dinamic Table, in irder to read it  in tu line. Ie: Sell Date , must end with Sell in the upper line and date in the down line. 

    Show Less
    Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
  • forum

    Installing and Upgrading

    Issue with while build/publishing jobs in TAC

    Summary:Steps to reproduce :1->install talend studio and configure the connection 2->Run a job , it will populate a window to download/installer if an... Show More

    Summary:
    Steps to reproduce :
    1->install talend studio and configure the connection
    2->Run a job , it will populate a window to download/installer if any jar requires
    after installing required jars , job is working fine .
    and run any other job which has similar connection , it will run
    3->To publish the job in tac, we should check the publish to antifactory repo in feature manager
    So click Feature Manager ->it will ask to agree updates ->click on yes, update option-> It will update studio.
    4->After updates it will ask to restart the studio, click on okay
    When studio restarted , Run already executed job again , it will give the error as below:

    Execution failed :org.talend.commons.exception.PersistenceException: The Job "CDC_S_PROJ" has wrong configuration. Fix it and try again.
    Error Line: 28088
    Detail Message: oracle cannot be resolved to a type
    [The Job "CDC_S_PROJ" has wrong configuration. Fix it and try again.
    Error Line: 28088
    Detail Message: oracle cannot be resolved to a type]

    Observation:
    If we install and provide oracle jar again , current job will run but any other job which has the oracle connection as input that will not run , we have to open the job and click on apply and set the t_map mappings to execute jobs.
    Means, when we install any job that is not applying on repo as expected, the same will work before click on feature Manager.

    Show Less
    Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
  • forum

    Integration, Extension & APIs

    Pagination with Multiple @odata.nextLink Values in Qlik REST Connector

    Hello Qlik Community, I'm working on a REST API integration with Microsoft Dynamics Business Central where I'm using a batch transaction request to pu... Show More

    Hello Qlik Community,

    I'm working on a REST API integration with Microsoft Dynamics Business Central where I'm using a batch transaction request to pull multiple company data in a single query for efficiency. However, I’m running into an issue with pagination in the Qlik REST Connector.

    The API returns multiple responses in a single call, and each response contains its own @odata.nextLink for pagination. I’ve tried different variations of the Next URL Path, but so far, I haven’t been able to successfully paginate through all the responses.

    Here’s an example of the API response structure:

     

    {
      "responses": [
        {
          "body": {
            "data": [...],
            "@odata.nextLink": "https://api.businesscentral.dynamics.com/tenant/api/v2.0/companies(abe78fd7-84ab-ec11-80f1-000d3a0d0053)/generalLedgerEntries?aid=FIN&$skiptoken=900f4805-4147-ee11-be6d-6045bdd2c536"
          }
        },
        {
          "body": {
            "data": [...],
            "@odata.nextLink": "https://api.businesscentral.dynamics.com/tenant/api/v2.0/companies(bcfcf5d3-4c90-4dff-9b29-63d2fb95a173)/generalLedgerEntries?aid=FIN&$skiptoken=d235fd2f-dc57-4186-8a67-e9430b445d7c"
          }
        }
      ]
    }
    

     

     

    As you can see, each response in the responses array has its own @odata.nextLink, which points to the next set of data for each respective company. The URL format looks like:

     

     

    https://api.businesscentral.dynamics.com/<TENANT>/api/v2.0/companies(<COMPANY_ID>)/generalLedgerEntries?aid=FIN&$skiptoken=<TOKEN>

     

     

    Where <TENANT> is the tenant identifier, <COMPANY_ID> is a unique company ID for each company in the request, and <TOKEN> is a dynamic pagination token.

    My Question:

    • Does the Qlik REST Connector support multiple iterations of the @odata.nextLink (one for each response object) during pagination in a batch transaction request?
    • If so, how do I correctly set the Next URL Path to iterate over each @odata.nextLink in the responses array?

    I’ve tried the following paths without success:

    • root/responses/body/@odata.nextLink
    • root/responses/0/body/@odata.nextLink
    • root/responses/*/body/@odata.nextLink (which I hoped would loop through each response)

    I can get this working in Python, but I’d much rather have it built directly in Qlik. The workaround I've developed is running it in Python, converting the results to a QVD, and then uploading that into my Qlik Cloud tenant. But ideally, I want to streamline this process and avoid the need to rely on Python.

    Has anyone encountered a similar issue or have any suggestions on how to approach this?

    Any guidance or tips would be greatly appreciated!

    Thanks in advance!

    Show Less
    Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
  • forum

    App Development

    Clientes Ativos Acumulados 12 meses

    Hello, I would like your help! I am working with information on accumulated clients per month, without repeating them. In other words, within each mon... Show More

    Hello, I would like your help!

    I am working with information on accumulated clients per month, without repeating them. In other words, within each month, I need to accumulate active clients in the last 12 months. I would like to do this in Set Analisys, but if you have another idea, I accept doing it in the script. Below is what I'm using:

    RangeSum(
    Above(
    Aggr(
    COUNT({<
    TransactionType = {'Billing'},
    SiteNumber = {'3500'},
    SalesOrderType = P(FilterSalesOrderType),
    SalesOrderType = {'Order','Exchange of Goods'},
    SalesOrderItemUnitSalesValue = {">0"},
    YearMonth = YearMonth
    >} DISTINCT SalesOrderCustomerCode),
    YearMonth
    ), 0, 12
    )
    )

    Show Less
    Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
  • forum

    Deployment & Management

    Changing Central Node Manually, 403 Error

    Hello Folks, I'm hoping to use Powershell to get my Qlik cluster to switch central nodes.  Right now, I've got the following code which works correctl... Show More

    Hello Folks,

    I'm hoping to use Powershell to get my Qlik cluster to switch central nodes.  Right now, I've got the following code which works correctly.

     

    $hdrs = @{}
    $hdrs.Add("X-Qlik-xrfkey","12345678qwert2ui")
    $url = "https://002.megacorp.com/admin/qrs/ServerNodeConfiguration/full?xrfkey=12345678qwert2ui"
    $clusterNodes = Invoke-RestMethod -Uri $url -Method Get -Headers $hdrs -UseDefaultCredentials

     

     

    But when I send the request to change, I get a 403.  I am sending this request with RootAdmin privileges.

     

    $destinationNodeName = '003.megacorp.com'
    $currentCentralNode = $clusterNodes | Where-Object { $_.isCentral -eq $true }
    
    $destinationCentralNode = $clusterNodes | Where-Object { $_.hostName -match $destinationNodeName }
    $destinationCentralNodeGuid = $destinationCentralNode.id
    
    $changeOverPutUrl = "https://003.megacorp.com/admin/qrs/failover/tonode/${destinationCentralNodeGuid}"
    Write-Host $changeOverPutUrl
    $response = Invoke-RestMethod -Uri $changeOverPutUrl -Method Post -Headers $hdrs -UseDefaultCredentials

     

    justindallasverizon_0-1741626105060.png

    When I look into the logs, I see "InvalidConnection" along with the 403 code

    justindallasverizon_0-1741632868304.png

     

    What might I be doing wrong? 

     

    Any help is greatly appreciated.

     

     

     

     

    Show Less
    Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
  • forum

    App Development

    Map Object Puerto Rico Issues

    I have a map object where I'm pulling in United States import data and mapping them according to the port of entry. They're coming in as a city and a ... Show More

    I have a map object where I'm pulling in United States import data and mapping them according to the port of entry. They're coming in as a city and a two letter state (like Houston, TX). If I don't put 'US' as the country then it will do thinks like show "Port Arthur, TX" in China and "St. Albans, VT" in England, but setting the country code to 'US' is not showing "San Juan, PR" on the map, neither does setting the country as 'PR'. How do I simultaneously show "San Juan, PR" while also showing the rest of the cities correctly on the map. Thank you.

    clifford_0-1741368013865.png

    clifford_0-1741368346305.png

    clifford_1-1741368409957.png

     

     

     

    Show Less
    Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
  • forum

    Qlik Cloud Data Integration

    Execute a Job in Oracle

    Hello, i need a execute a oracle job in my Qlik Cloud, in my app i try this:  SQLBEGIN DBMS_SCHEDULER.RUN_JOB('SOLUS_NINF.J_CARGAS_GUIAS'); but receiv... Show More

    Hello, i need a execute a oracle job in my Qlik Cloud, in my app i try this: 

    SQL
    BEGIN
    DBMS_SCHEDULER.RUN_JOB('SOLUS_NINF.J_CARGAS_GUIAS');

    but receive this error:

    Ocorreram os seguintes erros:
    Internal error. (Connector error: Status(StatusCode="InvalidArgument", Detail="ERROR [HY000] [Qlik][OracleOCI] (3000) Oracle Caller Interface: ORA-06550: line 2, column 55: PLS-00103: Encountered the symbol "end-of-file" when expecting one of the following: := . ( % ; "))

    V_Ortis_0-1741631723415.png

     

     

     

    Show Less
    Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Weekly Leaderboard

Customer Story

Optimizing Food Relief with Qlik

Qlik empowers Foodbank Victoria with real-time data insights, optimizing food acquisition and distribution to deliver 25 million meals annually while reducing waste and costs across its statewide relief efforts.

Location and Language Groups

Choose a Group

Join one of our Location and Language groups. Find one that suits you today!

Collaborate

Blogs

Community News

Hear from your Community team as they tell you about updates to the Qlik Community Platform and more!