Skip to main content

Welcome to
Qlik Community!

cancel
Showing results for 
Search instead for 
Did you mean: 
  • 221,829 members
  • 4,787 online
  • 2,002,211 posts
  • 150,142 Solutions

Welcome to Qlik Community

Recent Discussions

  • forum

    Qlik NPrinting

    Advanced Search or Evaluate value

    Hello I'm trying to create a filter in NprintingI'm selecting the desired field (MONTH_NUM)the value I want is the maximum one where scenario type is ... Show More

    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

    Show Less
  • forum

    Integration, Extension & APIs

    Tabular Reporting, Qlik in Excel

    @Andrew_Kruger 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 th... Show More

    @Andrew_Kruger

    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!

     

    Show Less
  • forum

    New to Qlik Analytics

    how to get the Period selected on a dimension field or the fiscal period based o...

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

    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 

     

    Show Less
  • forum

    Connectivity & Data Prep

    Native Qlik Databricks connector having Data truncate issue post upgrading to Ql...

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

    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

    Show Less
  • forum

    Installing and Upgrading

    Talend studio error message

    Talend studio throws below error daily - javax.net.ssl.SSLHandshakeException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBui... Show More

    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.

    Show Less
  • forum

    Qlik Replicate

    Patching missing data in Qlik Replicate

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

    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

    Show Less
  • forum

    Installing and Upgrading

    Talend Studio unresponsive. Takes 15-20 mins to open studio and also to open a s...

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

    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

    Show Less
  • forum

    New to Qlik Analytics

    Filtering Relevant Data

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

    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.

    medinis123_0-1717691515961.png

    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 🙂

     

     

    Show Less
  • forum

    New to Qlik Analytics

    Do reloads triggered by APIs outside Qlik fall under the limit of 50 reloads per...

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

    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.

    Show Less
  • forum

    Integration, Extension & APIs

    Do reloads triggered by APIs outside Qlik fall under the limit of 50 reloads per...

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

    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.

    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!