Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Welcome to
Qlik Community!

cancel
Showing results for 
Search instead for 
Did you mean: 
  • 248,769 members
  • 5,406 online
  • 2,031,464 posts
  • 152,941 Solutions
Announcements
WEBINAR April 23, 2025: Iceberg Ahead: The Future of Open Lakehouses - REGISTER TODAY

Welcome to Qlik Community

Recent Discussions

  • forum

    Connectivity & Data Prep

    How to Connect Local Excels files in Qlik sense Cloud.

    I have a virtual machine with some Excel (.xls) files saved in a local folder.I manually upload these files using the Data Manager in Qlik Sense to cr... Show More

    I have a virtual machine with some Excel (.xls) files saved in a local folder.
    I manually upload these files using the Data Manager in Qlik Sense to create an app.

    However, when I reload the app, it fetches data from the uploaded file stored under 'Data Files' within Qlik Sense, rather than from the original source file in the local folder.

    As a result, any changes made to the original Excel file (or if I replace it with a new version) are not reflected in the app after a reload.

    I would like the app to always load the most recent data from the source Excel file in the local folder on the VM.
    How can I achieve this?


    -I also install Qlik Gateway- Direct access
    -Also try to achieve this Using Qlik Data Transfer but not able to achieve

     

    Show Less
  • forum

    App Development

    Set analysis sur un champ date

    Bonjour,  Je voudrais faire un set analysis qui me renvoi le nombre de vente réalisé par un opérateur depuis la dernière date possible.J'ai fais ce se... Show More

    Bonjour, 

     

    Je voudrais faire un set analysis qui me renvoi le nombre de vente réalisé par un opérateur depuis la dernière date possible.

    J'ai fais ce set  " =Sum({$<[TRL-DATMVT]={'=$(max(TRL-DATMVT)-1)'}>}[TRL-QTEUV]) " et le résultat me renvoi 0.

    Alors que je devrais avoir 179 

    Pouvez-vous m'aider svp ?

    sebios_0-1744980534593.png

     

    Show Less
  • forum

    Connectivity & Data Prep

    Data Gateway - Connector error gRPC server failed to initialize after 3 attempts...

    Hi All, After the upgrade from Data Gateway 1.7.0 to 1.7.3 file connector or ODBC connector are not working any longer.Connector process started but g... Show More

    Hi All,

     

    After the upgrade from Data Gateway 1.7.0 to 1.7.3 file connector or ODBC connector are not working any longer.

    Connector process started but gRPC server failed to initialize after 3 attempts (DirectAccess-5000)

    Environment:

    • Windows Server 2022 Standard
    • Microsoft .Net Runtime 8.0.11
    • Microsoft ASP.NET Core 8.0.11
    • Microsoft Visual C++ 2015-2022 Redistributable
    • Data Gateway 1.7.3

    Data Gateway status is Connected. 

    For instance: using ODBC connector I can test connection and status is successful. I can then connect to SQL server find data base and table. I can even see the sample data and generate script. Everything seems to work unless I run the script. Then I get an errors:

    File connector
    (Connector error: Unknown reason:. Connector process started but gRPC server failed to initialize after 3 attempts (DirectAccess-5000)
    ODBC connector
    Connector error: Unknown reason:. Connector process started but gRPC server failed to initialize after 3 attempts (DirectAccess-1500)

    In logs I can see:

    [DEBUG] DAG - RequestId=NA ClientSessionId= ReloadId=NA AppId=NA Message=Testing connection to connector on port 49152, attempt 1 of 3. ODBC process (12408)
    [ 8] [WARN ] DAG - RequestId=NA ClientSessionId= ReloadId=NA AppId=NA Message=ODBC connector process (12408) with worker process (22624) is not listening on Data Port: 49152 or Management Port: 49153, attempt 1 of 3
    [ 8] [DEBUG] DAG - RequestId=NA ClientSessionId= ReloadId=NA AppId=NA Message=Testing connection to connector on port 49152, attempt 2 of 3. ODBC process (12408)
    [ 8] [WARN ] DAG - RequestId=NA ClientSessionId= ReloadId=NA AppId=NA Message=ODBC connector process (12408) with worker process (22624) is not listening on Data Port: 49152 or Management Port: 49153, attempt 2 of 3
    [ 8] [DEBUG] DAG - RequestId=NA ClientSessionId= ReloadId=NA AppId=NA Message=Testing connection to connector on port 49152, attempt 3 of 3. ODBC process (12408)
    [ 8] [WARN ] DAG - RequestId=NA ClientSessionId= ReloadId=NA AppId=NA Message=ODBC connector process (12408) with worker process (22624) is not listening on Data Port: 49152 or Management Port: 49153, attempt 3 of 3
    [ 8] [WARN ] DAG - RequestId=NA ClientSessionId= ReloadId=NA AppId=NA Message=ODBC connector process (12408) with worker process (22624) failed readiness check, going to kill it...
    [ 8] [INFO ] DAG - RequestId=NA ClientSessionId= ReloadId=NA AppId=NA Message=An old instance of ODBC (12408 started 5 seconds ago) is running, going to kill it...

    Is it something related with the port? 

    Why File connector and ODBC connector are listening on port 49152? I could not find this port in documentation...

    Any ideas? 

    Thanks in advance!

     

    BR,

    Piotr

     

     

     

     

    Show Less
  • forum

    Pipeline Designer

    SSL Error while Setting up Data Pipeline in Data integration

    Hello everybody, i'm trying to set up a data pipeline and i want to use Qlik Cloud as data platform   But when i try to create a connection for stagi... Show More

    Hello everybody, i'm trying to set up a data pipeline and i want to use Qlik Cloud as data platform

    vintac_0-1729853560882.png

     

    But when i try to create a connection for staging area using AWS S3 i keep getting an SSL error, i can't find a way to solve it, can anyone give me any advice about how to solve it?

    vintac_1-1729853809023.png


    Thanks a lot in advance.

    Show Less
  • forum

    QlikView Integrations

    Intermittent PDF Export Failure with QlikView API - 'Prohibit validate' Error"

    Hello everyone,we are encountering issues with the QlikView API (Interop.QlikView) — specifically, we're trying to export a report to PDF using our ow... Show More

    Hello everyone,
    we are encountering issues with the QlikView API (Interop.QlikView) — specifically, we're trying to export a report to PDF using our own printer. Sometimes the PDF is generated without any issues, and other times it fails.

    Looking into the .qvw log file, we found the following entries:

     
    20250415T143120.000+0200 20250415T143122.000+0200 1 300 Error Doc::GetLayout error:14 message:"Prohibit validate": c22cd5b-aac9-4bcb-a4a3-a2a04b04288 20250415T143353.000+0200 20250415T143354.000+0200 1 300 Error ListBox::GetListBoxCellsEx error:14 message:"Prohibit validate": 89db8e5-d38c-4742-ba62-82b6c819910
     

    We're using C# - .NET Framework 4.6.

    Show Less
  • forum

    Qlik Compose

    Not able to discover tables under Metadata in qlik compose

    Hi, We have replicate + compose architecture where replicate is loading data on landing layer and compose on Bronze layer in AWS Databricks unity Cata... Show More

    Hi,

    We have replicate + compose architecture where replicate is loading data on landing layer and compose on Bronze layer in AWS Databricks unity Catalog.

    The tables created by Replicate in Landing layer are not displaying when discovering in Metadata section of compose.

    If we try to discover same tables using another instance of compose it is working.

    Both compose instance are on Nov-2023 version and Replicate is on May-2024 version.

    We have checked the permission and it is same for both instance and on databricks

     

    Anyone faced similar issue and what was the resolution or workaround?

     

    Thanks

    Show Less
  • forum

    Data Movement & Streaming

    Qlik data movement gateway rpm installation on RHEL server did not create any di...

    Hi Team,I have successfully installed Qlik data movement gateway rpm file on RHEL server to replicate data from on-premise ibm iseries database to sql... Show More

    Hi Team,

    I have successfully installed Qlik data movement gateway rpm file on RHEL server to replicate data from on-premise ibm iseries database to sqlserver database. But in this process directories and sub directories are not created(it should create in gateway server). This issue leading to msodbcsql driver installation failure. Kindly help me here.

    Show Less
  • forum

    Data Movement & Streaming

    Does Qlik Replicate work for D3 Multiview

    Hello does anyone know if Qlik Replicate works for D3 Multiview databases?
  • forum

    Qlik Compose

    Unable to create data warehouse compose

    Dear experts,We are trying to move data from query based table into DWH table but while creating data warehouse we are getting below error : We have t... Show More

    Dear experts,

    We are trying to move data from query based table into DWH table but while creating data warehouse we are getting below error :

    Tool_Tip_0-1742365036818.png

     

    We have tried droping table, redeplying project but same error.

    Show Less
  • forum

    App Development

    Disregard filtering on function in Set Analysis

    Hi,can you suggest please how I could modify the set analysis below so that the [Actual Start Date Category A] doesn't react to Year field (which is a... Show More

    Hi,

    can you suggest please how I could modify the set analysis below so that the [Actual Start Date Category A] doesn't react to Year field (which is associated to [Actual Start Date Category A] in data model)

    count({<[Actual Start Date Category A] = {">$(=AddYears(today(),-1))"}>} distinct [Category B]).

    This modification doesnt work:

    count({<Year=, [Actual Start Date Category A] = {">$(=AddYears(today(),-1))"}>} distinct [Category B])

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

Customer Story

Data-Driven Strategies Set To Fuel Growth

Qlik accelerates decision-making at Alpha Auto Group, enabling seamless data integration and automation across dealerships, cutting reporting times, and driving scalable business growth.

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!