Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello I'm trying to create a filter in Nprinting
I'm selecting the desired field (MONTH_NUM)
the value I want is the maximum one where scenario type is ACTUAL
the expression to get this value is
max({<SCENARIO_TYPE={actual},LAST_FISC_MONTH={1}>}MONTH_NUM)
in the filter setup I chose the field MONTH_NUM
in the advanced search I put
=MONTH_NUM = max({<SCENARIO_TYPE={actual},LAST_FISC_MONTH={1}>}MONTH_NUM)
however when the preview the result in Nprinting designer the data returned is not filtered as month num = 202405
while 202405 is returned by the above expression
I also tried evaluate value option and put the expression above and still the result is not reflected
kindly advise
I can see all the objects in Excel but only some of them have names, the rest have what appears to be their objectids. I cannot look them up by their names in the search either. I don't think its if it is/isnt Master Item or if it is/isnt Vizlib object. Do you know limitations or otherwise why this would occur?
Thanks!
I have to calculate the projection of a measure for the entire fiscal year.
Typically the formula is:
=Revenew_fiscal_year_2024 / 8 * 12
while 12 can be a constant as the 12th month of the fiscal year
the current fiscal period (8) changes depending on the day of the month.
is there any way to deduct the fiscal period knowing the current date?
thanks
Hi All,
We have upgraded our Qlik Sense Enterprise on Windows to August 2023 Patch 14 from Patch 5 in accordance with the recommendation given here https://community.qlik.com/t5/Support-Updates/Qlik-Sense-Enterprise-for-Windows-New-Security-Patches-Available/ba-p/2452521/page/3#comments.
However, post patching we have observed that one of the descriptive field value is getting truncated to 255 character only for a preexisting data connection created using native Qlik Databricks connector (QvODBCConnectorPackage). We do not have this issue when the Data connection is set up using ODBC DSN method (creating a DSN on server using Simba Spark ODBC driver and subsequently creating an ODBC connection in Qlik by selecting the System DSN). Please advise.
Best Regards
Talend studio throws below error daily -
javax.net.ssl.SSLHandshakeException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target.
Once we import the below 3 certificates manually to the keystore the issue is resolved and the studio opens up.
- us.cloud.talend.com
- https://repo1.maven.org/maven2/
- https://talend-update.talend.com/nexus/content/groups/studio-libraries/
But we are having to do this import of certificates to the keystore everyday when we try to open the studio.
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
I see the below error in the logs -
!ENTRY org.talend.platform.logging 4 0 2024-06-05 12:42:56.928 !MESSAGE 2024-06-05 12:42:56,928 ERROR org.talend.commons.exception.CommonExceptionHandler - java.util.concurrent.TimeoutException: Timeout when waiting for component server initialization: -Dtalend.studio.sdk.startup.timeout=2
!STACK 0
java.lang.IllegalStateException: java.util.concurrent.TimeoutException: Timeout when waiting for component server initialization: -Dtalend.studio.sdk.startup.timeout=2
at org.talend.sdk.component.studio.ProcessManager.waitForServer(ProcessManager.java:166)
at org.talend.sdk.component.studio.ServerManager.lambda$1(ServerManager.java:134)
at org.talend.sdk.component.studio.websocket.WebSocketClient.getOrCreateSession(WebSocketClient.java:168)
at org.talend.sdk.component.studio.websocket.WebSocketClient.sendAndWait(WebSocketClient.java:138)
at org.talend.sdk.component.studio.websocket.WebSocketClient.access$0(WebSocketClient.java:137)
at org.talend.sdk.component.studio.websocket.WebSocketClient$V1Component.getIndex(WebSocketClient.java:345)
at org.talend.sdk.component.studio.websocket.WebSocketClient$V1Component.details(WebSocketClient.java:370)
at org.talend.sdk.component.studio.TaCoKitGenericProvider.loadComponentsFromExtensionPoint(TaCoKitGenericProvider.java:70)
at org.talend.designer.core.model.process.GenericProcessProvider.loadComponentsFromProviders(GenericProcessProvider.java:77)
at org.talend.designer.codegen.components.model.ComponentsFactory.loadComponentsFromExtensions(ComponentsFactory.java:318)
at org.talend.designer.codegen.components.model.ComponentsFactory.init(ComponentsFactory.java:168)
at org.talend.designer.codegen.components.model.ComponentsFactory.waitForInit(ComponentsFactory.java:719)
at org.talend.designer.codegen.components.model.ComponentsFactory.getComponents(ComponentsFactory.java:636)
at org.talend.designer.codegen.components.model.ComponentsFactory.readComponents(ComponentsFactory.java:647)
at org.talend.designer.codegen.model.CodeGeneratorEmittersPoolFactory$JobRunnable.doRun(CodeGeneratorEmittersPoolFactory.java:165)
at org.talend.designer.codegen.model.CodeGeneratorEmittersPoolFactory$JobRunnable.run(CodeGeneratorEmittersPoolFactory.java:131)
Caused by: java.util.concurrent.TimeoutException: Timeout when waiting for component server initialization: -Dtalend.studio.sdk.startup.timeout=2
at org.talend.sdk.component.studio.ProcessManager.waitForServer(ProcessManager.java:167)
... 15 more
!ENTRY org.talend.platform.logging 1 0 2024-06-05 12:42:57.007 !MESSAGE 2024-06-05 12:42:57,007 INFO org.talend.designer.codegen.components.model.ComponentsFactory - 679 components loaded in 478996 ms
Dear all,
I’m quite new to QlikSense and I’m encountering some issues.
In short, I have multiple datasets loaded into the dashboard. Dataset1 contains project information, names, funding, etc., and Dataset2 contains specific deliverables that are mapped in the dashboard. The datasets are synced using a deliverable number that is common in both files.
The problem is there are more projects in Database1 than there are projects with deliverables in Dataset2 that are relevant to be shown in the dashboard. In all charts and tables in the sheet, I only need information from Dataset2 filled with info from Dataset1.
For example, to show only relevant projects and their funding per beneficiary, I added an ‘x’ column with values of 1 to the second dataset. In charts and tables, I use set modifiers {<x = {1}>} to prevent them from being displayed, etc. However, these can be displayed when selected (see figure).
There must be a solution for this, but I can’t find it, and working this way will only create more problems.
Could you please suggest how I can filter only relevant information from the first dataset as a master filter or while loading the data?
Thank you very much in advance 🙂
In the qlik business documentation its written there is a Maximum number of scheduled reloads per app per day of 50.
my question is: I'm on the trial now and currently reload my app every 10 seconds via a scheduled POST request in Newman. its working perfectly, can i assume if i buy the license it will continue working? im confused by the 50 reloads limit per day written on the website.
In the qlik business documentation its written there is a Maximum number of scheduled reloads per app per day of 50.
my question is: I'm on the trial now and currently reload my app every 10 seconds via a scheduled POST request in Newman. its working perfectly, can i assume if i buy the license it will continue working? im confused by the 50 reloads limit per day written on the website.
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!