Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 .
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.
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
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.
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.
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
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?
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 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
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.
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):
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
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)
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
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
Watch expert-led sessions from Qlik Connect 2025 to see how our latest innovations help you integrate and analyze data.
Salesforce's acquisition of Informatica brings change. Explore options for a smoother transition.
See why Qlik was named a Leader in the 2025 Gartner® Magic Quadrant™ for Analytics and Business Intelligence Platforms.
We’re excited to introduce the ability to manage automations in shared spaces, enabling collaboration and execution through the context of a shared space.
A one-day focused event designed to give you practical strategies and real-world use cases for transforming data, analytics, and AI.
Your journey awaits! Join us by Logging in and let the adventure begin.
Billion-dollar organization delivers quality service and consistency at scale with Qlik Answers, powered by Amazon Bedrock.
Thomas More University works with the Qlik Academic Program and EpicData to encourage and inspire students.
Qlik Data Integration transforms Airbus' aircraft production, leading to over 150 replication tasks and informing more efficient analysis.
Join one of our Location and Language groups. Find one that suits you today!
Únete a la conversación con usuarios de Qlik en todo México: comparte ideas, haz preguntas y conéctate en español.
Qlik Communityの日本語のグループです。 Qlik製品に関する日本語資料のダウンロードや質問を日本語で投稿することができます。
Connectez-vous avec des utilisateurs francophones de Qlik pour collaborer, poser des questions et partager des idées.
Discover how to leverage machine learning and AI to forecast outcomes directly in Qlik.
Get guidance, tips, and community support for your journey to Qlik Cloud Analytics.