Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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:
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])
Workshops. Certifications. And Disney's Animal Kingdom® Theme Park. Only at Qlik Connect. May 13 - 15.
Optimize your data strategy with Iceberg lakehouse insights, cost-saving tips, and a preview of Qlik Talend Cloud’s no-code integration.
Data Flow simplifies, democratizes, and accelerates the last mile of data preparation for analytics, machine learning, and AI.
Read how to embed AI-powered analytics to innovate, enhance customer satisfaction, and fuel business growth.
Your journey awaits! Join us by Logging in and let the adventure begin.
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.
Qlik accelerates decision-making at Alpha Auto Group, enabling seamless data integration and automation across dealerships, cutting reporting times, and driving scalable business growth.
Qlik Data Integration transforms Airbus' aircraft production, leading to over 150 replication tasks and informing more efficient analysis.
Join one of our Location and Language groups. Find one that suits you today!
A private group is for healthcare organizations, partners, and Qlik healthcare staff to collaborate and share insights..
Qlik Communityの日本語のグループです。 Qlik製品に関する日本語資料のダウンロードや質問を日本語で投稿することができます。
Welcome to the group for Brazil users. .All discussions will be in Portuguese.
Hear from your Community team as they tell you about updates to the Qlik Community Platform and more!