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: 
  • 255,927 members
  • 3,908 online
  • 2,037,243 posts
  • 153,394 Solutions
Announcements
Solving the Informatica Dilemma: On-Demand Briefing - Watch On Demand!

Welcome to Qlik Community

Recent Discussions

  • forum

    Administering and Monitoring

    Session access cause 'General script error'

    Hello Everyone, Hope you all are having a great summer and doing fine . I have a weird case that I 'm trying to solve : I got 2 applications (Qliksens... Show More

    Hello Everyone, 

    Hope you all are having a great summer and doing fine . 

    I have a weird case that I 'm trying to solve : 

    I got 2 applications (Qliksense) , let's say A & B. I did session access (the simpliest way possible) on application A, and it works fine . For any reason , session access (same session access script as Application A) on application B doesn't work ! 

    I got a general script error at the end of the Loading script of B's application . Without the session access script , application B loading is working fine . 

    Can you help me ! feel free to ask any question . 

    Show Less
  • forum

    Qlik Replicate

    The following source column(s) contain data that exceed(s) the size limit of the...

    Hi everyone, I´m facing a new issue with QLIK Replicate because the Task does not replicate the column size from the source to the target table correc... Show More

    Hi everyone,

     

    I´m facing a new issue with QLIK Replicate because the Task does not replicate the column size from the source to the target table correctly. 

    Leandro_Medeiros_0-1752597797306.png

     

    ERROR in the attrep_apply_exceptions:

    The following source column(s) contain data that exceed(s) the size limit of the corresponding target column:
    source column "TRMC80" is 32 bytes while target column "TRMC80" is 8 bytes;
    source column "MOTY80" is 16 bytes while target column "MOTY80" is 4 bytes;
    source column "HDID80" is 48 bytes while target column "HDID80" is 12 bytes;

     

    Endpoints types in use:

    Souce: IBM DB2 for LUW

    Target: Microsoft SQL Server 2022 (160 Compatibility)  

     

    Any help will be very appreciated.

     

    Thank you !!

     

    Best Rgds,

    Leandro Medeiros

     

    Show Less
  • forum

    Qlik Replicate

    Full load alternative

    We have a table that is over 1.5 million rows. This table is replicating from MYSQL to Snowflake via a CDC task. We have to increase the LOB limit bec... Show More

    We have a table that is over 1.5 million rows. This table is replicating from MYSQL to Snowflake via a CDC task. We have to increase the LOB limit because the json values are being truncated. What are some alternatives to repopulating the historical data without having to do a full reload. 

    Show Less
  • forum

    Visualization and Usability

    Complex pivot table configuration issues

    Hi,I post about this topic a while ago and some tried to help me.I'm posting again because there is an update with more context on the issue.This is m... Show More

    Hi,

    I post about this topic a while ago and some tried to help me.
    I'm posting again because there is an update with more context on the issue.
    This is my previous post.

    As in the previous post,
    I need to display Actual Vs. Budget for 3 sales measures - Number of Transactions, Items Sold and Sales Amount.
    It works partially as suggested in the previous post. The problem is that I'm not getting total rows.

    There are two additions:
    * I need to display the data broken down by month (actual vs. budget for every month) and add o total columns for the selected period. The problem again is displaying the totals.
    * I need to add a row for the GeneralCost under the totals, and add an additional total row to show the Profit (TotalSalesAmount - GeneralCost).

    I attached an image (with a partial example) showing the output I'm trying to achieve.

    I'd appreciate your help with building the pivot table.

    Show Less
  • forum

    Management & Governance

    How to Upgrade Qlik Sense from Nov 2024 to May 2025

    HI team,I have Qlik Sense server on which Nov 2024 Qlik sense is running. PosgresDB is unbundled and available at D:\program files\PostgresSQL\14.Vers... Show More

    HI team,

    I have Qlik Sense server on which Nov 2024 Qlik sense is running. PosgresDB is unbundled and available at D:\program files\PostgresSQL\14.

    Version of PostgresSQL is 14.8.

    The Qlik Sense Repository database service is removed already and not present in services.

     

    I need to upgrade Qlik Sense from Nov 2024 to May 2025 , Please guide me steps and things to take care?

    Few queries from my side? 

    1. I see QPI May 2025 tool available on Qlik downloads, May I know do we need to use it in Upgrade of Qlik Sense or my server already has 14.8 version, no need to do anything with it?

    2. what backup is must to restore the complete site i.e. repo dump etc?

    3. In case in future I need to upgrade PostgresSQL14.8 to PostgresSQL 16, how to do it? any document is available ?

     

    Thanks in advance

    Rohit

    Show Less
  • forum

    Qlik NPrinting

    Access to all NewsStand Reports

    I am a Qlik Sense and NPrinting developer. What permissions do I need to be able to see all the reports in the NewsStand? The former guy just seemed t... Show More

    I am a Qlik Sense and NPrinting developer. What permissions do I need to be able to see all the reports in the NewsStand? The former guy just seemed to receive every single NPrinting report- lots of emails. I would just like to see all the reports being sent there and encourage company use. I currently have the Administrator role in NPrinting which has everything checked for Apps, Users, and Admin. What am I missing?

    Show Less
  • forum

    Visualization and Usability

    Pivot table to show text field in measures

    I'm trying to produce a pivot table that shows who each task is assigned to and the % complete that task is. What I'm actually getting is just the one... Show More

    I'm trying to produce a pivot table that shows who each task is assigned to and the % complete that task is.

    orangebloss_0-1752579940025.png

     

    What I'm actually getting is just the one name - so if there is a Task3 with Nigel against it it also shows it as allocated to Task 2 and TaskName.  Is there a way around this? I need to be able to roll up the data for overall % complete which is why a straight table isn't sufficient but I can't find a away to show where more than one person is responsible for the subtasks?

    Subtasks have been created using hierarchy:

    Tasks:
    Hierarchy ( TaskId,TaskParentTaskId,TaskName,'ParentTask')

     

    I have tried mapping but the same issue occurs - any help or suggestions appreciated


    Carol

     

    Show Less
  • forum

    QlikView App Dev

    Expression Attribute Background Color problem

    Hello All-I have a stacked bar chart that represents an Opportunity Pipeline. The sections of the bars are sales stages for the opportunities and the ... Show More

    Hello All-

    I have a stacked bar chart that represents an Opportunity Pipeline. The sections of the bars are sales stages for the opportunities and the dimension is year-quarter.

    4-1-2014 3-54-01 PM.jpg

    The expression is fairly simple:

    Sum ({<Opportunities.StageGroup = {'Pending','Committed'}

    ,FiscalYearName =

    ,Calendar.RelativeFiscalQuarter = {

           'Current Quarter',

           'Current Quarter + 1',

           'Current Quarter + 2',

           'Current Quarter + 3',

           'Current Quarter + 4'}

      >} Opportunities.Amount)

    In the Expression Attribute Background Color, I have the following expression:

    =If(Opportunities.StageNumber = '5', $(vStg5Color),

      If(Opportunities.StageNumber = '4B', $(vStg4BColor),

      If(Opportunities.StageNumber = '4A', $(vStg4AColor),

      If(Opportunities.StageNumber = '3', $(vStg3Color),

      If(Opportunities.StageNumber = '2', $(vStg2Color),

      If(Opportunities.StageNumber = '1', $(vStg1Color)))))))

    The variables are in the form of:

    =rgb(176,202,142)

    Unfortunately, if I filter on a year (FiscalYearName) outside of the set analysis, it wrecks the colors (this has FY13 selected):

    4-1-2014 3-58-09 PM.jpg

    I've tried with and without the '=' in the variables and also by using the RGB directly in the If statement in the background color.

    Any thoughts on how I can fix it?

    Thanks in advance!

    Mike

    www.fortunecookiebi.com

    Show Less
  • forum

    Qlik NPrinting

    Error "Concurrent connections limit exceeded" After Upgrading to NPrinting Febru...

    Hi All,After upgrading Qlik NPrinting from September 2019 to February 2025 SR1, we encountered an issue where reports are not sent to some user emails... Show More

    Hi All,

    After upgrading Qlik NPrinting from September 2019 to February 2025 SR1, we encountered an issue where reports are not sent to some user emails. The tasks run successfully, but some emails fail to deliver with the following error message:

    20250714065008 Error Failed to send email for user 'XXXXXXX' {XXXX-XXXX-XXXX-XXXX-XXXX}. ERROR: 4.3.2 Concurrent connections limit exceeded. Visit https://aka.ms/concurrent_sending for more information. [Hostname=server.outlook.com]

    Previously on NPrinting September 2019, all reports were sent without any issues.

    We have contacted support and already tried adjusting the following parameters in the scheduler.config file as suggested in the release notes:

    • max-mail-client-connection-attempts: (default is 2)

    • mail-client-connection-attempts-delay-ms: (default is 500 ms)

    Reference: https://community.qlik.com/t5/Release-Notes/Qlik-NPrinting-Release-notes-February-2024-Service-Release-3/ta-p/2474564#:~:text=SMTP%20connection%20retry%20configuration 

    Despite these changes, the problem persists. We’re unable to ask the SMTP admin to change server-side settings, especially since everything worked fine before the upgrade.

    Has anyone else experienced this issue after upgrading? Any advice or workarounds would be greatly appreciated.

    Thanks

    Show Less
  • forum

    Visualization and Usability

    Default view in the qliksense container is not working

    Hi,I put 4 charts in a container and each chart has the enable using buttons to with condition visible. like click on button the chart will visible. B... Show More

    Hi,

    I put 4 charts in a container and each chart has the enable using buttons to with condition visible. like click on button the chart will visible. But when edit sheet is completed the container is not able to show the default view as i updated the default chart view. Please help to keep the default view in container

    Show Less
Leaderboard

Customer Story

Instant Answers Empower Thousands of Users

Billion-dollar organization delivers quality service and consistency at scale with Qlik Answers, powered by Amazon Bedrock.

Customer Story

Empowering Students With Data Skills for Real-World Impact

Thomas More University works with the Qlik Academic Program and EpicData to encourage and inspire students.

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

Qlik en México

Qlik en México

Únete a la conversación con usuarios de Qlik en todo México: comparte ideas, haz preguntas y conéctate en español.

All are welcome

Hello from Japan

Japan

Qlik Communityの日本語のグループです。 Qlik製品に関する日本語資料のダウンロードや質問を日本語で投稿することができます。

Request to join

Parlons Données

Parlons Données

Connectez-vous avec des utilisateurs francophones de Qlik pour collaborer, poser des questions et partager des idées.

open to all

Forums

Qlik Automate

Less manual work, more data flow. Welcome to Qlik Automate.

Forums

Qlik Predict

Discover how to leverage machine learning and AI to forecast outcomes directly in Qlik.

Forums

Move to Qlik Cloud Analytics

Get guidance, tips, and community support for your journey to Qlik Cloud Analytics.