Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have deployed the app Application Automations Monitoring v1.1 in the SaaS tenant and was reloading successfully till last month.
Now, the reload fails with error below. No changes have been made to the data connection.
Any ideas on how to fix it?
PERIOD_YEAR_MONTH | Equity current period | Equity Previous Year December |
2024-03
2024-02
2024-01
2023-12
2023-11
--
--
2023-01
2022-12
|
324234
755456
342555
657574
2131821
--
--
485325
723944
|
657574
657574
657574
723944
723944
--
--
723944
|
Hi all
How can I prevent users from modifying the order and width of columns in tables within Qlik Sense SaaS?
After deployment, certain users consistently rearrange columns in tables, leading to issues and support tickets when they can’t restore the original layout.
Is there a feature or setting in Qlik Sense SaaS that can restrict users from modifying column order and width to maintain consistent table layouts?
Thank you very much
Hi, I would like to calculate rolling sum like in the table below. Data should be grouped by column "Family". For each quarter I want to take a look at current quarter and 2 quarters backwards. Any idea how to achieve this in script editor? I am not interested in set analysis using rangesum - above combination. Column "Quarter" comes from fiscal master calendar.
Thank you.
Family | Quarter | Qty | RollingSum3 | Family,Quarter,Qty |
A | FY2023Q2 | 10 | 10 | A,FY2023Q2,10 |
A | FY2023Q3 | 20 | 30 | A,FY2023Q3,20 |
A | FY2023Q4 | 30 | 60 | A,FY2023Q4,30 |
A | FY2024Q1 | 40 | 90 | A,FY2024Q1,40 |
A | FY2024Q2 | 50 | 120 | A,FY2024Q2,50 |
A | FY2024Q3 | 60 | 150 | A,FY2024Q3,60 |
A | FY2024Q4 | 70 | 180 | A,FY2024Q4,70 |
B | FY2023Q2 | 5 | 5 | B,FY2023Q2,5 |
B | FY2023Q3 | 10 | 15 | B,FY2023Q3,10 |
B | FY2023Q4 | 15 | 30 | B,FY2023Q4,15 |
B | FY2024Q1 | 20 | 45 | B,FY2024Q1,20 |
B | FY2024Q2 | 25 | 60 | B,FY2024Q2,25 |
B | FY2024Q3 | 30 | 75 | B,FY2024Q3,30 |
B | FY2024Q4 | 35 | 90 | B,FY2024Q4,35 |
شَيْخٍ رَوْحَانِيٍّ مُعْتَمَدْ ✅0َ0َ4َ4َ7َ3َ1َ2َ2َ1َ8َ4َ6َ3َ✅ جَلْبُ اَلْحَبِيْبَ خِلَاْلَ سَاْعَةٍ وَاْحِدَةْ، يـُمكنكم طرح مشاكلكم والحديث عنها بالتفصيل مع فضـيـلـة الشيخ الروحاني المعتمد عبر واتـسـاب.
؟؟؟؟
Hello Experts
Our customer has upgraded v2022.05 to v2023.11 and encountered the problem below:
In 2022.05, when the following warning occurred, CDC task continued without any errors.
[TARGET_LOAD ]I: Load finished for table 'ADM'.'XXXXX' (Id = 1). 85627944 rows received. 0 rows skipped. Volume transferred 98611582288. (streamcomponent.c:3976)
[TARGET_LOAD ]I: TPT statistics for table 'REP.YYYYY': Operator=LOAD, CPU time=1115.296875, Received Rows=85627944, Sent Rows=85627944, Applied Rows=85627917 (teradata_tpt_engine.cpp:778)
[TARGET_LOAD ]W: Not all rows have been loaded successfully for 'REP'.'YYYYY' due to possible 'TPT LOAD' errors. Consult Target 'xxxx_E?' / 'xxxx_L?' Error / Log tables contents. (teradata_tpt_engine.cpp:786)
[TARGET_LOAD ]I: teradata_terminate_tpt(...) successfully applied conn->Terminate() method for task identified by UUID '74a9fd96-8335-5944-bb67-6aaa83fb3782' (teradata_tpt_engine.cpp:839)
[TASK_MANAGER ]I: Loading finished for table 'ADM'.'XXXXX' (Id = 1) by subtask 1. 85627944 records transferred. (replicationtask.c:3012)
[TARGET_LOAD ]I: teradata_stop_imp(...) stopping task identified by UUID '74a9fd96-8335-5944-bb67-6aaa83fb3782' (teradata_endpoint_imp.c:857)
[TARGET_LOAD ]I: teradata_free(...) freeing resources for task identified by UUID '74a9fd96-8335-5944-bb67-6aaa83fb3782' (teradata_endpoint_imp.c:878)
[TARGET_LOAD ]I: teradata_disconnect(...) disconnecting for task identified by UUID '74a9fd96-8335-5944-bb67-6aaa83fb3782' (teradata_endpoint_imp.c:92)
[TARGET_LOAD ]I: teradata_disconnect(...) disconnecting Data Connection succeeded for task identified by '74a9fd96-8335-5944-bb67-6aaa83fb3782' (teradata_endpoint_imp.c:104)
[TARGET_LOAD ]I: teradata_disconnect(...) No active Lookup Connection to disconnect from was detected for task identified by '74a9fd96-8335-5944-bb67-6aaa83fb3782' (teradata_endpoint_imp.c:122)
[TASK_MANAGER ]I: Subtask #1 ended (replicationtask_util.c:591)
However the behavior has changed after upgrading to v2023.11.
After the same warning occurred, it is detected as an error and the table is suspended.
[TARGET_LOAD ]I: Load finished for table 'ADM'.'XXXXX' (Id = 1). 85986652 rows received. 0 rows skipped. Volume transferred 99014228864. (streamcomponent.c:4076)
[TARGET_LOAD ]I: TPT statistics for table 'REP.YYYYY': Operator=LOAD, CPU time=1126.937500, Received Rows=85986652, Sent Rows=85986652, Applied Rows=85986625 (teradata_tpt_engine.cpp:781)
[TARGET_LOAD ]W: Not all rows have been loaded successfully for 'REP'.'YYYYY' due to possible 'TPT LOAD' errors. Consult Target 'xxxx_E?' / 'xxxx_L?' Error / Log tables contents. (teradata_tpt_engine.cpp:789)
[TARGET_LOAD ]I: teradata_terminate_tpt(...) successfully applied conn->Terminate() method for task identified by UUID '74a9fd96-8335-5944-bb67-6aaa83fb3782' (teradata_tpt_engine.cpp:846)
[TARGET_LOAD ]E: TPT data acquisition failed [1020403] (teradata_endpoint_imp.c:1480)
[TARGET_LOAD ]E: Handling End of table 'REP'.'YYYYY' loading failed by subtask 1 thread 1 [1025000] (endpointshell.c:3069)
[TASK_MANAGER ]W: Table 'ADM'.'XXXXX' (subtask 1 thread 1) is suspended. TPT data acquisition failed; Handling End of table 'REP'.'YYYYY' loading failed by subtask 1 thread 1 (replicationtask.c:3208)
Is there any options to ignore the warnings/errors and continue the task like v2022.05?
Any advice would be appreciated.
Regards,
Kyoko Tajima
let prevmon=date(addmonths(today(),-1),'MMM YYYY');
LOAD
"As of Date",
"xxxx",
"xxx",
"XXXX",
"XXXX"
FROM [lib://Source/SourceLanding/Reports/monthlyDetail report as of $(prevmon).xls]
(biff, embedded labels, table is [qry For Comments$]);
Hi,
I am wondering when I have a source lookup on a column in a table, then I also have a filter on the table. What comes first? Are the records filtered then the source lookup occurs? or does the source lookup occur then the rows are filtered?
Regards,
Mo
Hello, I am trying to write a program where it will alert me when a program has failed, like in the QMCshows failed. Could you please share the URL API for the endpoint I need to use? Thanks.
Hello everyone,
I have a problem with RangeSum, I want to hide the red line from June to December 2024, this part of the fold does not make any sense in the chart. How do I hide it? Thank you!
Additionally,Grey and black lines need to show data for 12 months of the year.
The measure used for the red line: RangeSum(Above(SUM({<Year={2024}>}QTY),0,RowNo()))
Wondering about Qlik Talend Data Integration Sessions? There are 11, in addition to all of the Data & Analytics. So meet us in Orlando, June 3 -5.
Join us on May 15th at 11 AM ET to discuss the Qlik Ideation Process. Bring your questions.
Browse our helpful how-to's to learn more about navigating Qlik Community and updating your profile.
Your journey awaits! Join us by Logging in and let the adventure begin.
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.
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.
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!