Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Experts,
How can I send PDF reports via email from Qlik Sense (November 2022 release) without using NPrinting?
Are there any alternative methods or workarounds to automate the process of emailing reports?
Thank you for your responses.
#QS NOV22
Hi Support,
When using Amazon Kinesis as a target endpoint in a Replicate task, there is a prerequisite to create a stream called 'attrep_apply_exceptions' so that the Apply Exceptions control table can be written to the target.
If the remaining control tables (attrep_status, attrep_history, etc.) are required, does a stream need to be created for each using the exact name of the control table? i.e. If you want to enable attrep_status, would you need to create a stream called 'attrep_status'?
Thanks,
Nak
Is it possible to display filters with no data when generating a Word report?
I know you can use getCurrentSelections() to display the current filters, but it only shows the filters that have data.
For example, if you include all months in the filter, getCurrentSelections() will only show the months that have data, and omit the ones with no data.
I have created the attached dummy application in Qlik Sense Cloud, and I want to make the result of a measure and the value of a ValueList() both bold.
pivot table
In the above screenshot the text Total is coming from this ValueList('Total', 'Customer A', 'Customer B') while the sales measure is calculated using this expression:
if(ValueList('Total','Customer A','Customer B')='Total',sum(Sales),
if(ValueList('Total','Customer A','Customer B')='Customer A',sum({$<Customer={'A Superior System'}>}Sales),
if(ValueList('Total','Customer A','Customer B')='Customer B',sum({$<Customer={'A-2-Z Solutions'}>}Sales),
Null())))
What I want is to make both the Total label and the total sum Bold and Red. What I have tried at least for the measure expression is the below statement in the Text Color Expression box:
if(ValueList('Total','Customer A','Customer B')='Total',rgb(255,0,0) and '<b>',DarkGray())
However, the above statement does not return the expected result because this bold expression '<b>' works in QlikView only, while I use QlikSense. Is there any workaround?
I have attached the qvf file and the two xlsx files with the dummy data.
Hello, I need to know in real-time the minutes that users with a "Capacity" license are consuming. I can't find the application within "Monitoring" in Qlik SaaS. Can you help me?
Thanks in advance
Good morning Qlik Community.
I am having problems implementing Qlik Tabular Reporting on a client. I have the following problem as an example:
"This Qlik Sense app could not be loaded: test with alen app tabular. Please verify the following app ID: 69b3bd8f-efef-4841-a52d-89a2787c3434"
This happens with all, all apps, for all users, even in personal spaces... it goes without saying that also in Shared spaces with all permissions, including the tenant admin with all the permissions and roles required with a professional license...Even with apps created on the fly with a simple inline table without section access.
This occurs when selecting an app to build the report.
I have a ticket with Qlik Support in progress, however, has anyone in the community faced this issue?
Thank you very much for taking the time to review this post.
If we manage to resolve the problem with Qlik Support, I will put the resolution in this post so everyone can solve the problem.
Hello everyone.
I would like to ask for your help with a very important topic: I want to create a cumulative total in a table. The problem I have is that when I perform the cumulative calculation, the RowNo()
function distorts a column that should be sorted in descending order.
Now I am going to show you a table that is working.
You can see that I have a table of quantity sorted in descending order, your participation and the cumulative participation all in percentages.
Quantity: Sum({<%Flag_Invoice={1}>} QUANTITY * If(IsNull(MENGE.STPO), 1, MENGE.STPO) * Sign)
Cumulative %Participation:
Sum({<%Flag_Flag_Invoice={1}>} QUANTITY * If(IsNull(MENGE.STPO), 1, MENGE.STPO) * Sign)
/
Sum(TOTAL{<%Flag_Invoice={1}>} QUANTITY * If(If(IsNull(MENGE.STPO), 1, MENGE.STPO) * Sign)
%Accum:
RangeSum(Above($(v%_Accumulated_Quantity),0,RowNo(TOTAL)))
Being the variable $(v%_Accumulated_Cant) equal to %Accum Share I did it this way just to make it look neater.
BUT!
When I add an extra dimension, my quantity gets messed up and doesn't look right.
NOTES:
In the sort tab I set the first dimension to sort by expression and the rest I unsorted the sorts and it didn't work either.
What can you do!
Please!!!
Regards
Environment Details:
Qlik Environment:
Data Source Environment:
Issue Description:
We are encountering an issue following the recovery process of disaster recovery by moving the file to a different Qlik server.
Steps Followed:
Additional Observations:
Error Message:
Upon changing the log level to trace, the following error messages were observed:
00002188: 2025-02-10T16:34:35:924215 [IO ]V: combine_path: rootPath=<f:\mware\Attunity\Replicate\data\logs>, addPath=<f:\mware\Attunity\Replicate\data\logs> (at_dir.c:1014)
00002188: 2025-02-10T16:34:35:924215 [IO ]V: combine_path: result before canonize=<f:\mware\Attunity\Replicate\data\logs\clean_old_logs.bat> (at_dir.c:1025)
00002188: 2025-02-10T16:34:35:924215 [IO ]V: combine_path: result=<f:\mware\Attunity\Replicate\data\logs\clean_old_logs.bat> (at_dir.c:1031)
00002188: 2025-02-10T16:34:35:924215 [IO ]V: combine_path: rootPath=<f:\mware\Attunity\Replicate\data\logs>, addPath=<f:\mware\Attunity\Replicate\data\logs> (at_dir.c:1014)
00002188: 2025-02-10T16:34:35:924215 [IO ]V: combine_path: result before canonize=<f:\mware\Attunity\Replicate\data\logs\reptask_UNI-SRC-FSHD-01-TGT-FRPT-UV.log> (at_dir.c:1025)
00002188: 2025-02-10T16:34:35:924215 [IO ]V: combine_path: result=<f:\mware\Attunity\Replicate\data\logs\reptask_UNI-SRC-FSHD-01-TGT-FRPT-UV.log> (at_dir.c:1031)
00002188: 2025-02-10T16:34:35:924215 [IO ]V: combine_path: rootPath=<null>, addPath=<null> (at_dir.c:1014)
00002188: 2025-02-10T16:34:35:924215 [IO ]V: combine_path: result before canonize=<F:\mware\Attunity\Replicate\data\logs\reptask_UNI-SRC-FSHD-01-TGT-FRPT-UV.log> (at_dir.c:1025)
00002188: 2025-02-10T16:34:35:924215 [IO ]V: combine_path: result=<F:\mware\Attunity\Replicate\data\logs\reptask_UNI-SRC-FSHD-01-TGT-FRPT-UV.log> (at_dir.c:1031)
00002188: 2025-02-10T16:34:35:924215 [IO ]V: combine_path: rootPath=<f:\mware\Attunity\Replicate\data\logs>, addPath=<f:\mware\Attunity\Replicate\data\logs> (at_dir.c:1014)
00002188: 2025-02-10T16:34:35:924215 [IO ]V: combine_path: result before canonize=<f:\mware\Attunity\Replicate\data\logs\reptask_UNI-SRC-FSHD-01-TGT-FRPT-UV__250210163435.log> (at_dir.c:1025)
00002188: 2025-02-10T16:34:35:924215 [IO ]V: combine_path: result=<f:\mware\Attunity\Replicate\data\logs\reptask_UNI-SRC-FSHD-01-TGT-FRPT-UV__250210163435.log> (at_dir.c:1031)
00002188: 2025-02-10T16:34:35:924215 [INFRASTRUCTURE ]I: Crypto mode: Standard. (at_logger.c:1573)
00002188: 2025-02-10T16:34:35:924215 [INFRASTRUCTURE ]V: thread allocation for converter <0> (at_text.c:725)
00002188: 2025-02-10T16:34:35:924215 [INFRASTRUCTURE ]V: cloning converter, cd 0 (at_text.c:581)
00002188: 2025-02-10T16:34:38:925173 [IO ]T: rep_net_server_select: Server poll timeout. failed (at_repnet.c:489)
00002188: 2025-02-10T16:34:38:925173 [IO ]V: rep_net_server_select:489: Failed (at_repnet.c:550)
00002188: 2025-02-10T16:34:41:925582 [IO ]T: rep_net_server_select: Server poll timeout. failed (at_repnet.c:489)
00002188: 2025-02-10T16:34:41:925582 [IO ]V: rep_net_server_select:489: Failed (at_repnet.c:550)
Request for Assistance:
We seek assistance in diagnosing and resolving the following:
Additional Information:
We appreciate your prompt assistance in resolving this issue.
Bonjour à tous,
Je calcule la moyenne de mes ventes sur l'ensemble de mes données. Et j'aimerais avoir en deuxième mesure, la moyenne de mes ventes qui s'arrêtent à la semaine dernière.
Faire comme ça, mais au lieu de "last month" que ça soit "last week".
Data load with OLEDB Provider for oracle post Qlik upgrade to May2024 is very slow
We have 67 million records to load from Oracle database, but data load is not completing even after waiting for 15+ hours
We tried different configurations for FETHSIZE, but it is not working. Could anyone help.
We are thrilled to announce that the new Qlik Learning will launch on February 17, 2025.
Data Flow simplifies, democratizes, and accelerates the last mile of data preparation for analytics, machine learning, and AI.
From product innovation, to technical tips and tricks, to real world success stories, Qlik Connect offers learning opportunities for all levels.
Read how to embed AI-powered analytics to innovate, enhance customer satisfaction, and fuel business growth.
Your journey awaits! Join us by Logging in and let the adventure begin.
Qlik enhances decision-making with high-speed insights, as Mayborn Group integrates data from various functions across their global operations, gaining a competitive edge in the childcare industry.
Nortera leads agricultural manufacturing analytics and automation with Qlik, reducing short-shipment rates and annual savings in water consumption.
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!
A private group is for healthcare organizations, partners, and Qlik healthcare staff to collaborate and share insights..
Qlik Communityの日本語のグループです。 Qlik製品に関する日本語資料のダウンロードや質問を日本語で投稿することができます。
Welcome to the group for Brazil users. .All discussions will be in Portuguese.
Hear from your Community team as they tell you about updates to the Qlik Community Platform and more!