Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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:
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
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.
Thanks
Farsana
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.
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
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 ?
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?
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.
Elevate your career with Connect. 15 Hands-on workshops and certifications for Data and Analytics.
Browse our helpful how-to's to learn more about navigating Qlik Community and updating your profile.
Your journey awaits! Join us by Logging in and let the adventure begin.
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.
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.
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!