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

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 ?

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

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

Thanks a lot in advance.

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:

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

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

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.

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 tried droping table, redeplying project but same error.

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])