Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
Has anyone managed to use the Progress OpenEdge data source with Qlik Data Gateway?
I am getting error "Status(StatusCode="Internal", Detail="Command testconnection returned non-success: Error message: Please check the values for Username‚ Password‚ Host and other properties. Description: Invalid connection string attribute - ERROR [08001] [DataDirect][ODBC Progress OpenEdge Wire Protocol driver]Connection refused. Verify Host Name and Port Number. ERROR [HY000] [DataDirect][ODBC Progress OpenEdge Wire Protocol driver]Connection refused.[DataDirect][ODBC Progress OpenEdge Wire Protocol driver]Invalid attribute in connection string: Server. Verify Host Name and Port Number.[DataDirect][ODBC Progress OpenEdge Wire Protocol driver]Invalid attribute in connection string: Server.[DataDirect][ODBC Progress OpenEdge Wire Protocol driver]Invalid attribute in connection string: gatewayInstance."
What was done:
- Installed the Progress 12.2 ODBC Driver driver, configured it and the connection test was successful;
- During the connection, an attempt was made to fill in the Connection String field as shown in the example image available at https://help.qlik.com/en-US/cloud-services/Subsystems/ODBC_Connector_help/Content/Connectors_ODBC/ODBC-DrectAccess/sample-connection-strings.htm;
- QDG is working correctly with Microsoft SQL Server.
Could you help us with how to fill in these attributes?
Best Regards,
Madson
Salve,
ho una tabella che contiene delle righe con anno, mese, data movimento, ore effettive, ore teoriche mensili.
Vorrei creare una formula che sommi tutti i valori delle ore teoriche (uno per mese) e non di tutti i righi.
Ho provato con questa formula ma non funziona
Sum(Aggr(First(IF(Anno = $(vAnno), Valore)), Mese))
It seems like the org chart in the Qlik visualization bundle might just be a proof of concept? It seems to be so limited as to be useless?
I can't seem to show a long job title. There's no option for word wrap onto a new line, or to reduce font size, or increase node size, or really anything else. "Global head of X and Y" will never work with this visualization. Am I missing something, or is this just not really fit for purpose?
Hi Team,
We are encountering the following LSN error:
"LSN '<LSN number>' could not be found, neither in the transaction log nor in the backup log"
WARNING_GENERAL Task '<replicate task name>' encountered a recoverable error
ERROR_GENERAL "Stream component '<src name>' terminated
Stream component failed at subtask 0, component '<src name>'
Error executing source loop"
Since the LSN is lost and we cannot retrieve it, we have received two approaches from the Qlik team to fix this issue:
1. Reload the target.
2. Start from the minimum LSN using the following query:
SELECT MIN([Current LSN]) FROM fn_dblog(NULL, NULL);
However, we have concerns about potential data loss, especially with approach 2 (resuming from the minimum LSN). We want to know if there are any ways to fix this issue without running a full load (reloading the target) and without any data loss.
Note: Since we are using Microsoft SQL MI servers, we are unable to recover the lost LSN.
Could you please provide guidance on how to address this issue without data loss?
Thank you
N Vivek
Team,
I want to use Qlik Sense variables as column headers in an NPrinting Excel pivot table. But it' s not working properly.
Thank you.
Hi All,
I have create Qlik Geo operation connection and i am trying to use Dissolve operation.
My Source is excel file, I am trying to use dissolve in Geo operation connection, here i didn't see the tables.
Can you please suggest me how to map these excel file into geo operation connection.
If not possible to connect the excel file using geo operation connection, Please suggest me how to add data into geo operation connection in Qliksense cloud.
Thanks & Regards,
Lakshman
I'm trying to evaluate the usage of GeoAnalytics in our environment. There are several references to monitoring capabilities with Qlik Cloud deployments, but we're still on prem with Qlik Sense. Is there a way to capture these details?
We are currently running Multinode Qlik Sense Enterprise on Windows February 2024 Patch 16 on Windows 2016 servers & PostgreSQL 11.6.
Planning to upgrade to November 2024. Are there any significant information/requirements needs to be aware of?
I need to schedule a reload task with the following requirements:
To Summarize this, reloads for the app should be every 3 hrs. But these reloads should happen between 3pm current day and 6am next day. Pls note, the avg time to reload this app is 1 hr.
thanks in advance.
@sunny_talwar @Sonja_Bauernfeind
We are thrilled to announce that the new Qlik Learning is now live and ready for you!
Data Flow simplifies, democratizes, and accelerates the last mile of data preparation for analytics, machine learning, and AI.
From product innovation, to technical tips and tricks, to real world success stories, Qlik Connect offers learning opportunities for all levels.
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 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.
Nortera leads agricultural manufacturing analytics and automation with Qlik, reducing short-shipment rates and annual savings in water consumption.
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!