Skip to main content

Welcome to
Qlik Community!

cancel
Showing results for 
Search instead for 
Did you mean: 
  • 215,305 members
  • 5,424 online
  • 1,991,626 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

    QlikView App Dev

    Force 0 on Continuous line chart when expression is Avg( )

    Hi all, I have a line chart over a continuous x-axis that I want to drop to zero when no data exists for that time value.If my query is a SUM, then th... Show More

    Hi all,

    I have a line chart over a continuous x-axis that I want to drop to zero when no data exists for that time value.

    If my query is a SUM, then this is fine by using  + SUM({1}0) 

    My problem is that for this chart I am using an AVG function.

    I've tried +AVG({1}0) but this didn't work. 

    Has anyone found a solution to this problem before?

     

    Show Less
  • forum

    Qlik Replicate

    Connection Dataproc

    Bonjour,  Je n'arrive pas a me connecté au cluster Dataproc depuis Qlik replicate.  Erreur veut dire que l'adresse host et le numéro du port  pour se... Show More

    Bonjour, 

    Je n'arrive pas a me connecté au cluster Dataproc depuis Qlik replicate. 

    ELHARRAS_0-1711467658369.png

    Erreur veut dire que l'adresse host et le numéro du port  pour se connecter à Hive qui bloque par contre la config pour le cloud Storage est OK . 

    Cordialement.

    Cordialement. 

    Show Less
  • forum

    App Development

    How to use a value in the resultant row to calculate the value in the next row i...

    Hello, I am trying to create a table in Qlik Sense which is similar to the one below. But I am unable to do it because I cannot pick previous value fr... Show More

    Hello,

    I am trying to create a table in Qlik Sense which is similar to the one below. But I am unable to do it because I cannot pick previous value from the resultant row and use it to calulate the next value in the same column.

    Table:

    Apoorva_sd_1-1711592844033.png

     

     

    In the above table, Availability is what I am trying to calculate. Formula for that would be "Column A-Column B" for priority 1 which will be 30 hours here for project 1. Then for priority 2, Result will be 30-3=27 i.e., Total Reult hours minus the hours required for 1st priority project. Then for the 3rd priority it will be 27-1=26 and so on. Question is how to use the value from resultant (Result) column to calculate the value for next row in the same column. Is there a function for this? 

    Thank you,

    Apoorva.

                 

     

    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

    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

     

    Its a very common scenario, but I have spend more than a day with it finding the root cause.

    Version used

    nidhin_san_0-1711625388092.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
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!