Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have this load script for one of my app in Qliksense.
Table1:
Load
First_Name,
Last_Name,
Salary,
Fiscal_Year
SQL Select
FirstName as First_Name,
LastName as Last_Name,
Salary,
FY as Fiscal_Year
From XYZ_Table
In the sheet, I have this simple table with Fiscal_Year column that shows all the data for all the years.
User requested to filter the data to only shows the current year and two previous years. I have adjusted my code to this:
Table1:
Load
First_Name,
Last_Name,
Salary,
Fiscal_Year
SQL Select
FirstName as First_Name,
LasrName as Last_Name,
Salary,
FY as Fiscal_Year
From XYZ_Table
WHERE Fiscal_Year >= (YEAR(GETDATE())-2); //to get only year 2024 and 2023,2022//
It loaded successfully and I got no errors, but when I go to my table in the sheet, I still see years from 2016-2021
I am not sure what I am missing. Could someone please help me with this?
thank you!
Hi Qlik experts,
I created several Qlik Sense apps at Qlik Sense Server, and also uploaded several Qlik Sense apps to Qlik Sense Server.
The Qlik Sense Server will terminate.
How could I backup all my Qlik Sense apps at Qlik Sense Server? So, I will not lose my Qlik Sense apps.
Thanks for your help!
Hi,
In the Qlik app 'License Monitor', all my users on the 'User Detail' sheet are UNKNOWN.
I have looked in the load editor script and I can see that there is a mapping table to retrieve the user's name. Looking at the information the responses returned for both tables, the user id's do not match leading to the default value in the ApplyMap.
Does anyone has any idea why this may be happening?
Thanks,
Amy
I would like answers to the following three questions about the GetTaskDetails API:
■What I confirmed by checking the response is:
・total_latency is 00:00:00, indicating no latency.
・All incoming_XXX values are 0, suggesting no unapplied changes.
・commit_change_records_count is 16126, while applied_records_comitted_count is 0, indicating a discrepancy.
■The status of the task when this response is returned
・The task is running when GetTaskDetails is executed ('state': 'RUNNING').
・There are no errors or warnings in the task log.
・SAP Application source is used (with SAP HANA as the backend using trigger-based CDC), and no filters are set on the task.
Hi Support Team,
There are 「Advanced Run Options」 available for Qlik tasks.
You can select the following in 「Tables are already loaded. Start processing changes from:」.
・Date and Time
・Source change position
In the REST API RunTask there is an option "RESUME_PROCESSING_FROM_TIMESTAMP",
I think this is the same function as 「Date and Time」.
Please tell me how to specify 「Source change position」 as a RunTask option.
hi there,
i have a client who does not want the vendors to access qlik sense via Local AD and Domain AD. what other approach i can look at to allow the user to access to qlik sense?
Please help please help!
Thanks
Jim
Hi Support Team,
I checked the status of the task in Enterprise Manager's Message Center.
When executing the 「FULL+CDC」 task, TYPE was output in the following order.
・TASK_START
・TASK_FULL_LOAD_STARTED
・TASK_FULL_LOAD_FINISHED
After stopping the task and restarting it with "Resume", the TYPE was output in the following order.
・TASK_STOP
・TASK_START
・TASK_FULL_LOAD_STARTED
Since it is 「Resume」, FULLLOAD will not be executed,
but 「TASK_FULL_LOAD_STARTED」 was displayed in the Message Center.
I have a question about the TYPE 「TASK_FULL_LOAD_STARTED」 at this time.
・Why is 「TASK_FULL_LOAD_STARTED"」 output even when I select 「Resume」?
・For what kind of operations will 「TASK_FULL_LOAD_STARTED」 be output?
We are triggering replicate by using scheduling tool and periodically checking the status if replicate completed or not. Although the replicate load is going success the job is failing with the error Failed to rename file repcmd.log to repcmd__240417043324.log .
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.
Browse our helpful how-to's to learn more about navigating Qlik Community and updating your profile.
Join us on April 24th at 10 AM ET for the next Do More with Qlik webinar focusing on Qlik’s Data Integration & Quality solutions.
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!