Skip to main content

Welcome to
Qlik Community!

cancel
Showing results for 
Search instead for 
Did you mean: 
  • 215,406 members
  • 3,712 online
  • 1,991,779 posts
  • 149,214 Solutions
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW

Welcome to Qlik Community

Recent Discussions

  • forum

    Qlik Application Automation

    Automation to receive selections from App and pass it to a report

    Good day Qlik community, I have an unusual requirement. I want my users to be able to click on a button on an app and call an automation sending their... Show More

    Good day Qlik community,

    I have an unusual requirement. I want my users to be able to click on a button on an app and call an automation sending their selections to the automation and applying the selections to the report. The first part is easy and it is working. I can pass and receive the selections in the automation.

    The part that I cannot get it right is the one to pass the selection to the report. For some strange limitation, if I apply a bookmark to my automation, the report totally ignores it. I have to explicitly pass each field selection to the report using the Add Selections to report.

    It does work if I create one of these blocks for each field but would require for me to know fields the user will select, which I don't. What I want is to loop through each field and apply the selection for that field.

    I am using the block "List Current Selections" to loop these fields. This seems to work. Inside that loop, I am trying to use the block Add Selectiction to Report". That one does not work. It forces me to pick a field by the index (0, 1, 2) instead of do what any loop does and get the index for the corresponding loop iteration.

    Ideas?

    These are some screenshots that might help:

    igoralcantara_1-1711725061434.png

    igoralcantara_2-1711725085340.png

     

    igoralcantara_3-1711725107227.png

     

    Show Less
  • forum

    New to Qlik Analytics

    Qlik sense license

    Hi Guys, I bought qlik sense license I received three lef one is special edition - Developmenet , Another is Special Edition - Test with different con... Show More

    Hi Guys,

    I bought qlik sense license I received three lef one is special edition - Developmenet , Another is Special Edition - Test with different control number how to use this and what is the use of this

    Show Less
  • forum

    QlikView App Dev

    tRESTClient

    Where can i download tRESTClient Jar to import?
  • forum

    Qlik Cloud Data Integration

    Post method in the tREST

    Hi Guys,I am trying to print the HTTP body in the tLogRow sending it through the tREST.How can I Print the REquest Body?
  • forum

    App Development

    Funnel Chart - Width vs Order Display

    Team, When working with Funnel chart, if option was order the values getting displayed properly in all parameters but in width option values not getti... Show More

    Team,

    When working with Funnel chart, if option was order the values getting displayed properly in all parameters but in width option values not getting displayed, but width Visualization was better for my requirement, any hint how to display the values. Highlighted the screen shot for reference.

    Farsana_0-1711721983336.png

     

    Thanks

    Farsana

    Show Less
  • forum

    New to Qlik Analytics

    Formation of a variable.

    I have a table in which there is a column called date, and based upon this column I want two variables one which shows all the previous data, when we ... Show More

    I have a table in which there is a column called date, and based upon this column I want two variables one which shows all the previous data, when we select a date and the other all the after data including the selected date data.

    I want all the data date wise, for example if we select today's date then all the data previous and all the data after it.

    Show Less
  • forum

    Connectivity & Data Prep

    Tasks failed as Error: Connection aborted (System error: The handle is invalid.)

    Hello experts, There are connectivity problems in our site, which occurs on TASK relods only as far as we experienced. Its both occurs on ODBC & Rest ... Show More

    Hello experts,

    There are connectivity problems in our site, which occurs on TASK relods only as far as we experienced. Its both occurs on ODBC & Rest connections.

    When i check script logs we get this error immidiately after "Lib Connect to xxx" statement.

    20240327T120257.655+0300 0023 LIB CONNECT TO 'SOME_ODBC_DB_Connection'
    20240327T120339.724+0300      Error: Connection aborted (System error: The handle is invalid.)
    20240327T120339.726+0300      Execution Failed
    20240327T120339.730+0300      Execution finished.

    the time from lib connect to statment and error differs from 30 to 150 seconds. 

    Btw <generatePublisherEvidence enabled="false"/> is set on all of our Qlik servers inside of <runtime> tag which is located on machine.config. We have to manually control the failed task list and manually send a re-start order to mitigate this, but its very exhausting effor to chase up a site with more than +2000 tasks. And this is still not a solution because sometimes its ends as a fail again, we always have to check if its finishes as success.

     

    Qlik Sense Version: Qlik Sense February 2023 Patch 6 | 14.113.9

    Show Less
  • forum

    App Development

    Jobs failing intermittently with General Script Error in Qliksense

    Hello,One job in Qliksense  failed with an error below:20210603T124122.213+0200 0015 LOAD *20210603T124122.213+0200 0016 SQL SELECT DISTINCT QVD_NAME ... Show More

    Hello,

    One job in Qliksense  failed with an error below:

    20210603T124122.213+0200 0015 LOAD *
    20210603T124122.213+0200 0016 SQL SELECT DISTINCT QVD_NAME FROM QVMANAGEMENT.QVMGT_QVD_MASTER_T
    20210603T124122.213+0200 0017 WHERE QVDID = ''
    20210603T124124.892+0200 General Script Error in statement handling
    20210603T124127.700+0200 Execution Failed
    20210603T124127.703+0200 Execution finished.

    It failed once on 03/06/2021 When triggered twice, it was a success. We have not done any recent changes in app script and anything in app schedule or app related changes.

    We've checked the environment, it was up and  RAM and CPU was not fully exhausted.

    We have found some errors regarding connector at the time of failure :

    CGenericConnection: Failed to send QVX_TERMINATE to process 9240 (reason 999); C:\Program Files\Common Files\Qlik\Custom Data\QvOdbcConnectorPackage\QvOdbcConnectorPackage.exe
    CGenericConnection: Skipping QVX_TERMINATE for process 9240 (reason 999); C:\Program Files\Common Files\Qlik\Custom Data\QvOdbcConnectorPackage\QvOdbcConnectorPackage.exe

    we are running on version 'September 2020' and no changes in app script since it is deployed. Running fine right now as well.

    Any suggestions ?

    Show Less
  • forum

    App Development

    Qlik Sense Data Architect & Qlik Sense System Administrator

    Hi all, Could you recommend me any articles or corses (now a qlikhelp), or sort of roadmap how to get these knowledge? just read and try everything on... Show More

    Hi all,

    Could you recommend me any articles or corses (now a qlikhelp), or sort of roadmap how to get these knowledge?

    just read and try everything on qmc?

    Show Less
  • forum

    Qlik Replicate

    AWS RDS for Postgres as source - supported versions

    Hi Qlik Community Replicating from a Postgres read replica is merely impossible on the currently supported versions. However, Postgres 16.1 does allow... Show More

    Hi Qlik Community

    Replicating from a Postgres read replica is merely impossible on the currently supported versions. However, Postgres 16.1 does allow read/write on read replicas which enables setting the wal level to 'logical' on the read replica. This is significant progress as Teams opt to use read replicas instead of replicating directly from the primary instance.

    That said, there's limitations like enabling 'Create DDL events' and 'WAL heartbeats'. We'd like to capture the DDL events, and also benefit from keep the slots alive. But these require a 'create statement being run, and Postgres 16.1 is also not supported. Currently we don't have a solution for reading from a Postgres read replica if we want to replicate changes - 'cause full load works but not viable for large databases.

    Can I ask if there's plans to include Postgres 16.1 on the supported source endpoints. If so, when? And if we'd be able to replicate from a read replica, plus benefit from 'Create DDL events' and 'WAL heartbeats'.

    Regards.

    Show Less
Leaderboard

Customer Story

Qlik Data Integration & Qlik Replicate story

Qlik enables a frictionless migration to AWS cloud by Empresas SB, a group of Chilean health and beauty retail companies employing 10,000 people with 600 points of sale.

Customer Story

Building a Collaborative Analytics Space

Qlik Luminary Stephanie Robinson of JBS USA, the US arm of the global food company employing 70,000 in the US, and over 270,000 people worldwide.

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!