Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Qlik Support,
In a Log Stream setup, when a Down stream task receives the warning "Changes are not being captured", does that warning indicate that the down stream task has processed all the staged changes from the staging folder or does it simply mean that the staging task has been stopped?
We are trying to determine a method to identify when a down stream task has processed all the changes in the Log stream staging folder after the staging task has been stopped.
Thanks,
Nak
Completely new to Qlik. I'm been asked to create a a "Domino's pizza tracker" like graphic that is colored based on the status of the activity. A user could then click on a "section" to get more details. Does anyone know how I could go about creating something like this?
@Dataintellinalytics
I am trying to create a pivot table that shows "Current Sales" and "Previous Month Sales" for each "month year"
Data:
SalesDate | Product | Amount |
10/1/2023 | Chair | 50 |
15/1/2023 | Fan | 100 |
24/2/2023 | Chair | 82 |
23/2/2023 | Fan | 72 |
14/3/2023 | Chair | 132 |
13/3/2023 | Fan | 56 |
10/1/2024 | Chair | 50 |
15/1/2024 | Fan | 100 |
24/2/2024 | Chair | 82 |
23/2/2024 | Fan | 72 |
14/3/2024 | Chair | 132 |
13/3/2024 | Fan | 56 |
Expected outcome in Pivot Table
Product | Jan-23 | Feb-23 | Mar-23 | Jan-24 | Feb-24 | Mar-24 | ||||||
Current Month | Previous Month | Current Month | Previous Month | Current Month | Previous Month | Current Month | Previous Month | Current Month | Previous Month | Current Month | Previous Month | |
Chair | 50 | 0 | 82 | 50 | 132 | 82 | 50 | 0 | 82 | 50 | 132 | 82 |
Fan | 100 | 0 | 72 | 100 | 56 | 72 | 100 | 0 | 72 | 100 | 56 | 72 |
Hope you can help me to solve this requirement 🙂
Thank you very much for your assistance!
Hi Team,
We need to encrypt PII columns from the source and also need to decrypt them if needed.
Any ideas how can we do it .
Sources : Oracle, SQL Server
Target: Postgresql
Regards,
Gayatri,
Hi
Can any one please explain about Audit, System & Trace logs?
May more specifically Engine, Repository & Proxy logs.
Thanks in advance.
https://docs.google.com/spreadsheets/d/1pjrsxpb9EO1XFo-AqZ6kGXxZDQOsh1ajxJF3kSUR0x0/edit
https://docs.google.com/drawings/d/1R09g2EigdWeYajnbvGdAn_1RP5fiL9tUnLZAB6SSb6Q/edit
https://docs.google.com/document/d/1RFX9799S6jmoYJYbv62y-89B7yLo19Ur-ZDMPRLMJIc/edit
https://docs.google.com/forms/d/e/1FAIpQLScWCmK9xhctGE73uoh6d4krEICcBAnu3LnNyu7X98CDs8Wnzg/viewform
https://docs.google.com/presentation/d/1GKkHM3tdctGXpR462IIoSuR7d08B0TuBq_MfqYjuIZg/edit
https://www.google.com/maps/d/edit?mid=1TuLOywMgjdYhlH7wMUbOY8GnW7GpRyo
https://colab.research.google.com/drive/1nucDzd9cVU2zmF4M6uoVpzJM-SowYCZD
hii,
I need to create a key with 5 fields in comun but i need to keep those fields on both tables when loading.
Saleskit:
LOAD
"Year",
"Sales Country",
"Sales Manager",
"Sales rep",
"Sales Role",
"LATAM Lara BP code",
"Master Customer Name",
"Customer name",
Direction,
"Vol. Budget (Teus)",
Segmentation,
Category,
"Month",
"Week"
FROM [lib://External source files/saleskit.qvd]
(qvd);
Database:
LOAD
Service,
Voyage,
Vessel,
Booking,
BL,
"Year",
"Month",
"Week",
"LATAM Lara BP code",
Direction
FROM [lib://External source files/export.qvd]
(qvd);
They key needs to be with the fiels ("Year"&"Month"&"Week"&"LATAM Lara BP code"&Direction).
The problem is that if i keep all the 5 fields on both table the Qlik will create another synthetic key automaticaly, which i cannot use.
and i cannot not load all the 5 fields from both tables, because i need a "full outer join".
thankss, Karine.
HI,
I attached the source data and I dont have any values or 0 in the source for the year 2023. but when i use the line chart, I can see that value 0 is populated for the year 2023 and for the months mar till dec.
so I dont want to populate 0 in the line chart if it is not available in source, if 0 exists in the source then only i want to populate it in the line chart. Please help me to solve this issue.
Dimension used is : MasterMonth
Measure used is : 1 ) 2022: sum({<MasterYear = {"2022"}>}distinct NumOFPolicies)
2 ) 2023: sum({<MasterYear = {"2023"}>}distinct NumOFPolicies)
I know there are a ton of topics about it, but I'm the next to get this problem: the connection between office and nprinting does not work. It used to work on my old computer but fails there - even as I did install (and now reinstalled twice) office 2019 especially for that goal.
I don't get it working on my new computer with office 365, including trying the tips on this forum and two nPrintingDesigner versions.
Has anybody an idea what to try next? Or is there any help out there?
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
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!