Skip to main content

Welcome to
Qlik Community!

cancel
Showing results for 
Search instead for 
Did you mean: 
  • 215,305 members
  • 5,620 online
  • 1,991,622 posts
  • 149,201 Solutions
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW

Welcome to Qlik Community

Recent Discussions

  • forum

    Design and Development

    Issue upserting with parent record tSalesforceOutputBulkExec

    Hello Everyone, I have a requirement to upsert a list of contacts with an external id (LP_ExternalContactId__c) and also need to relate to the account... Show More

    Hello Everyone,

    I have a requirement to upsert a list of contacts with an external id (LP_ExternalContactId__c) and also need to relate to the account with another external id (LP_ExternalClientId__c). I am using tSalesforceOutputBulkExec (Bulk API V1) for this as I have to do a retry mechanism on failure. So the first try is in Parallel concurrency mode with a bigger batch size and the retry in serial mode with a smaller batch size. Now that the reject file populated is having the parent external id value as blank. For this reason, my retry job loads all the contacts without the account ids for the ones that are failing where account is not present. It populates the parent external id value in the reject file if I enable Bulk API V2, but I cannot use V2 as it doesn't allow us to select the concurrency mode and batch size. Below are some of the screenshots. Any help would be appreciated.

    nidhin_san_0-1711624764417.png

    nidhin_san_4-1711624907882.png

     

    nidhin_san_5-1711624928880.png

     

     

    Show Less
  • forum

    Water Cooler

    How to Use Filtered Pane in Storytelling

    HI, I'm facing an issue where I can't find the snapshot option when selecting the filter pane visualization, unlike other visuals where it's readily a... Show More

    HI,

    I'm facing an issue where I can't find the snapshot option when selecting the filter pane visualization, unlike other visuals where it's readily available. Additionally, I require live data in the storytelling sheet and the ability to utilize filtered pane visuals within it.

    Show Less
  • forum

    App Development

    NL Insights issue. Unable to see the properties panel

    Hello Community,we are currently using qlik sense enterprise on windows May 2023 patch 10.  when we tried to test the new extension "NL insights" in t... Show More

    Hello Community,

    we are currently using qlik sense enterprise on windows May 2023 patch 10.  when we tried to test the new extension "NL insights" in the sheets, the properties panel didn't show any contents under the "data" section to add measures and dimensions. Also weirdly, it asking for credentials for authentication. pls help us to fix this.

    Note: we are using Saml SSO for the user authentication.

    Nikhilreddy_1-1711087646406.png

     

     

    Nikhilreddy_0-1711087578929.png

     

    Show Less
  • forum

    New to Qlik Analytics

    Qlik Sense Server Error (Refused To connect)

    Whenever my laptop updates , Qlik Sense gives the following error :- Refused to Connect.How to solve the Problem? Kindly give the steps in detailed ma... Show More

    Whenever my laptop updates , Qlik Sense gives the following error :- Refused to Connect.
    How to solve the Problem?

    Kindly give the steps in detailed manner

    Show Less
  • forum

    New to Qlik Analytics

    load data from PDF File

    hey ! Is it possible to load a PDF file containing text and a data table into a Qlik Sense app and work with the data in the app? If so, how can I do ... Show More

    hey !

    Is it possible to load a PDF file containing text and a data table into a Qlik Sense app and work with the data in the app? If so, how can I do it?

    Additional details:

    I want to be able to load the PDF file each time I use the app.
    The PDF file contains both text and a data table.
    I want to be able to work with the data in the app, such as creating visualizations and performing calculations.

    Please provide any relevant documentation or tutorials that I can use to learn more about this process.

    Thank you in advance for your help!

    Show Less
  • forum

    New to Qlik Analytics

    Dividing accumulating expressions

    Hi, I am trying to do the Num and den and accumulative, like Num = 400 and Den = 455 for 2022 Jan , its percentage is 87.9 and it is accumulating feb ... Show More

    Hi, I am trying to do the Num and den and accumulative, like Num = 400 and Den = 455 for 2022 Jan , its percentage is 87.9 and it is accumulating feb 88.9 and it is accumulating to  176% intead of feb 88.9 and march 89

    This is my expression.

    =rangesum(above(Count({<[NUMERATOR]={'1'},[QUESTION]={'Q9'}>} distinct [RESPONSEID]),0,RowNo(total)))/rangesum(above(Count({<[DENOMINATOR]={'1'},[QUESTION]={'Q9'}>} distinct [RESPONSEID]),0,RowNo(total)))

    Show Less
  • forum

    App Development

    $() Expansion is ignoring the dimension filters in a chart table

    Hello Qlik lovers, I have an interesting case that I came across and I hope you can help me solve it. For this case, I am trying to filter against a n... Show More

    Hello Qlik lovers, I have an interesting case that I came across and I hope you can help me solve it.

    For this case, I am trying to filter against a numeric field [KPI_Code]

    I created a Table and inserted [KPI_Code] as a Dimension.

    I have 2 expressions, the results are in the table below

    Expression A: Max(KPI_Code)

    Expression B: Aggr(Only({<KPI_Code={"$(=Max(KPI_Code))"}>}KPI_Code),KPI_Code)

    when I use a dollar sign expansion, it always gives me the maximum number in the dataset, disregarding the dimension value.

    How can I use $() and still get values just like in Expression A ???

    ------------

    Note: I need to use the $() because I need the output value inside a variable to call its expression

    Example: vKPI_$()_Expression

    if the $() resulted in 1001 then the variable would become  vKPI_1001_Expression and I would use it's saved expression output in the cell beside its corresponding KPI_Code

     

    KPI_Code Expression A Expression B
      1004 1004
    1001 1001 -
    1002 1002 -
    1003 1003 -
    1004 1004 1004
    Show Less
  • forum

    Qlik Application Automation

    load data from PDF File

    Is it possible to load a PDF file containing text and a data table into a Qlik Sense app and work with the data in the app? If so, how can I do it? Ad... Show More

    Is it possible to load a PDF file containing text and a data table into a Qlik Sense app and work with the data in the app? If so, how can I do it?

    Additional details:

    I want to be able to load the PDF file each time I use the app.
    The PDF file contains both text and a data table.
    I want to be able to work with the data in the app, such as creating visualizations and performing calculations.

    Please provide any relevant documentation or tutorials that I can use to learn more about this process.

    Thank you in advance for your help!

    Show Less
  • forum

    Qlik NPrinting

    Incorrect Kpi Value In Nprinting

    Hi, I have created one KPi where it has some value and its changing based on that selections applied. Now in qlik sense if we apply the cycle for the ... Show More

    Hi,

    I have created one KPi where it has some value and its changing based on that selections applied.

    Now in qlik sense if we apply the cycle for the same filed selections then the value is showing wrong or showing value and so on.

    For example if value is showing as 2 in Qlik sense kpi, then the same kpi is showing as 2.13333333333333 in Nprinting pixel perfect report generated.

    any suggestions would be appreciated. 

     

     

    Raju_6952_1-1711623882494.png

     

     

     

    Show Less
  • forum

    Installing and Upgrading

    Talend Open Studio 8.0.1 Error Opening a job

    I get the following error message when I try to open an existing job:An error has occurred. See error log for more details.JsonIoException setting fie... Show More

    I get the following error message when I try to open an existing job:

    An error has occurred. See error log for more details.

    JsonIoException setting field 'flags' on target: Property: null with value: {}

    I didn't make any migration and I've this exact same error message while opening a job.

    I specify that I work on a project that I did not develop myself.

    But the thing is : this job was opening really well last week and nothing has changed in the meantime.

    I'm completely stuck right now 👾

    Environment :

    TOS 8.0.1

    JDK 17

    Thank you by advance

    CTouu

    Show Less
Leaderboard

Customer Story

Qlik Data Integration & Qlik Replicate story

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.

Customer Story

Building a Collaborative Analytics Space

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.

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!