Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Welcome to
Qlik Community!

cancel
Showing results for 
Search instead for 
Did you mean: 
  • 254,179 members
  • 4,740 online
  • 2,035,964 posts
  • 153,315 Solutions
Announcements
Gartner® Magic Quadrant™: 15 YEARS A LEADER - GET THE REPORT

Welcome to Qlik Community

Recent Discussions

  • forum

    Qlik NPrinting

    CVE-2018-1285 log4net.dll NPrinting Feb2025 SR1

    Hallo zusammen.,die aktuelle NPrinting Version (Feb2025 SR1) benutzt eine alte log4net.dll (2.0.9.0) die von unserem Schwachstellenscanner  erkannt wi... Show More

    Hallo zusammen.,

    die aktuelle NPrinting Version (Feb2025 SR1) benutzt eine alte log4net.dll (2.0.9.0) die von unserem Schwachstellenscanner  erkannt wird. Ist es absehbar wann die benutzte Version auf einen neuen Stand gebracht werden soll?

     

    Danke Alex

    Show Less
  • forum

    Qlik Replicate

    Error: The certificate chain was issued by an authority that is not trusted - Ql...

    We are setting up a new Qlik Replicate for the 2019 Microsoft SQL server source hosted on AWS and here are the details below. I am getting the below e... Show More

    We are setting up a new Qlik Replicate for the 2019 Microsoft SQL server source hosted on AWS and here are the details below. I am getting the below error message. Seeking your expert suggestions to get this issue resolved.

    RDS Instance Details

    RDS Type : Microsoft SQL Server

    Version : 2019

    Settings Summary:

    • $type : MicrosoftazuresqlmscdcSettings
    • additionalConnectionProperties : useTrustServerCertificate=yes;
    • database : ccData
    • dbid : 100
    • mscdcCaptureDDLChanges : false
    • partitionIdsCatchup : false
    • server : sqlserver2019_test.us-east-1.rds.amazonaws.com
    • skipMscdcJobFitnessCheck : true
    • suspendTableWithComputedColumn : true
    • username : qlik_user
    • useWindowsAuthentication : false

    Error Message:

    • SYS-E-HTTPFAIL, Failed to connect.
    • SYS,GENERAL_EXCEPTION,Failed to connect,RetCode: SQL_ERROR SqlState: 08001 NativeError: -2146893019 Message: [Microsoft][ODBC Driver 18 for SQL Server]SSL Provider: The certificate chain was issued by an authority that is not trusted.
    Show Less
  • forum

    Archived Groups

    NO PUEDO DESCAGAR QLIK

    Es sencilla mi pregunta, simplemente no se me esta permitiendo descargar, no c en que link o en cual dirección deba hacerlo, ya rellene los forms para... Show More

    Es sencilla mi pregunta, simplemente no se me esta permitiendo descargar, no c en que link o en cual dirección deba hacerlo, ya rellene los forms para poder acceder a una demo, pero simplemente no me envían nada, y dentro de https://community.qlik.com/t5/Download-Qlik-Products/tkb-p/Downloads simplemente no me deja descargar la versión de desktop, alguien sabe si me estoy saltando algo?

    Show Less
  • forum

    Water Cooler

    Why Embedding AI-Powered Analytics into Your Application is a Game Changer

    Learn from Luciane Ellis, the Senior Product Marketing Manager at Qlik, about embedding AI-powered analytics to add value for your users and overcome ... Show More

    Learn from Luciane Ellis, the Senior Product Marketing Manager at Qlik, about embedding AI-powered analytics to add value for your users and overcome challenges. This guide covers how to choose the right integration, simplify development, scale with ease, and deliver real-time AI powered insights directly in your app.

    Read the Full Guide

    Show Less
  • forum

    Administering and Monitoring

    Login Pass using ADGroup

    Hi SME, Someone created the below rule to allow ADGroup to access an app, and I don't know what it's supposed to do.  So I have 3 questions and hope s... Show More

    Hi SME, 

    Someone created the below rule to allow ADGroup to access an app, and I don't know what it's supposed to do.  So I have 3 questions and hope someone here can help.

    1) ABC group has 10 users, does qlik automatically reserve 10 login passes even though no one has used it yet?

    2) DFG group has 15 users of which 5 exists in ABC, if Q1 holds true where qlik reserves 10 login passes, will qlik also hold 15 regardless what exists in ABC?

    3) 1 login pass has a predefined time of 60 minutes.  Let's say Jack login today and used up 10 minutes and closed out the browser.  A week later, he logged back in and used another 10 minutes, in this scenario, is Jack using only 1 login pass since he logged in twice and technically used 20 minutes out of the 60?  Does this mean 1 login pass = 60 minutes and for duration of 28 days?

     

    (((user.group=resource.@ADGroupLoginAccess and resource.stream.name like "*")
    or (user.group=resource.app.@ADGroupLoginAccess
    and (resource.approved="true"
    or (resource.owner.userId=user.userId and resource.approved="false" )
    or resource.published="true"
    )))

     

    Thank you in advance!

    Show Less
  • forum

    Talend Studio

    Talend Dataprep Run error- "dictionarySnapshot" is null

    Trying to run the existing preparation from the talend cloud from the studio. It ran successfully on the cloud but facing some issue when called from ... Show More

    Trying to run the existing preparation from the talend cloud from the studio. It ran successfully on the cloud but facing some issue when called from studio and below is the log.

    Starting job data_prep__steward at 15:12 16/06/2025.
    [statistics] connecting to socket on port 4000
    [statistics] connected
    [FATAL] 15:12:40 qps.data_prep__steward_0_1.data_prep__steward- tDataPrepRun_1 Cannot invoke "org.talend.dataquality.semantic.snapshot.DictionarySnapshot.getDQCategoryByName(String)" because "dictionarySnapshot" is null
    java.lang.NullPointerException: Cannot invoke "org.talend.dataquality.semantic.snapshot.DictionarySnapshot.getDQCategoryByName(String)" because "dictionarySnapshot" is null
    	at org.talend.dsel.functions.custom.IsOfTypeUtility.isSemanticType(IsOfTypeUtility.java:60) ~[daikon-ee-dsel-8.5.4.jar:?]
    	at org.talend.dsel.functions.custom.IsOfTypeUtility.evaluate(IsOfTypeUtility.java:28) ~[daikon-ee-dsel-8.5.4.jar:?]
    	at org.talend.dsel.functions.custom.IsInvalid.call(IsInvalid.java:28) ~[daikon-ee-dsel-8.5.4.jar:?]
    	at org.talend.maplang.el.interpreter.impl.function.ExprLangFunctions.call(ExprLangFunctions.java:45) ~[org.talend.maplang.el.interpreter-1.10.0.jar:?]
    	at org.talend.maplang.el.interpreter.impl.ExprEvalVisitorImpl.visitStandardFunction(ExprEvalVisitorImpl.java:363) ~[org.talend.maplang.el.interpreter-1.10.0.jar:?]
    	at org.talend.maplang.el.interpreter.impl.ExprEvalVisitorImpl.visitFunctionCall(ExprEvalVisitorImpl.java:351) ~[org.talend.maplang.el.interpreter-1.10.0.jar:?]
    	at org.talend.maplang.el.interpreter.impl.ExprEvalVisitorImpl.visitFunctionCall(ExprEvalVisitorImpl.java:41) ~[org.talend.maplang.el.interpreter-1.10.0.jar:?]
    	at org.talend.maplang.el.parser.model.ELNode.accept(ELNode.java:482) ~[org.talend.maplang.el.parser-1.10.0.jar:?]
    	at org.talend.maplang.el.interpreter.impl.ExprEvalVisitorImpl.visitChildren(ExprEvalVisitorImpl.java:500) ~[org.talend.maplang.el.interpreter-1.10.0.jar:?]
    	at org.talend.maplang.el.interpreter.impl.ExprEvalVisitorImpl.visitBlock(ExprEvalVisitorImpl.java:113) ~[org.talend.maplang.el.interpreter-1.10.0.jar:?]
    	at org.talend.maplang.el.interpreter.impl.ExprEvalVisitorImpl.visitBlock(ExprEvalVisitorImpl.java:41) ~[org.talend.maplang.el.interpreter-1.10.0.jar:?]
    	at org.talend.maplang.el.parser.model.ELNode.accept(ELNode.java:445) ~[org.talend.maplang.el.parser-1.10.0.jar:?]
    	at org.talend.maplang.el.interpreter.impl.ExprEvalVisitorImpl.visitChildren(ExprEvalVisitorImpl.java:500) ~[org.talend.maplang.el.interpreter-1.10.0.jar:?]
    	at org.talend.maplang.el.interpreter.impl.ExprEvalVisitorImpl.visitRoot(ExprEvalVisitorImpl.java:108) ~[org.talend.maplang.el.interpreter-1.10.0.jar:?]
    	at org.talend.maplang.el.interpreter.impl.ExprEvalVisitorImpl.visitRoot(ExprEvalVisitorImpl.java:41) ~[org.talend.maplang.el.interpreter-1.10.0.jar:?]
    	at org.talend.maplang.el.parser.model.ELNode.accept(ELNode.java:443) ~[org.talend.maplang.el.parser-1.10.0.jar:?]
    	at org.talend.maplang.el.interpreter.impl.ExprInterpreterImpl.evalAsExprValue(ExprInterpreterImpl.java:199) ~[org.talend.maplang.el.interpreter-1.10.0.jar:?]
    	at org.talend.maplang.el.interpreter.impl.ExprInterpreterImpl.evalAsBoolean(ExprInterpreterImpl.java:107) ~[org.talend.maplang.el.interpreter-1.10.0.jar:?]
    	at org.talend.components.processing.functions.AbstractBaseFunction.isRecordMatchingFilter(AbstractBaseFunction.java:233) ~[processing-functions-1.68.1.jar:?]
    	at org.talend.components.processing.functions.AbstractBaseFunction.applyOnRecord(AbstractBaseFunction.java:171) ~[processing-functions-1.68.1.jar:?]
    	at org.talend.components.processing.functions.AbstractBaseFunction.transform(AbstractBaseFunction.java:156) ~[processing-functions-1.68.1.jar:?]
    	at org.talend.components.processing.functions.technical.Composite.transform(Composite.java:53) ~[processing-functions-1.68.1.jar:?]
    	at org.talend.components.dataprep.preparation.Preparation.transform(Preparation.java:50) ~[dataprep-1.68.1.jar:?]
    	at org.talend.components.dataprep.processor.DataPrepProcessor.onElement(DataPrepProcessor.java:99) ~[dataprep-1.68.1.jar:?]
    	at jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:?]
    	at jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77) ~[?:?]
    	at jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:?]
    	at java.lang.reflect.Method.invoke(Method.java:568) ~[?:?]
    	at org.talend.sdk.component.runtime.base.LifecycleImpl.doInvoke(LifecycleImpl.java:87) ~[component-runtime-impl-1.79.0.jar:?]
    	at org.talend.sdk.component.runtime.output.ProcessorImpl.onNext(ProcessorImpl.java:303) ~[component-runtime-impl-1.79.0.jar:?]
    	at org.talend.sdk.component.runtime.di.AutoChunkProcessor.onElement(AutoChunkProcessor.java:38) ~[component-runtime-di-1.79.0.jar:?]
    	at qps.data_prep__steward_0_1.data_prep__steward.tFileInputDelimited_1Process(data_prep__steward.java:2821) [classes/:?]
    	at qps.data_prep__steward_0_1.data_prep__steward.runJobInTOS(data_prep__steward.java:3927) [classes/:?]
    	at qps.data_prep__steward_0_1.data_prep__steward.main(data_prep__steward.java:3565) [classes/:?]
    Exception in component tDataPrepRun_1 (data_prep__steward)
    java.lang.NullPointerException: Cannot invoke "org.talend.dataquality.semantic.snapshot.DictionarySnapshot.getDQCategoryByName(String)" because "dictionarySnapshot" is null
    	at org.talend.dsel.functions.custom.IsOfTypeUtility.isSemanticType(IsOfTypeUtility.java:60)
    	at org.talend.dsel.functions.custom.IsOfTypeUtility.evaluate(IsOfTypeUtility.java:28)
    	at org.talend.dsel.functions.custom.IsInvalid.call(IsInvalid.java:28)
    	at org.talend.maplang.el.interpreter.impl.function.ExprLangFunctions.call(ExprLangFunctions.java:45)
    	at org.talend.maplang.el.interpreter.impl.ExprEvalVisitorImpl.visitStandardFunction(ExprEvalVisitorImpl.java:363)
    	at org.talend.maplang.el.interpreter.impl.ExprEvalVisitorImpl.visitFunctionCall(ExprEvalVisitorImpl.java:351)
    	at org.talend.maplang.el.interpreter.impl.ExprEvalVisitorImpl.visitFunctionCall(ExprEvalVisitorImpl.java:41)
    	at org.talend.maplang.el.parser.model.ELNode.accept(ELNode.java:482)
    	at org.talend.maplang.el.interpreter.impl.ExprEvalVisitorImpl.visitChildren(ExprEvalVisitorImpl.java:500)
    	at org.talend.maplang.el.interpreter.impl.ExprEvalVisitorImpl.visitBlock(ExprEvalVisitorImpl.java:113)
    	at org.talend.maplang.el.interpreter.impl.ExprEvalVisitorImpl.visitBlock(ExprEvalVisitorImpl.java:41)
    	at org.talend.maplang.el.parser.model.ELNode.accept(ELNode.java:445)
    	at org.talend.maplang.el.interpreter.impl.ExprEvalVisitorImpl.visitChildren(ExprEvalVisitorImpl.java:500)
    	at org.talend.maplang.el.interpreter.impl.ExprEvalVisitorImpl.visitRoot(ExprEvalVisitorImpl.java:108)
    	at org.talend.maplang.el.interpreter.impl.ExprEvalVisitorImpl.visitRoot(ExprEvalVisitorImpl.java:41)
    	at org.talend.maplang.el.parser.model.ELNode.accept(ELNode.java:443)
    	at org.talend.maplang.el.interpreter.impl.ExprInterpreterImpl.evalAsExprValue(ExprInterpreterImpl.java:199)
    	at org.talend.maplang.el.interpreter.impl.ExprInterpreterImpl.evalAsBoolean(ExprInterpreterImpl.java:107)
    	at org.talend.components.processing.functions.AbstractBaseFunction.isRecordMatchingFilter(AbstractBaseFunction.java:233)
    	at org.talend.components.processing.functions.AbstractBaseFunction.applyOnRecord(AbstractBaseFunction.java:171)
    	at org.talend.components.processing.functions.AbstractBaseFunction.transform(AbstractBaseFunction.java:156)
    	at org.talend.components.processing.functions.technical.Composite.transform(Composite.java:53)
    	at org.talend.components.dataprep.preparation.Preparation.transform(Preparation.java:50)
    	at org.talend.components.dataprep.processor.DataPrepProcessor.onElement(DataPrepProcessor.java:99)
    	at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    	at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77)
    	at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    	at java.base/java.lang.reflect.Method.invoke(Method.java:568)
    	at org.talend.sdk.component.runtime.base.LifecycleImpl.doInvoke(LifecycleImpl.java:87)
    	at org.talend.sdk.component.runtime.output.ProcessorImpl.onNext(ProcessorImpl.java:303)
    	at org.talend.sdk.component.runtime.di.AutoChunkProcessor.onElement(AutoChunkProcessor.java:38)
    	at qps.data_prep__steward_0_1.data_prep__steward.tFileInputDelimited_1Process(data_prep__steward.java:2821)
    	at qps.data_prep__steward_0_1.data_prep__steward.runJobInTOS(data_prep__steward.java:3927)
    	at qps.data_prep__steward_0_1.data_prep__steward.main(data_prep__steward.java:3565)
    [statistics] disconnected
    
    Job data_prep__steward ended at 15:12 16/06/2025. [Exit code  = 1]

     

    Show Less
  • forum

    Qlik Automate

    Automation Image generator

    So what is my exact problem I have three chart image so in automation i have send that image not a pdf just an image in email by formatting if I add i... Show More

    So what is my exact problem I have three chart image so in automation i have send that image not a pdf just an image in email by formatting if I add images and give the html code it is not sending the mail with proper images because the height is a matter it is providing more spaces I have created to work on that is there any other way to send images in proper formatting in email i dont want to use any python automation. On the top left i have one image and in top right I have one image then the second row in center i have one image but the height between center and top iages is exceedin.Someone help me with this

     

    Show Less
  • forum

    Talend Studio

    Passing information from child Job to parent Job

    Hello everyone, I was wondering if there is another way, besides using tBufferOutput component, to pass information from a child Job to a parent Job.I... Show More

    Hello everyone,

     

    I was wondering if there is another way, besides using tBufferOutput component, to pass information from a child Job to a parent Job.

    I'm using context variables with the same name. And I read it somewhere, on some forum, that there is a way that does not involve the tBufferOutput component to pass the information from a child Job to its parent, when using context variables with the same name.

    I haven't found any documentation that supports this.

    Can someone please tell me if there's another way to pass the information without using the tBufferOutput component (I don't want to write the information into a table or a file either)?

    Thank you,

    Rui

    Show Less
  • forum

    Qlik Automate

    Get Data from a Pivot Table

    Hello, we have an app with a pivot table that contains monthly values across multiple years, so when the columns are expanded, we have a two-level hea... Show More

    Hello, we have an app with a pivot table that contains monthly values across multiple years, so when the columns are expanded, we have a two-level header. The top-level is the year and the bottom-level is the month. We'd like to use an Automation to extract data from this pivot table and put it into an Excel spreadsheet. Which block should we use to get data from a pivot table?

    Show Less
  • forum

    Visualization and Usability

    Make a calculation which is dependent on pivot table columns

     I need to create a column to the right that shows the change in historical values (both the difference and percentage change).I have tried to prepare... Show More

     

    I need to create a column to the right that shows the change in historical values (both the difference and percentage change).

    I have tried to prepare this in Excel and have provided a screenshot.

    I have attached both the data and the Qlik Sense pivot table.

     

    Data set

    Screenshot 2025-06-24 161420.png

    Qlik Sense Pivot table

    Screenshot 2025-06-24 161111.png

     

    Requirement

    Screenshot 2025-06-24 161806.png

    Show Less
Leaderboard

Customer Story

Optimizing Food Relief with Qlik

Qlik empowers Foodbank Victoria with real-time data insights, optimizing food acquisition and distribution to deliver 25 million meals annually while reducing waste and costs across its statewide relief efforts.

Customer Story

Data-Driven Strategies Set To Fuel Growth

Qlik accelerates decision-making at Alpha Auto Group, enabling seamless data integration and automation across dealerships, cutting reporting times, and driving scalable business growth.

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!