Skip to main content

Welcome to
Qlik Community!

cancel
Showing results for 
Search instead for 
Did you mean: 
  • 225,507 members
  • 5,979 online
  • 2,007,405 posts
  • 150,599 Solutions
Announcements
NEW Customer Portal: Initial launch will improve how you submit Support Cases. FIND OUT MORE

Welcome to Qlik Community

Recent Discussions

  • forum

    New to Qlik Analytics

    Get Max of Period

    Hi  I'm new Qlik and developing dashboard and i'm stuck with below task I have dimension called period consists values (FY22, FY23, 1H22, 1H23) and wa... Show More

    Hi 

    I'm new Qlik and developing dashboard and i'm stuck with below task

    I have dimension called period consists values (FY22, FY23, 1H22, 1H23) and want to take max of period column value. 

    The desired output should be FY23

    Is there a way to achieve this in Qlik sense

     

    Show Less
  • forum

    Integration, Extension & APIs

    Pulling Data from Qlik Cloud through python on window machine

    Hello folks, I am trying to read data from Qlik Cloud into my Python script on my Windows laptop, but I'm encountering errors:   import requests impor... Show More

    Hello folks,

    I am trying to read data from Qlik Cloud into my Python script on my Windows laptop, but I'm encountering errors:

     

    import requests
    import pandas as pd
    import matplotlib.pyplot as plt
    import base64
    import json
    qlik_base_url = "https://mytenant.qlikcloud.com/"
    qlik_app_id = "f5555629-bb12-4983-854b-1ed7c9682f55"
    qlik_table_object_id = "ZgGPbV"
    qlik_api_token = "api_key" #this api key is correct
    
    qlik_data_url = f"{qlik_base_url}/api/v1/apps/{qlik_app_id}/tables/{qlik_table_object_id}/data" 
    headers = { "Authorization": "Bearer " + qlik_api_token } 
    response = requests.get(qlik_data_url, headers=headers)
    # Check for successful response status
    if response.status_code == 200:
        try:
            table_data = response.json()
        except requests.exceptions.JSONDecodeError as e:
            print(f"Error decoding JSON: {e}")
            table_data = None
    else:
        print(f"Failed to fetch data. Status code: {response.status_code}")
        table_data = None

     

    but the output is 

    Failed to fetch data. Status code: 401

     please, can anyone help me to resolve this, I am using correct api_key, my url, appId and object Id are all correct 

    Show Less
  • forum

    Qlik Replicate

    Possible to include timezone information in AR_H_COMMIT_TIMESTAMP?

    We are using the AR_H_COMMIT_TIMESTAMP variable in a global transformation that writes to a Snowflake target.  The date in Snowflake is being created ... Show More

    We are using the AR_H_COMMIT_TIMESTAMP variable in a global transformation that writes to a Snowflake target.  The date in Snowflake is being created as a TIMESTAMP_LTZ column.  However, we are finding that the timezone information is not being sent through by Qlik.

    For example, the commit timestamp being generated on the Qlik server (running in America/New_York time) is 16:00:00.  But when it is being written to Snowflake it is simply writing the 16:00:00 without the timezone information and therefore considers the 16:00:00 in the default timezone for the Snowflake account, in this case America/Los_Angeles time.

    Is there a way within Qlik Replicate to send the timezone information along with the timestamp so that a TIMESTAMP_LTZ column within Snowflake will reflect the true time and time zone for when the data was committed?

    Show Less
  • forum

    Qlik Application Automation

    List Values of Field & Condition Loop

    Hello guys! I am using "List Values of Field" block to iterate over different values of a list. I used a Condition Block which checks if the value obt... Show More

    Hello guys! I am using "List Values of Field" block to iterate over different values of a list. I used a Condition Block which checks if the value obtained by the list is equal to the value stored in the first row and first column of a variable I created (TableData[0][0]). When it is equal, the flow goes in the "Yes" flow which works out great. 

    How can I direct the flow to go to the next value in the List Values of FIeld in the "No" path of the condition block? That way, I will be able to use TableData[0][1] and equate it to the next value of the field.

    Show Less
  • forum

    App Development

    We can't convert the avg number of seconds to time format (we tried various solu...

    Hi, We have a measure that calculates the average value in seconds: Avg([ticket_stats.first_agent_response_time]) (`ticket_stats.first_agent_response_... Show More

    Hi,

    We have a measure that calculates the average value in seconds:

    Avg([ticket_stats.first_agent_response_time])

    (`ticket_stats.first_agent_response_time` is the number of seconds, and in Data model viewer it shows that it is $numberic $integer)

    The result is values ​​like:

    • 14,186.87
    • 53,156.22
    • 61,339.88
    • 29,087.98
    • 8,725.44

    RoyBatty_0-1721250449725.png

    We want to present those values ​​(which are in seconds) in a time format, D hh:mm:ss or maybe just hh:mm:ss (we are still not sure which format will suit us better).

    However, the problem is that we don't know how to do it. We searched the forum, we found many posts/solutions, but none of them work in our case. For example:

    =Interval(Avg([ticket_stats.first_agent_response_time])/86400,'D hh:mm:ss')

    Result:

    RoyBatty_1-1721250710833.png

     

    Also, the other solutions didn't work either:

    =Interval(Avg([ticket_stats.first_agent_response_time])/86400, 'hh:mm:ss') 

    =Interval(Interval#(ceil(Avg([ticket_stats.first_agent_response_time])),'s'), 'hh:mm:ss')

    =time(Avg([ticket_stats.first_agent_response_time])/3600/24, 'hh:mm:ss')

    =interval(timestamp#(ceil(Avg([ticket_stats.first_agent_response_time])), 's'), 'hh:mm:ss')

    =Time(Avg([ticket_stats.first_agent_response_time])/24/60/60,'hh:mm:ss')

    Do you have any suggestions?

    Show Less
  • forum

    New to Qlik Analytics

    No se visualiza Menú activable en los objetos y todo tipo de Tablas que estan de...

    Hola buenos días. Por favor de su amable apoyo para saber si con el nuevo Contenerdor de Diseño, es posible tener las opciones de Menú activable y bar... Show More

    Hola buenos días.

    Por favor de su amable apoyo para saber si con el nuevo Contenerdor de Diseño, es posible tener las opciones de Menú activable y barra de deslizamiento para todos los formatos de Tabla, ya que no he logrado aplicar esas opciones cuando coloco mi Tabla en el contenedor y si son muchos datos no es posible visualizar a menos que amplie el ancho del contenedor.

    barcd_3-1721319238887.png

     

    Por favor de su amable apoyo para saber si es posible activarlo o en su defecto no aplica esa opción con los objetos dentro del contenedor. 

    Muchas gracias de antemano, Saludos !!

     

     

     

     

     

    Show Less
  • forum

    Deployment & Management

    Upgrade QlikSense from November 2020 to May 2024

    Hi All, We are going to upgrade our Qliksense version November 2020 to May 2024, As we know that November 2020 using Postgres 9.6 so we can not direct... Show More

    Hi All,

    We are going to upgrade our Qliksense version November 2020 to May 2024, As we know that November 2020 using Postgres 9.6 so we can not directly upgrade this.

    Please suggest me the steps how I can achieve the same. Also, please let me know we have to upgrade Qliksense first or postgres?

    Thanks in advance.

    Show Less
  • forum

    Qlik Replicate

    How to convert CET/CEST datetime from an oracle column to utc timesatmp for post...

    I have an oracle source table with a column datetime datatype.  its store time in cet/cest timezone.  on target side i have a postgresql table with a ... Show More

    I have an oracle source table with a column datetime datatype. 

    its store time in cet/cest timezone. 

    on target side i have a postgresql table with a column having timestamp with timezone datatype. 

    i want to convert cet/cest time to utc while saving / add a proper time zone to date time coming from oracle. 

    Also this transformation should take care of CET to CEST change / CEST to CET change happening twice a year.

    Show Less
  • forum

    Integration, Extension & APIs

    Azure Open AI Connector Error : Resource not found

    Hello Everyone, I am stuck trying to add an Azure Open AI extension to a Qlik Cloud App. To start, here is the error message I get:  "The following er... Show More

    Hello Everyone, 
    I am stuck trying to add an Azure Open AI extension to a Qlik Cloud App. To start, here is the error message I get: 

    "The following error occurred:Connector reply error: grpc::StatusCode::FAILED_PRECONDITION: 'Error returned by endpoint: NotFound Resource not found'"

    Here is the doc I am following: Example 3: 'OpenAI Chat Completions API (GPT-3.5, GPT-4) - Rows' configuration | Qlik Cloud Help

    Here are the elements that the connector asks for: 

    Azure OpenAI API Key
    Azure Resource Name
    Azure Deployment Name
    Azure API Version
    {there are a few others that you don't need to update}
    ** Association Field (not officially required, but I think you need it for Generative AI stuff)
     
    Some questions I have: 
    The doc seems to be a little outdated. The new way to do 'Deployments' in Azure is through the 'Azure OpenAI Playground'. The docs seem to be referencing standing up an 'Azure OpenAI Service' (Object, whatever you call it from the marketplace.). 

    Are there more specific instructions as to what was required to be set up in Azure? 
    Are there more Updated Docs? 
    Do any of the completion models work (4-o Completions works?)

    And any help around that error would be very much appreciated. Thank you! 
     
     
     
    Show Less
  • forum

    Deployment

    Job timeout in Talend 8

    Hi Team,   We are facing a scenario wherein all our jobs on newly upgrade TAC 8 are showing a timeout limit of 3600 seconds. Although we never had thi... Show More

    Hi Team,

     

    We are facing a scenario wherein all our jobs on newly upgrade TAC 8 are showing a timeout limit of 3600 seconds. Although we never had this option on our 7.3 version we still started getting this on all our jobs when migrated to 8 version. Is there any global setting in any file where we can change this parameter to reflect on all our jobs in one go.

    Show Less
Leaderboard

Customer Story

Accelerating Decision-Making with Qlik Insights

Qlik enhances decision-making with high-speed insights, as Mayborn Group integrates data from various functions across their global operations, gaining a competitive edge in the childcare industry.

Customer Story

Efficiency in Agriculture: Nortera's Qlik Triumph

Nortera leads agricultural manufacturing analytics and automation with Qlik, reducing short-shipment rates and annual savings in water consumption.

Customer Story

Revolutionizing aircraft production through Data Analytics

Qlik Data Integration transforms Airbus' aircraft production, leading to over 150 replication tasks and informing more efficient analysis.

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!