Hi,
you’ll need to work around its limitations since Qlik Sense does not allow direct editing or updates to the source data. You can achieve the desired result using input variables, a partial reload script, and some data transformations.
First of all verify your dataset is loaded in Qlik Sense, ideally with the "Employee ID" as a unique identifier.
Then go to Variables Editor in the Qlik Sense app and create a new variable (e.g., vNewSkill) where the end user can input the new skill they want to add (e.g., "Bricklaying").
Add a filter pane to the app and select the field "Employee ID".
This allows the end user to select the employees whose skills need updating.
To support bulk updates, you’ll need to modify your script to accommodate the changes dynamically during a Partial Reload.
Load Script Example:
// Main Load Script
Employees:
LOAD
[Employee ID],
[Physical Skills]
FROM [YourDataSource]
WHERE NOT Exists([Employee ID], TempUpdates.[Employee ID]);
// Temporary Table for Updates - Filters the data to include only the selected Employee IDs (vSelectedIDs)
TempUpdates:
LOAD
[Employee ID],
[Physical Skills]
RESIDENT Employees
WHERE Exists([Employee ID], '$(vSelectedIDs)');
// Append New Skill - Appends the new skill to the existing skills of the filtered employees.
UpdatedSkills:
LOAD
[Employee ID],
[Physical Skills] & IF(Len([Physical Skills]) > 0, '; ', '') & '$(vNewSkill)' AS [Physical Skills]
RESIDENT TempUpdates;
// Replace with Updated Data - Adds the updated records back into the main dataset (Employees).
CONCATENATE (Employees)
LOAD
*
RESIDENT UpdatedSkills;
// Drop Temporary Tables
DROP TABLE TempUpdates;
DROP TABLE UpdatedSkills;
Add a button to your app with the label "Update Skills".
Configure the button to perform a Partial Reload when clicked.
This method should provides a dynamic and scalable way to enable bulk updates in Qlik Sense without directly modifying the source data.
