Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Bonjour,
je viens de migrer mon compte de Talend Cloud vers Qlik et maintenant quand je me connecte à Talend Cloud, j'ai ce message d'erreur :
Quand je me connecte sur Qlik Cloud, je n'ai plus aucun job, tasks, ...
Comment retrouver la console Talend avec tous mes projets ?
Merci
Dear Qlik enthusiasts,
I have installed Qlik Sense Desktop to the D:/ of my Laptop and I followed every step correctly like:
- Created the trial folder under the Qlik>Sense folder and pasted the Unlock file.
But, the App still gets stuck at the Authentication Link window and shows me only a Back button.
I've tried installing different versions of the Application since last 2 days.
I've attached the screenshots for reference.
Please help me access the Qlik Sense Application somehow.
Hi QLik Experts,
We have one app which is having 20gb size and app is not able to load in our qliksense hub.we are using 2023 august version.what i need to do to make the app open?Their is no chance to decrease the size of the app.
Hi Qlik Support,
Is there a recommendation on how to patch missing data in Qlik Replicate?
We have a scenario where data is missing from the target for a particular time frame (e.g. 6th June 10:35AM - 11:00AM). This is because when restarting the task from a timestamp, the incorrect timestamp was used, which in turn caused source data to be skipped.
Is it possible to only replay the changes in a specified time frame? And if so, is there a best practice method or considerations that need to be taken into account when doing so?
Apologies if this idea has already been addressed in a previous community post.
Thanks,
Nak
Hi,
I can set up a REST connector in Qlik cloud to load users from https://your-tenant.us.qlikcloud.com/api/v1/users.
However the default the lines is only 20. So I can only load 20 users.
Could anyone let me know how to set up the pagination or modify limit so that I can load full user list?
Thank you very much!
Fei
Tabular Reporting recipients can be re-used in Qlik Cloud using a standard QVD approach with a twist.
This can be helpful if you would like to define a single 'master set' of all recipients and then selectively use some or all of them in different reporting applications.
Some examples:
While QVDs are often used to reload portions of the same data into multiple apps, QVDs also store 'tags' which turns out to be exactly how Qlik Apps reference recipients, filters, and groups.
Lets take a look:
With Qlik Cloud tabular reporting, recipients, groups, and assigned filters can be loaded from any supported data source.
TAGs are used to keep track of which field in the data model represents the recipient, their email address, and optionally, their assigned filter and group.
A minimal sample script could look like this:
The sample script loads a list of recipients, emails, filters and groups as a single table, and then it tags the fields accordingly with predefined tags.
Loading this script 'as is' is enough to create the recipient store in the Qlik app as follows:
as well as the group definitions:
If we decide to store the Recipients table to QVD, as long as the STORE command is issued after the 'tag field' commands as shown below...
it results in a reusable recipient QVD file as follow
that when loaded into a new reporting app...
...will recreate all the recipients, groups, and filters in the new app with NO need to re-tag the recipient, filter, or group tags.
Why is this important? Well first you don't need to retag recipients in multiple places, but second you can unlock the reusability of the recipient file by:
1. Loading a subset of recipients for different reporting apps
2. Assign different filters to the same recipients for different reporting apps
3. Assign different groups to the same recipients for different reporting apps
In this example, a subset of recipients (3 of 6) are loaded into a reporting application by using a JOIN. Use the Email recipient field for the JOIN as it is likely the unique identifier. Note that any LOAD syntax can be applied to load only select recipients (such as KEEP, WHERE etc..)
In addition, this ample also makes new filter assignments and creates and assigns different groups specific to this application.
I hope this helps as a building block to devising a reusable recipient list .
Hi everyone, I am trying to install qlik replicate in docker using ubi8 base image
Can anyone tell me the latest rpm i can use for this?
Thx
I have a job that connects to extract the data from several objects from salesforce.
I use tsalesforceinput to extract the data and then insert into a mssql db. the job return this error with some objects but others work without problem.
tSalesforceInput_2 SSL peer shut down incorrectly
javax.net.ssl.SSLException: SSL peer shut down incorrectly
at sun.security.ssl.InputRecord.readV3Record(InputRecord.java:596) ~[?:1.8.0_252]
at sun.security.ssl.InputRecord.read(InputRecord.java:532) ~[?:1.8.0_252]
at sun.security.ssl.SSLSocketImpl.readRecord(SSLSocketImpl.java:990) ~[?:1.8.0_252]
at sun.security.ssl.SSLSocketImpl.readDataRecord(SSLSocketImpl.java:948) ~[?:1.8.0_252]
at sun.security.ssl.AppInputStream.read(AppInputStream.java:105) ~[?:1.8.0_252]
at java.io.BufferedInputStream.fill(BufferedInputStream.java:246) ~[?:1.8.0_252]
at java.io.BufferedInputStream.read1(BufferedInputStream.java:286) ~[?:1.8.0_252]
at java.io.BufferedInputStream.read(BufferedInputStream.java:345) ~[?:1.8.0_252]
at sun.net.www.http.ChunkedInputStream.fastRead(ChunkedInputStream.java:244) ~[?:1.8.0_252]
at sun.net.www.http.ChunkedInputStream.read(ChunkedInputStream.java:689) ~[?:1.8.0_252]
at java.io.FilterInputStream.read(FilterInputStream.java:133) ~[?:1.8.0_252]
at sun.net.www.protocol.http.HttpURLConnection$HttpInputStream.read(HttpURLConnection.java:3454) ~[?:1.8.0_252]
at java.util.zip.InflaterInputStream.fill(InflaterInputStream.java:238) ~[?:1.8.0_252]
at java.util.zip.InflaterInputStream.read(InflaterInputStream.java:158) ~[?:1.8.0_252]
at java.util.zip.GZIPInputStream.read(GZIPInputStream.java:117) ~[?:1.8.0_252]
at sun.nio.cs.StreamDecoder.readBytes(StreamDecoder.java:284) ~[?:1.8.0_252]
at sun.nio.cs.StreamDecoder.implRead(StreamDecoder.java:326) ~[?:1.8.0_252]
at sun.nio.cs.StreamDecoder.read(StreamDecoder.java:178) ~[?:1.8.0_252]
at java.io.InputStreamReader.read(InputStreamReader.java:184) ~[?:1.8.0_252]
at java.io.BufferedReader.fill(BufferedReader.java:161) ~[?:1.8.0_252]
at java.io.BufferedReader.read1(BufferedReader.java:212) ~[?:1.8.0_252]
at java.io.BufferedReader.read(BufferedReader.java:286) ~[?:1.8.0_252]
at com.csvreader.CsvReader.checkDataLength(Unknown Source) ~[javacsv-2.0.jar:?]
at com.csvreader.CsvReader.readRecord(Unknown Source) ~[javacsv-2.0.jar:?]
at org.talend.components.salesforce.runtime.BulkResultSet.next(BulkResultSet.java:21) ~[components-salesforce-runtime-0.36.13.jar:?]
at org.talend.components.salesforce.runtime.SalesforceBulkQueryInputReader.advance(SalesforceBulkQueryInputReader.java:72) ~[components-salesforce-runtime-0.36.13.jar:?]
at org.talend.codegen.flowvariables.runtime.FlowVariablesReader.advance(FlowVariablesReader.java:78) ~[talend-codegen-utils.jar:?]
Any suggestion?
Hi All,
I need to urgently unbuild Qlik Enterprise app for python code consumption for further conversion. However, I see qlik app unbuild only for SaaS that is currently available.
Please suggest if there is any alternate solution so that I can unbuild Qlik apps from Qlik Enterprise version?
Hi,
I need to count distinct rows where aggr Sum is equal or bigger than 10.
I tried use aggr() function in the sheet measures but it doesn't work, so I created 2 flag fields:
* flagA - 1 if total sum by month & ID >= 10
* flagB - 1 if total sum by month & ID & type >= 10.
Now, my problem is to make a distinct count on several fields.
example:
Month | ID | Type | Sum | flagA | flagB |
1 | 00001 | a | 5 | 0 | 0 |
2 | 00002 | a | 9 | 1 | 1 |
2 | 00002 | a | 3 | 1 | 1 |
2 | 00002 | b | 4 | 1 | 0 |
2 | 00002 | b | 5 | 1 | 0 |
2 | 00003 | a | 11 | 1 | 1 |
2 | 00003 | b | 11 | 1 | 1 |
3 | 00002 | a | 10 | 1 | 1 |
3 | 00003 | a | 9 | 0 | 0 |
count ID where monthly sum is equal and bigger than 10:
00002, month = 2, sum = 21
00003, month = 2, sum = 22
00002, month = 3, sum = 10
So, the measure should be the count of flagA where flagA=1 and distinct Month&ID, so 3.
count ID where monthly sum by type is equal and bigger than 10:
00002, month = 2, type = a, sum = 12
00003, month = 2, type = a, sum = 11
00003, month = 2, type = b, sum = 11
00002, month = 3, type = a, sum = 10
So, the measure should be the count of flagB where flagB=1 and distinct Month&ID&type,
so when selecting type = a, the result is 3, and when selecting type = b, the result is 1.
Love for some help.
Thanks!
Wondering about Qlik Talend Data Integration Sessions? There are 11, in addition to all of the Data & Analytics. So meet us in Orlando, June 3 -5.
Help us improve your Qlik experience by participating in our customer survey! The survey will be live from May 27 - June 14.
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 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!