Skip to main content

Welcome to
Qlik Community!

cancel
Showing results for 
Search instead for 
Did you mean: 
  • 243,535 members
  • 4,446 online
  • 2,026,758 posts
  • 152,491 Solutions
Announcements
The New Qlik Learning Experience is Here! GET STARTED

Welcome to Qlik Community

Recent Discussions

  • forum

    Qlik Cloud Data Integration

    How to configure Progress OpenEdge data source with Qlik Cloud and QDG

    Hello, Has anyone managed to use the Progress OpenEdge data source with Qlik Data Gateway? I am getting error "Status(StatusCode="Internal", Detail="C... Show More

    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

     

     

     

     
    Show Less
  • forum

    Application Automation

    somma di aggregazione

    Salve,  ho una tabella che contiene delle righe con anno, mese, data movimento, ore effettive, ore teoriche mensili. Vorrei creare una formula che som... Show More

    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))
    Show Less
  • forum

    App Development

    What's the point of the org chart?

    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 see... Show More

    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?

    Show Less
  • forum

    Qlik Replicate

    LSN could not be found, neither in the transaction log nor in the backup log

    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"WAR... Show More

    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

     

     

    Show Less
  • forum

    Water Cooler

    Qlick Comunity Access Denied

    Goodmorning,I want to ask a question on the Qlick Community  New Question - Qlik CommunityOn Connectivity and Data Prep   Access Denied - Qlik Communi... Show More
    Goodmorning,
    I want to ask a question on the Qlick Community 
    New Question - Qlik Community
    On Connectivity and Data Prep
    Francesco_Turrini_0-1738335614579.png

     


    But when i press the link it gives me this error

    Francesco_Turrini_1-1738335635849.png



    Error:
    Trying to access the Support Case Portal? or Downloads page? Connect with an agent now via live chat (click help icon lower right of page)
    Product issue? Please post a question in one of our many product forums [https://community.qlik.com/t5/Forums/ct-p/Forums] or create a case with Qlik Support [https://community.qlik.com/t5/crmsupport/page]

    This board (Water Cooler) seems to be the only one where i can post a question.

    Thank you,
    FT
    Show Less
  • forum

    Application Automation

    I want to use the variable value as a pivot table column header

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

    Team, 

    I want to use Qlik Sense variables as column headers in an NPrinting Excel pivot table. But it' s not working properly.

    selvakumara_0-1739823822843.pngselvakumara_1-1739823862859.png

    Thank you.

     

     

    Show Less
  • forum

    App Development

    How to use Geo Operations connection Dissolve operation in Qliksense

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

    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

    Show Less
  • forum

    GeoAnalytics

    How to track usage without Qlik Cloud

    I'm trying to evaluate the usage of GeoAnalytics in our environment. There are several references to monitoring capabilities with Qlik Cloud deploymen... Show More

    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?

    Show Less
  • forum

    Deployment & Management

    Any critical path Upgrading Qlik Sense from Feb 2024 Patch 16 to November 2024

    We are currently running Multinode Qlik Sense Enterprise on Windows February 2024 Patch 16 on Windows 2016 servers & PostgreSQL 11.6. Planning to upgr... Show More

    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?

     

    Show Less
  • forum

    Deployment & Management

    Schedule app reload based on specific condition in QMC

    I need to schedule a reload task with the following requirements: Start time: 3 PM daily Run frequency: Every 3 hours End time: 6 AM daily To Summar... Show More

    I need to schedule a reload task with the following requirements:

    • Start time: 3 PM daily
    • Run frequency: Every 3 hours
    • End time: 6 AM daily

    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 

    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!